Oracle-EBS

Oracle Purchasing Interview Questions  Some Oracle Apps Purchasing FAQ’s What is a Purchase Requisition and define various requisitions What are the base tables for a Purchase Requisition? What is a Requisition Import Program? What tables are affected when you run Requisition Import Program? What are the reports associated with requisition import process? When will you use a Requisition Template? What is the purpose of choosing a Category when creating a requisition? What does the status pre-approved mean? What is the difference between a rejected and a returned requisition? What is RFQ and differentiate the types of RFQ’s What is a Quotation, what are the different types of Quotations available and describe the Quote Analysis? What is a Purchase Order and explain the different types of PO’s available What are the base tables that are affected when you create a P.O? What is 2-way, 3-way, 4-way matching? Explain the P2P process flow What is an approval hierarchy? W

1. What are the tables involved in the Transfer to GL and GL posting? Subledger Tables XLA_AE_HEADERS XLA_AE_LINES XLA_DISTRIBUTION_LINKS Transfer Journal Entries to GL (XLAGLTRN) process takes the subledger journals and inserts records into the Interface Tables Interface Tables GL_INTERFACE / XLA_GLT_ Journal Import (GLLEZL) then reads from the interface table and creates records in the GL Tables GL Tables GL_JE_BATCHES GL_JE_HEADERS GL_JE_LINES GL_IMPORT_REFERENCES GL Posting process then posts to the GL_BALANCES table. What are the different methods to transfer Subledger journals to GL? a) ONLINE MODE GL Transfer can be spawned during Online Accounting using the "Final Post" option for a specific document (Example: AP Invoice and AR Transaction). Example: Navigation in Payables: Invoices/Entry/Invoices: Action: Create Accounting/Final Post. This spawns the GL Transfer, the Journal Import, Data Manager and the GL Posting processes. This request transfers ALL the final acc

Oracle Process Manufacturing Process Execution  OPM Production Batch GME and INV tables relate together for a given batch The following SQL*Plus queries show how the GME and INV tables relate together for a given batch. In each statement, please replace the value '12345' with the required Batch Number, and 'PR1' with the relevant Plant Code or Organization. 1)  Batch select gbh.* from gme_batch_header gbh where gbh.batch_no = '12345' and gbh.organization_id =   (select organization_id from org_organization_definitions ood     where ood.organization_code = 'PR1');    2) Batch Material Details  select ood.organization_code, gbh.batch_no, gbh.batch_id, gmd.* from gme_material_details gmd, gme_batch_header gbh,  org_organization_definitions ood where gmd.batch_id = gbh.batch_id and gbh.batch_no = '12345' and gbh.organization_id = ood.organization_id and ood.organization_code = 'PR1' order by gbh.batch_id, gmd.material_detail_i;