Wednesday, May 29, 2019

How to check import errors from Order Import R12


Use the below Select statement to verify.

SELECT OPT.*
  FROM OE_PROCESSING_MSGS OPM,
       OE_PROCESSING_MSGS_TL OPT
WHERE OPM.TRANSACTION_ID = OPT.TRANSACTION_ID
   AND ORIGINAL_SYS_DOCUMENT_REF = '4347358'; -- This is Req Number