Must Learn Topics

1)PLSQL
    1)Collections with examples L1
    2)Cursors
    3)Bulk Collect and For all L1
    4)Standard APIs(FIlE_UTL, )
    5)SQL and PLSQL performance tuning L1
    6)NOCOPY hint L1
    7)Case vs Decode L1
    8)Union vs Union All
    9)Char vs Varchar2 L1
  10)In vs Exists L1
  11)Not In vs Not Exists L1
  12)Delete vs Truncate vs Drop L1
  13)Views vs Materialized Views L1
  14) Sql WITH clause L1
  11)FAQ L1

2)XMLP L1
    1)XML File- Parameters, Queries, Triggers, No Data Found,
    2)Templates- Functions, Grouping, Looping, Page Break, Section Break, Page Total, Grand Total, Page Nums, Header and Footers, Repeat Table Header in all pages, Date Formats
    3)Templates-Lang Translation Files(xlf) 
    4)Bursting-Emails
    5)Barcode in RTF templates L1
    6)FTP

3)SQL Loader
    1)Load to Multiple tables, Load from Multiple Files
    2)Keywords and Syntax, Usages
    3)FAQ L1

4)OAF
    1)Interview questions from redsalt L1
    2)Look into some examples(external lov, ) from quoting, MPW, iAssets files

5)Web ADI.
    1) Some basic concepts L1
    2) Sample program. L1
    3) Real time example

6)Oracle Reports
    1)All Interview questions from redsalt
    2)Creating different types of CP
    3)Formula, Summary and Place Holder columns L1

7)Oracle Forms
    1)All Interview questions from redsalt
    2)Custom.pll vs Personalization
    3)Forms Template

8)Interfaces and Conversion L1 L2
    1)MTL Interfaces tables with example(loading into staging, validation, loadint to interface tables, submit Trx Manager API)
    2)Diff imnput parameters for Trx Manager
    3)Invoice Interface tables and one example(loading into staging, validation, loading to interface tables, submit Trx Manager API)
    4)Order Interfacing(Tables names, Program Names) L1
    5)Custom Interfaces(Inbound and Outbound)
    6)Sample Interfaces L1
    7)Interface Error Tables L1

9)Standard Tables and APIs
    1)OM, Shipping tables, flags, relationship, OE_ORDER_PUB.Process_order
    2)Quoting tables, flags, relationship
    3)Pricing tables, flags, relationship
    4)iAssets tables, flags, relationship
    5)Inventory tables, flags, relationship
    6)Payables tables, flags, relationship
    7)GL tables, flags, relationship
    8)TCA tables, flags, relationship
    9)SLA tables, flags, relationship
    10)PO tables, flags, relationship

10)LIfecycles
    1) O2C Lifecycle in detail L1
    2) P2P Lifecycle in detail
    3) MOAC concept L1
    4) Organization Structure
    5) What is new in R12 compare with 11i L1

11)Import programs
    1)OM, Shipping, AR, Order Import , Req Import
    2)Payables, GL

12)Apps Tech
    1)Types of Value Sets L1
    2)Lookups
    3)DFF vs KFF L1
    4)Detail example for DFF and KFF
    5)Defining CP, Menus, Forms, Responsibility
    6)Defaulting Rules
    7)Profile Options
    8) Diff in 11i and R12 L1
   9) TCA L1

13)Functional
    1)Payables Setups
    2)Payables PPR
    3)Payables Accounts
    4)Payments Types
    5)Types of Invoices and meaning
    6)Expense Reports
    7)GL Concepts