Showing posts with label OE. Show all posts
Showing posts with label OE. Show all posts

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