Difference Between Oracle D2K Form and OA Framework

Step 1
First we have to create a new Workspace and a new Project as dictated by Oracle's tutorial. When defining project, you will specify a default package (oracle.apps.ak.hello).
This means the following: -
·         ak is the short name of the Application in Oracle [Means fnd_applications.short_name]
·         hello is the name of your project

Step 2: 
Then we have to create OA Page within hello project
Think OA Page as the fmx file itself in D2K. I am saying so because this page gets attached to the form function.
·         This page will be created within hello project, hence the package name oracle.apps.ak.hello.webui
·         Note the webui; it is a convention to have page in webui, means this page represents the Web User Interface.
·         You will assign the default AM [OA Application Module]. Think of AM "Connection Manager" and "Transaction State Manager" for your page
I can't co-relate this to anything in D2k, as there is no concept of Connection Pooling and that D2k is not stateless. Reason being that as soon as you kick off a D2K Form, it connects to a single session of Oracle and sticks to that single Oracle database session. So is not the case in OAF, hence AM is needed.

Step 3:
Create Region within the Page.
Region is what will store your fields. Text input fields will be of type message Text Input.
Think of Canvas in D2K. You can have nested regions. Stacked Canvas in D2K comes the
Closest to this component of OA Framework
 
Step 4:
Add a button to one of the nested regions
The item Style should be submitting Button, in case you want the page to be submitted when this button is clicked.
There is no WHEN-BUTTON-PRESSED trigger in OAF. In Framework, you will add a controller java code to handle events like Form Submit button clicks. JDeveloper generates the default code for you. Primarily two functions [should I call methods] will be created process Request [for UI Rendering Handling] and process Form Request
Think of process Request as WHEN-NEW-FORM-INSTANCE, though process Request is very restrictive.

Step 5:
In the controller to access the value in field "HelloName" the command is
String userContent = pageContext.getParameter ("HelloName");
In D2k, we used :block. Field.
In OAFramework, at submission of page, all the field values get passed into to OAPageContext object.
·         Use gets Parameter to access the field value.
·         To set the value of the field, use
OAMessageTextInputBean field
HelloName = (OAMessageTextInputBean) webBean.findChildRecursive ("HelloName"); 
                        fieldHelloName.setText (pageContext, “Setting the default value”); 





STEPS For AR Invoice Interface in Oracle Apps

Steps for AR Invoice Interface are:

1.    Put the data into your staging tables.


2.    Calls your package to validate the data and load into AR Interface tables (RA_INTERFACE_LINES_ALL & RA_INTERFACE_DISTRIBUTIONS_ALL).

3.    Then submits a concurrent request for AutoInvoice.

If any errors occur it can be found in ra_interface_errors_all table. The concurrent program has 2 stages. First the Master program fires which intern kicks of the Import Program. Once this is completed data is inserted into the following tables.
1) ra_customer_trx_all (Invoice Header Info)
2) ra_customer_trx_lines_all (Invoice Line Level Info)
3) ra_cust_trx_line_gl_dist_all (Accounting Info. One record for each Account Type is inserted into this… ex. Receivable Revenue Tax Freight etc)
4) ar_payment_schedules_all (All Payment related info)

Validations:
Validation are generally done on the below columns.
·             Batch_source_name
·             Set_of_books_id
·             Orig_sys_batch_name
·             orig_system_bill_customer_ref
·             orig_system_bill_address_ref
·             Line_Type
·             Currency_Code
·             Term_name
·             Transaction_type
·             Interface_line_attribute1-7
·             Account_class
·             Accounting Flexfields segments

1- AR Transaction Type Validation: Check if the Transaction type provided in data file is defined in AR transaction types (RA_CUST_TRX_TYPES_ALL)
2- Transaction Batch Source Validation: Check if the source provided in data file is defined in AR transaction Batch source (RA_BATCH_SOURCES_ALL).
3- Invoice Currency Validation: Check if the currency provided in data file is defined in AR Currency (FND_CURRENCIES).
4- Customer Validation: Check if the Bill to Customer Number, Ship to Customer Number, Bill to Custom Location, Ship to Customer Location provided in the data file is defined in AR Customer (RA_CUSTOMERS).
5- Primary Sales Representative Validation: Sales representative number to be hardcode to “-3” for “No Sales Credit.”
6- Term Name: Check if the Term name provided in the data file is defined in Payment terms (RA_TERMS)
7- Inventory Item Validation: Check if the Item provided in data file is defined in Inventory Items (MTL_SYSTEM_ITEMS).
8- Unit of Measurement validation: Check if the UOM provided is defined in MTL_UNITS_OF_MEASURE Table
9- Invoice Tax Code Validation: Check if the Tax Code provided in data file is defined in AR_VAT_TAX_ALL_B Table.
10- Invoice GL Date Validation: Check if the GL Data of provided invoices is in open period.

For MOAC:
You need to add the below columns and need to do validations if your application supports MOAC.
·             conversion_type
·             conversion_rate
·             conversion_date


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 ...