OM interface error table in oracle apps r12

OM interface error table in oracle apps r12

In this post , We will be discuss about OM interface error table in oracle apps r12. We do know that , we do use the OM interface to import the external Sales order from external sources into the Oracle apps application. When we do import the sales order from external sources then some time some of the sales order got rejected by the OM interface due to some errors. We need to know these error details to re process these records in Oracle apps OM interface. These error information details stores by the OM interface error table. We need to use the OM interface error table to get more information's about these sales order errors. Here below i will share the OM interface error table and the detail SQL query to extract the OM interface error information's in oracle apps r12.

Detail OM interface error table in oracle apps r12

First of all to find out the OM interface error information  , We need to use this below sql query. This query will list all the error  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

WHERE OHIA.ORIG_SYS_DOCUMENT_REF=OLIA.ORIG_SYS_DOCUMENT_REF

and OHIA.ERROR_FLAG is not null

Sales Order Interface Tables in Oracle apps r12 

1.oe_lines_iface_all

2.oe_headers_iface_all

2 important OM interface error table

1.OE_PROCESSING_MSG

2.OE_PROCESSING_MSGS_TL

To find out the sales order interface error information's we can use this below sql query

SELECT OPT.* FROM OE_PROCESSING_MSGS OPM

       ,OE_PROCESSING_MSGS_TL OPT

WHERE OPM.TRANSACTION_ID = OPT.TRANSACTION_ID

AND ORIGINAL_SYS_DOCUMENT_REF = :P_ORIGINAL_SYS_DOCUMENT_REF

To re-process the error out sales order interface records , We need to use this below sql script.

update apps.oe_headers_iface_all

set ERROR_FLAG=null,

request_id=null;