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

Create Requisitions Using Requisition Import - Training

Steps required importing a requisition in purchasing:

Use the following scripts to insert data into the po_requisitions_interface_all table. After inserting into the interface table, run the “Requisition Import” program.

Oracle Apps Change PO API Training

Following are the steps required in order to use the Change PO API to update a Standard Purchase order?

Login to the application

Navigate to the Purchase Order form and create a PO with a single line with quantity = 10, price = 1 and promised date = 31-MAR-2012 (use any date in the future as long as it is in an open period).

Oracle Apps Cancel PO API Training

Following is a sample script to cancel the purchase order using Cancel PO API:

To cancel the whole PO, submit the cancel API using sqlplus as follows: