While Running PO_REQLOAD Process The Requisition Lines Are Not Generating As Per The Line Numbers Provided In The XML File. (Doc ID 2865287.1)

Last updated on NOVEMBER 29, 2023

Applies to:

Symptoms

While running the requisition bulk upload process with the help of "PURCHASE_REQUISITION_LOAD" service operation and after uploading the xml, the data in the staging record is coming as per the user input but when running the PO_REQLOAD process the requisition lines are coming based on inventory item in ascending order.

Steps:
1. Open the Handler Tester page and Service Operation "PURCHASE_REQUISITION_LOAD"
  PeopleTools > Integration Broker > Service Utilities > Test Service Operation Handler
2. Click on "Provide Data" button and then click on "Upload Data From File".
3. Provide the XML file to upload requisition data. Click on Execute Event
4. Once data is uploaded, check the Requisition loader staging table "PO_REQLOAD_RQST" to see the data uploaded as per the xml file provided.
5. Run the requisition loader process to create requisition.
  Purchasing -> Requisitions -> Load Requisitions
6. Requisition is created with the lines based on inventory item in ascending order and not as per the file uploaded.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.