Tables involved in O2C Process in Oracle EBS

–ORDER MAIN TABLES

 

select flow_status_code, booked_flag, a.* from oe_order_headers_all a where order_number = ‘1234’;

select flow_status_code, a.* from oe_order_lines_all a where header_id = 99999;

select * from oe_price_adjustments where header_id = 99999 and line_id = 1270091;

select * from oe_order_price_attribs where header_id = 99999 and line_id = 288761;

select * from oe_order_holds_all where header_id = 99999 and line_id = 34575;

 

–DELIVERY TABLES

select * from wsh_delivery_details where source_header_id = 99999 and source_line_id = 2440080;

select * from wsh_delivery_assignments where delivery_detail_id = 4537129;

 

–PICK RELEASE (from SHIPPING tab)

 

–Concurrent Program “Pick Selection List Generation” kicks off after releasing order from SHIPPING.

 

–This in turn kicks off “Pick Slip Report” and “Auto Ship Confirm Report (Auto Ship Confirm Report)”

select * from wsh_new_deliveries where delivery_id = 653581;

select * from wsh_picking_batches where name = ‘653581’;

select * from wsh_serial_numbers where delivery_detail_id = 4537129;

 

–MOVE ORDER

 

select * from mtl_txn_request_headers where request_number = ‘689455’;

select * from mtl_txn_request_lines where header_id = 690521;

 

–SHIP CONFIRM

 

–Shipping Transaction for after entering serial numbers.

–Kicks off “Interface Trip Stop” very imp program that affects Inventory.

select * from mtl_material_transactions where source_code = ‘ORDER ENTRY’ and transaction_reference = 795291 and trx_source_line_id = 2440080;

select * from mtl_unit_transactions where inventory_item_id = 379603 and serial_number in (‘SUMIT00′,’SUMIT01’);

select * from mtl_serial_numbers where inventory_item_id = 379603 and upper(serial_number) in (‘SUMIT00′,’SUMIT01’);

 

 

 

–Run “Workflow Background Process” for “OM Order Line”

 

select * from ra_interface_lines_all where interface_line_context = ‘ORDER ENTRY’ and interface_line_attribute1 = ‘4025794’;

select * from ra_interface_salescredits_all where interface_line_context = ‘ORDER ENTRY’ and interface_line_attribute1 = ‘4025794’;

select * from ra_interface_distributions_all where interface_line_context = ‘ORDER ENTRY’ and interface_line_attribute1 = ‘4025794’;

 

–Run “Auto Invoice Master Program” and that will kick “Auto Invoice Import” program that will create invoice for the order

 

— “Prepayment Matching Program (Prepayments Matching Program)”

 

select * from ra_customer_trx_all where interface_header_attribute1 = ‘4025794’ and creation_date >= trunc(sysdate);

select * from ra_customer_trx_lines_all where interface_line_attribute1 = ‘4025794’ and creation_date >= trunc(sysdate);

select * from ra_cust_trx_line_salesreps_all where customer_trx_line_id = 5751111;

select * from ra_cust_trx_line_gl_dist_all where customer_trx_line_id = 5751111;

select * from ar_payment_schedules_all where trx_number = ‘50133102’;

 

–Receipt against invoice

 

select * from ar_cash_receipts_all where receipt_number like ‘12345%’ and creation_date >= trunc(sysdate);

select * from ar_receivable_applications where cash_receipt_id in (130168,130169);

 

–Run ” Create Accounting and General Ledge Transfer Program”

 

–This kicks off “Revenue Recognition” and “Revenue Contingency Analyzer” and “Update Posting Control” program

select * from gl_interface where date_created >= ’10-JUN-2020′ and user_je_category_name = ‘Sales Invoices’ and user_je_source_name = ‘Receivables’

and reference10 like ‘%50133102%’ and reference24 = ‘50133102’ and reference23 = ‘42596305’;

 

–Run “Journal Import”

 

select * from gl_je_batches where creation_date >= ’13-JUN-2020′ order by je_batch_id desc;

select * from gl_je_headers where je_source = ‘Receivables’ and je_category = ‘Sales Invoices’ and je_batch_id = 1592931;

select * from gl_je_lines where je_header_id = 1750124;

 

–Post Journals “Posting”

 

select * from gl_balances where last_update_date >= ’13-JUN-2020′