Requisition import

AP invoice interface, askHareesh blog for Oracle Apps

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)


*/