Showing posts with label po_interface_errors. Show all posts
Showing posts with label po_interface_errors. Show all posts

Tuesday, June 26, 2012

Interface error tables in Oracle Apps


Following are the interface error tables used in oracle apps:

This table stores the processing messages which will be generated during Order Entry concurrent program execution or UI process. This is a multi-lingual table.

SELECT OPT.*
  FROM OE_PROCESSING_MSGS OPM, OE_PROCESSING_MSGS_TL OPT
 WHERE     OPM.TRANSACTION_ID = OPT.TRANSACTION_ID
       AND OPT.LANGUAGE = 'US'
       AND ORIGINAL_SYS_DOCUMENT_REF = LV_DOC_REF