REQUISITION OPEN INTERFACE

Automatically imports requisitions (from non oracle or oracle environment)
Integrates oracle purchasing with new or existing applications (MRP, INV management, and production control.

TABLES –
PO_REQUISITIONS_INTERFACE_ALL and/or
PO_REQ_DIST_INTERFACE_ALL

PROGRAM – REQUISITION IMPORT

IMPORTANT PARAMETERS – INTERFACE_SOURCE_CODE and BATCH_ID

In Release 11i – use PO_REQ_DIST_INTERFACE_ALL to create multiple distributions only for requisitions created in non-Oracle systems that use multiple distributions.

3 PHASES OF IMPORT PROGRAM

Validates data and generates an error message in PO_INTERFACE_ERRORS table.
Groups and numbers the validated requisition lines (groups based on the value of the columns REQ_NUMBER_SEGMENT1 or GROUP_CODE)
Deletes processed rows in interface tables and creates a report (which lists the number of interface records that were successfully imported and the number that were not imported).

STEPS FOR SETTING UP THE REQUISITIONS INTERFACE

1. You must define a Requisition Import Group-By method in the Default region of the Purchasing Options window.
2. For internally sourced requisitions, you must associate a customer with your deliver-to location using the Customer Addresses window.
3. All processing is initiated through standard report submission using the Submit
Request window. The concurrent manager manages all processing, and as such it
must be set up and running.