ONT Order Processing Errors

Description
Columns: User Name, Transaction Id, Language, Source Lang, Message Text, Created By, Creation Date, Last Updated By, Last Update Date, Last Update Login ...
During a Sales Order Creation scenario, when data is inserted into Interface table – sometimes Orders can fail to get created due to issues in the Interface table. The corresponding error information is stored in the oe_processing_msgs_tl table.

original_sys_document_ref contains the order number

Schedule this query to find out error messages in the Order Interface table is:
During a Sales Order Creation scenario, when data is inserted into Interface table – sometimes Orders can fail to get created due to issues in the Interface table. The corresponding error information is stored in the oe_processing_msgs_tl table.

original_sys_document_ref contains the order number

Schedule this query to find out error messages in the Order Interface table is:


SELECT *
FROM oe_headers_iface_all
WHERE order_number = '123456';

SELECT *
FROM oe_lines_iface_all
WHERE orig_sys_document_ref = (SELECT orig_sys_document_ref
FROM oe_headers_iface_all
WHERE order_number = '123456');
   more
SELECT 
fu.user_name, 
opmt.*,opm.*
FROM oe_processing_msgs opm, 
     oe_processing_msgs_tl opmt, fnd_user fu
WHERE 1=1
and opm.transaction_id = opmt.transaction_id
and opm.created_by=fu.created_by
Parameter Name SQL text Validation
Order Number
opm.original_sys_document_ref =:order_number
LOV
Type
type=:error
LOV
Message Text
opmt.message_text=:message_text
LOV