Requisition interface error table

Requisition interface error table

In this post , We will discuss about requisition interface error table. When we import the Purchase requisitions from the external system to the Oracle system then oracle system validated all those external requisitions in the interface table and if some transactions failed in the validations then system put those error o rejected transactions in the requisition interface error table. In this table we will get the complete information about the rejected records. Here below is the requisition interface error table

po_interface_errors

 

You can also refer the requisition import exceptions report

In this post, we will discuss about requisition import exceptions report. This Exception report shows the rejected records from the table po_interface_errors which got errors out during the Requisition Import process. If the Requisition Import process finds any requisitions that it cannot create, Purchasing records the errors in the PO Interface Errors Table.

Report Parameters

Import Source

Enter the interface source to restrict the report to a specific import source.

Import Batch ID

Enter the name of a Requisition Import batch to restrict the report to a specific batch within your Import Source.

Delete Exceptions

Enter Yes or No to indicate whether you want to delete the exceptions from the PO interface errors table. If you enter Yes, Purchasing prints the report and deletes the items printed from the PO Interface Errors Table. If you enter No, Purchasing Prints the report and leaves the errors in the error table. Each time Requisition Import process is generated, new transaction id numbers are created for errors. If the errors are not deleted, they remain in the Errors Table and are listed along with new error messages generated by the Requisition Import process for the same Import Source and Import Batch ID.