Showing posts with label Interview Questions. Show all posts
Showing posts with label Interview Questions. Show all posts

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?



Oracle Apps 11i Technical Interview Question and Answers

1)   How to know if a specific patch is installed or not?
    SELECT * FROM AD_BUGS WHERE BUG_NUMBER=x;
Here substitute x with patch number, and if the query returns a value means the patch is already applied.

2)   What is US directory in $AD_TOP or under various product TOP’s. US directory is defauly language directory in Oracle Applications. If you have multiple languages Installed in your Applications then you will see other languages directories besides US, that directory will contain reports, fmx and other code in that respective directory like FR for France, AR for Arabic, simplifies Chinese or Spanish.

3)   What are main concurrent Manager Types?
ICM - Internal Concurrent Manager which manages concurrent Managers
Standard Managers - Which Manage processesing of requests.
CRM - Conflict Resolution Managers , resolve conflicts in case of incompatibility.

4)   What is difference between ICM, Standard Managers & CRM in Concurrent Manager?
ICM stand for Internal Concurrent Manager, which controls other managers. If it finds other managers down , it checks & try to restart them. You can say it as administrator to other concurrent managers. It has other tasks as well.
Standard Manager These are normal managers which control/action on the requests & does batch or single request processing.
CRM acronym for Conflict Resolution Manager is used to resolve conflicts between managers & request. If a request is submitted whose execution is clashing or it is defined not to run while a particular type of request is running then such requests are actioned/assigned to CRM for Incompatibilities & Conflict resolution.

5)   Where is Concurrent Manager log file location.
By default standard location is $APPLCSF/$APPLLOG, in some cases it can go to $FND_TOP/log as well

6)   What is multi node system?
Multi Node System in Oracle Applications 11i means you have Applications 11i Component on more than one system. Typical example is Database; Concurrent Manager on one machine and forms, Web Server on second machine is example of Two Node System.
ICM stand for Internal Concurrent Manager, which controls other managers. If it finds other managers down , it checks & try to restart them. You can say it as administrator to other concurrent managers. It has other tasks as well.
Standard Manager These are normal managers which control/action on the requests & does batch or single request processing.
CRM acronym for Conflict Resolution Manager is used to resolve conflicts between managers & request. If a request is submitted whose execution is clashing or it is defined not to run while a particular type of request is running then such requests are actioned/assigned to CRM for Incompatibilities & Conflict resolution.

7)   Where is Concurrent Manager log file location.
By default standard location is $APPLCSF/$APPLLOG, in some cases it can go to $FND_TOP/log as well

8)   What is multi node system?
Multi Node System in Oracle Applications 11i means you have Applications 11i Component on more than one system. Typical example is Database; Concurrent Manager on one machine and forms, Web Server on second machine is example of Two Node System.

9)   What is .dbc file, where its stored, what use of .dbc file?
dbc as name says is database connect descriptor file which stores database connection information used by application tier to connect to database. This file is in directory $FND_TOP/secure also called as FND_SECURE

10)  How to determine Oracle Apps 11i Version?
Select RELEASE_NAME from fnd_product_groups;
You should see output like
RELEASE_NAME
———————–
11.5.9 or 11.5.10.2

11)  Whats is TWO_TASK in Oracle Database?
TWO_TASK mocks your tns alias which you are going to use to connect to database. Lets assume you have database client with tns alias defined as PROD to connect to Database PROD on machine teachmeoracle.com listening on port 1521. Then usual way to connect is sqlplus username/passwd@PROD ; now if you don’t want to use @PROD then you set TWO_TASK=PROD and then can simply use sqlplus username/passwd then sql will check that it has to connect to tnsalias define by value PROD i.e. TWO_TASK


12)  What is GWYUID?
GWYUID stands for Gateway User ID and password. Usually like APPLSYSPUB/PUB
Where GWYUID defined & what is its used in Oracle Applications?
GWYUID is defined in dbc i.e. Database Connect Descriptor file. It is used to connect to database by think clients

13)  How to check number of forms users at any time?
Forms Connections initiate f60webmx connections so you can use
ps -ef grep f60webmx wc –l

14)  What is 0 & Y in FNDCPASS, FNDLOAD or WFLOAD?
0 & Y are flags for FND Executable like FNDCPASS & FNDLOAD where
0 is request id (request ID 0 is assigned to request ID’s which are not submitted via Submit Concurrent Request Form.
‘Y’ indicates the method of invocation. i.e. it is directly invoked from the command-line not from the Submit Request Form.

15)  If your system has more than one Jinitiator, how will the system know, which one to pick. ?
When client makes a forms connection in Oracle Applications, forms client session uses configuration file defined by environment variable FORMS60_WEB_CONFIG_FILE also called as appsweb config file. These days this file is of format appsweb_$CONTEXT.cfg The initiator version number defined by parameter jinit_ver_name in this file will be used.

16)  What are .ldt & .lct files which you see in apps patch or with FNDLOAD?
ldt & .lct stands for Loader datafile & Loader configuration files, used frequently in migrating customization, profile options, configuration data, etc.. across Instances.

17)  What is dev60cgi & ifcgi60?
cgi stands for Common Gateway Interface and these are Script Alias in Oracle Apps used to access forms server . Usually Form Server access directly viahttp://hostname:port/dev60cgi/ifcgi60

18)  What is difference between COMPILE_ALL=SPECIAL and COMPILE=ALL while compiling Forms?
Both the options will compile all the PL/SQL in the resultant .FMX, .PLX, or .MMX file but COMPILE_ALL=YES also changes the cached version in the source .FMB, .PLL, or .MMB file. This confuses version control and build tools (CVS, Subversion, make, scons); they believe you’ve made significant changes to the source. COMPILE_ALL=SPECIAL does not do this.

19)  What is ps -ef or ps command in Unix ?
ps is unix/linux utility or executable to find status of process. Used mainly to find if services/process is running or not.





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