Oracle Apps Module Wise Interview Questions

AP/AR/GL/FA/CM

1) What are cycles of GL, AP, and AR?
2) What id recurring invoices? What are AP setup steps?
3) Interface of the transactions from legacy system to ERP – Conversion Strategy Methodology?
4) What Sub ledgers does Oracle General Ledger 11i Drilldown support?
5) What dependencies have to be loaded to with regard to the future transactions or for upload of Open Transactions in AR?
6) What is an invoice? How many types of invoices are there in AP and AR?
7) What strategy would be adopted to upload the total transactions – open & closed – specifically with regard to the upload of closed AP Invoices, Purchase Orders, and Sales Orders?
8) Explain in brief how the Reconciliation process works in AP & AR?
9)  What are different types of journal entries?
10)  Whether the closed Purchase Orders can be uploaded with back date in PO and also the Sales Orders with back dated – whether the system would permit – what is the methodology?
11)   How is a ‘Specific Transaction’ is entered in AR for which the Auto-Accounting / i.e. overriding an Auto Accounting rule set?
 12)  In case we need to restrict the List of segment Values of Chart of Accounts to the users – methodology – Security Rules / Cross Validations?
13)  What is the functionality of the Dependent Value Set?
14)  How purchase ordered entered in Oracle11i AP module.
15)  Why not a Dependent Value Set should is used?
16)  What are the different scenarios of Revenue Recognition in AR and the Accounting Entries, Is it possible to define a Event Based Revenue Recognition instead of ‘Period Based’ Revenue Recognition?
17)  Once we receive the material what is the entry in Oracle Apps AP?
18)  How are the Cross Currency Payments made in AP?
19)  How the historical data is loaded in all the sub ledgers & as well as GL – do we need to have a separate conversion control account for each of the historical transactions in all the sub ledgers?
20)  How are the open GL Balances loaded & reconciled?
21)  Why a ‘Transaction Type’ does post to GL ‘NO’ is used?
   22)  How are the Receipt Classes works in AR?
   23)  Can we associate Multiple Receipt Classes to a single Payment Method?
   24)  How is the Automatic Payment Program function in AR?
   25)  Explain the Auto-accounting feature in AR How it works?
   26)  What are the standard programs for Oracle GL, AP modules open interfaces?
   27)  Explain the MRC Functionality?
   28)  If MRC is in places and the dual currency reporting is not required – how is it done?
   29)  How do we import Bank Statement in Cash Management?
   30)  How is the Asset Created through Accounts Payable Module?
   31)  How FA Account Generator Works?
   32)  There is one Account which needs to be defined completely with all the segments in place which that Account – FA?
   33)  How is the Asset Defined in FA?

OM / PO / INV
   34)  Which attributes need to be checked in order to get the item in PO form?
   35)  Where do we setup Receiving A/c (Inventory/Purchasing)?
   36)  Explain Matching Concept – PO?
   37)  How to get ‘Direct Receipts’ with 4 Way Match Option is in places (Inventory/Purchasing)?
   38)  How to receive items with less than PO price?
   39)  Where does PPV & IPV get hit?
   40)  PO Gain or Loss Account rate is used?
   41)  Methods of Approvals in Purchasing?
   42)  Case – ‘User A’ Approval Assignment is assigned to User B – How does it affect the approval process?
   43)  How to retrieve PO which is lost due to the above approval assignments?
   44)  What are the different kinds of Purchase Orders?
   45)  How does Internal Requisition works –setups?
   46)  When you setup Shipping Network – What is direct / In-transit type – impact?
   47)  Does it matter if Item is lot controlled in one and not lot controlled in another?
   48)  How does material Overhead work?
   49)  How does Drop Shipment process work?
   50)  After doing purchase release, what happens if changes are made in order?
   51)  Any Report on discrepancies between SO & PO?
   52)  Distribution methodology of Drop shipment?
   53)  Do PPV & IPV come into play for Drop Shipment?
   54) Difference between Delivery & Delivery Line?
   55) What does Release to Warehouse means?

GL & SYS ADMIN
   56)  What is Dependent Validation? When do you use it? Is it advisable to use while defining your Account flex field? What could be the situation where you can use it while defining the AFF?
   57)  What are Security and Cross Validation Rules? How do you set them up?
   58)  How do you setup document sequencing?
   59)  How do associate the category and the sequence to the Transaction for which you are defining the same in the first place?

AP & PO
   60)  Why is my purchase order closing before a receipt is processed?
   61)  Explain the AP Invoice processing cycle right from Invoice creation to transfer to GL in Release 11i?
   62)  Explain the Payment Batch process in detail?
   63)  On what parameters does the system build up the payment batch?
   64)  If U wants to exclude payments to any particular supplier, how do you do it?
   65)   In case U want to exclude payment to only one Invoice of any supplier, how do you do it?
   66)  What are the entries passed when an AP Invoice is created?
   67)  What entries passed for the purchase of an Inventory Item from PO to Invoice?
   68)  Where do you setup the AP Accrual account?
   69)  In case the PO has 4 way matching and the Item has direct routing attached to it. Then what entries    are created when the goods are received and invoiced?
   70)  What is 4 ways matching?
   71)  Can we make payment for a Yen Invoice from a USD Bank? If so how?
   72)  What are EFT Payments, What is the Setup Involved and how the data gets transferred to Bank?
   73)   Is it possible to make a cross currency payment in AP?
   74)  In case a foreign currency Invoice is paid, what are the entries passed?
   75)  From where does the ship to site in the PO flow?
   76)  What is ERS and what are the setups required for ERS?

AR & OM
   77)  What are the entries passed when U create an Invoice and receive payment for it in AR?
   78)  Explain all the entries from Receipt in AR to clearing in Cash Management?
   79)  How do you setup automatic receipts in AR?
   80)  What is a Lockbox? How do you set it up in AR?
   81)  What are cross currency payments in AR? How do enable the receipt of the same?
   82)  In case a customer requires the part of the shipment to be shipped to another customer, who should be billed for it?
   83)  What are the setups required in AR for integrating it to OM?
   84)  How do you setup the document sequencing for the transactions flowing in from OM?

FA
   85)  Explain the total process for asset creation from AP route?
   86)  What is the flex builder/account generator in FA? And how does it work?
   87)  What should be done to modify the Flex builder?
   88)  Explain the total process for transferring transactions from FA to the GL?
   89)  How do you convert the opening balances for FA?
   90)  How do you bring in the Accumulated Depreciation for expensed assets in FA?



How to find all cancel Requisitions

SELECT prha . *   FROM po_Requisition_headers_all prha , po_action_history pah   WHERE      1 = 1        AND pah . object_id ...