ONT Order Processing Errors

➜ Back to Library
Description
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
Run ONT Order Processing Errors and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
CAC Intercompany SO Price List vs. Item Cost Comparison CAC ICP PII Material Account Detail CAC Material Account Detail INV Inventory Items XXE4ARW Excel4apps Inventory Items CAC Internal Order Shipment Margin ONT Orders Summary Yanmar - Discount on order lines check AR Customers and Sites
Blitz Report™

Blitz Report™ provides multiple benefits: