Requisition import

Requisition import

You can automatically import requisitions into Oracle Applications using the Requisitions Open Interface

Pre-requisites:

• Set of Books
• Code combinations
• Employees
• Items
• Define a Requisition Import Group-By method in the Options window.
• Associate a customer with your deliver-to location using the Customer Addresses window for internally sourced requisitions.

Interface tables:

• PO_REQUISITIONS_INTERFACE_ALL
• PO_REQ_DIST_INTERFACE_ALL

Base tables:

• PO_REQUISITIONS_HEADERS_ALL
• PO_REQUISITION_LINES_ALL
• PO_REQ_DISTRIBUTIONS_ALL

Concurrent program:

• REQUISITION IMPORT

Validations:

• Check for interface transaction source code, requisition destination type.
• Check for quantity ordered, authorization status type.

Important Columns:

Some important columns that need to be populated in the interface tables:

PO_REQUISITIONS_INTERFACE_ALL:

• INTERFACE_SOURCE_CODE (to identify the source of your Requisitions)
• DESTINATION_TYPE_CODE
• AUTHORIZATION_STATUS
• PREPARER_ID or PREPARER_NAME
• QUANTITY
• CHARGE_ACCOUNT_ID or charge account segment values
• DESTINATION_ORGANIZATION_ID or DESTINATION_ORGANIZATION_CODE
• DELIVER_TO_LOCATION_ID or DELIVER_TO_LOCATION_CODE
• DELIVER_TO_REQUESTOR_ID or DELIVER_TO_REQUESTOR_NAME
• ORG_ID
• ITEM_ID or item segment values (values if the SOURCE_TYPE_CODE or DESTINATION_TYPE_CODE is 'INVENTORY')

PO_REQ_DIST_INTERFACE_ALL:

• CHARGE_ACCOUNT_ID or charge account segment values
• DISTRIBUTION_NUMBER
• DESTINATION_ORGANIZATION_ID
• DESTINATION_TYPE_CODE
• INTERFACE_SOURCE_CODE
• ORG_ID
• DIST_SEQUENCE_ID (if MULTI_DISTRIBUTIONS is set to Y)