Posts

SLA Transfer to GL and GL posting

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

OPM Production Batch GME and INV tables relate together for a given batch

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

Useful queries/code/scripts in Oracle Apps Order Management

  Order header info Select * from oe_order_headers_all ooh where order_number= :p_order_number Operating unit info select * from hr_operating_units where organization_id=oe_order_headers_all.org_id Order type info select * from apps.oe_transaction_types_tl where transaction_type_id=oe_order_headers_all.order_type_id Price list info select * from apps.qp_list_headers_tl where list_header_id=oe_order_headers_all.price_list_id select * from apps.qp_list_lines where list_header_id=oe_order_headers_all.price_list_id Find customer info select * from hz_cust_accounts hca where cust_account_id=oe_order_headers_all.sold_to_org_id select * from apps.hz_parties where party_id=hz_cust_accounts.party_id Find Ship to location info select * from hz_cust_site_uses_all where site_use_id=oe_order_headers_all.ship_to_org_id select * from apps.hz_cust_acct_sites_all where cust_acct_site_id=hz_cust_site_uses_all.cust_acct_site_id select ...