OE_ LINES_IFACE _ALL. 2) Run the Order Import Concurrent Program 3) Verify the View Output contents – It can be found that the order failed with the information – Enter the required information – Inventory Item 4) Navigate to: Order Management Super User/ Orders, returns/ Order Import/ Corrections window.
11/26/2020 · First of all to find out the sales order interface error lines , We need to use this below sql query. This query will list all the errored out sales order error lines. SELECT OHIA. ERROR _FLAG,OHIA.ORIG_SYS_DOCUMENT_REF,OHIA.*. FROM oe_headers_iface_all OHIA,oe_ lines_iface _all OLIA.
The query to find out error messages in the Order Interface table is: SELECT * FROM oe_processing_msgs opm, oe_processing_msgs_tl opmt WHERE opm.transaction_id = opmt.transaction_id AND opm.original_sys_document_ref = ‘123456’ — where 123456 is the Order Number in the interface table.
Click Get Object to open the Oracle Applications Module Browser again to select another open interface table OE_ LINES_IFACE _ALL using the same navigation path Order Management Suite (OM_PF) > Order Management (ONT) > Sales Order (ONT_SALES_ORDER) > OpenInterfaces >Order Management Sales Orders Open Interface (OEOIMP) > Tables. Click OK. The.
ORIG_SYS_SHIPMENT_REF : Original system shipment reference. Description: This is a multi-org table for sales order lines open interface. This table stores order. lines information that is.
4/27/2020 · ## Error Table PO_INTERRFACE_ ERRORS ## Base Tables: PO_HEADERS_ALL PO_LINES_ALL PO_DISTRIBUTIONS_ALL ## Oracle Seeded Concurrent Program. Import Standard Purchase Orders ===== Sales Orders Creation ===== ## Interface Tables: OE_HEADERS_IFACE_ALL OE_ LINES_IFACE.
9/24/2013 · Code (Text): SELECT OPT.*. FROM OE_PROCESSING_MSGS OPM. ,OE_PROCESSING_MSGS_TL OPT. WHERE OPM.TRANSACTION_ID = OPT.TRANSACTION_ID. AND ORIGINAL_SYS_DOCUMENT_REF = dof_ref provide doc_ref which is from interface table and there we can check the error what we got on that. And …
