Requisition Import - Suggested Vendor/Supplier Information not Getting Imported with the Rest of the Requisition Data
(Doc ID 2738099.1)
Last updated on DECEMBER 21, 2020
Applies to:Oracle Purchasing - Version 12.2.9 and later
Information in this document applies to any platform.
Customer is using the Requisition Import (POCIRM) to import requisitions after populating the PO_REQUISITIONS_INTERFACE_ALL table.
The customer is populating SUGGESTED_VENDOR and SUGGESTED_VENDOR_LOCATION - i.e. Supplier and Supplier Site) fields in the Requisition Import Tables accordingly
The requisition import is not behaving as it was in R12.1.3 and when the requisitions are being imported the SUGGESTED_VENDOR_LOCATION on the imported Requisition lines is BLANK, which in turn means that the POCREATE workflow fails as there is missing information in the Requisition Line.
Steps to replicate the Issue
1. Load necessary data into the PO_REQUISITIONS_INTERFACE_ALL table
Make sure to Populate the fields SUGGESTED_VENDOR_NAME and SUGGESTED_VENDOR_SITE
2. Run the requisition import program
3. Review the requisitions created - the data is there but without suggested vendor/supplier information
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document