sales order interface error table in oracle apps r12

sales order interface error table in oracle apps r12

In this post  we will be discuss about the sales order interface error tables in oracle apps. When we do import the sales order through Interface tables , then some time some of the records got stuck in the interface due to some errors. To find out the errors , we do use the sales order interface error tables. This tables help to find out the sales order import error information's and based on that information's , we can do some actions for these errors. In this post , I will try to share the sales order interface tables and the sales order errors tables in oracle apps r12.

sales order interface error table in oracle apps r12

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

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 Sales order 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;