How to Import/Upload Open Purchase Requisitions (in oracle R12 purchasing module)

note 

You wil have to prepare a script to load the data into Requisition interface
tables and then use 'Requisition Import Process' to import them to
Purchasing application.

refer to 'Requisition Import Process' section in the PO user guide.
If this is for a new implementation, my experience has been that users would
prefer to import only Open Purchase Orders.. not requisitions.

 You can use PO_REQUISITIONS_INTERFACE_ALL to import a purchase requisitions.

Below is an example:


INSERT INTO PO_REQUISITIONS_INTERFACE_ALL
(
DELIVER_TO_LOCATION_ID
, DELIVER_TO_REQUESTOR_ID
, AUTHORIZATION_STATUS
, REQUISITION_HEADER_ID
, REQUISITION_TYPE
, CREATION_DATE
, CREATED_BY
, QUANTITY
, UNIT_PRICE
, ITEM_SEGMENT1
, ITEM_DESCRIPTION
, CATEGORY_ID
, CURRENCY_CODE
, PREPARER_ID
, CHARGE_ACCOUNT_ID
, REQ_NUMBER_SEGMENT1
, SOURCE_TYPE_CODE
, HEADER_DESCRIPTION
, BATCH_ID
, DESTINATION_TYPE_CODE
, DESTINATION_ORGANIZATION_ID
, INTERFACE_SOURCE_CODE
, UNIT_OF_MEASURE
)
VALUES
(
H_CUR.DELIVER_TO_LOCATION_ID
, V_PREPARER_ID
, 'APPROVED'
, H_CUR.REQ_NUMBER
, 'INTERNAL'
, H_CUR.REQ_DATE
, V_PREPARER_ID
, H_CUR.REQ_LINE_QUANTITY
, H_CUR.UNIT_PRICE
, H_CUR.ITEM
, H_CUR.ITEM_DESCRIPTION
, V_CAT_ID
, H_CUR.CURRENCY_CODE
, V_PREPARER_ID
, V_CODE_ID
, H_CUR.REQ_NUMBER
, H_CUR.SOURCE_TYPE_CODE
, H_CUR.HEADER_DESCRIPTION
, 100
, H_CUR.DESTINATION_TYPE_CODE
, H_CUR.DESTINATION_ORGANIZATION_ID
, 'Loading 2010'
, H_CUR.UNIT_MEAS_LOOKUP_CODE
) ;


Then you need to run "Requisition Import" request from the purchasing module.