My Oracle Support Banner

Requisition Import - Suggested Vendor/Supplier Information not Getting Imported with the Rest of the Requisition Data (Doc ID 2738099.1)

Last updated on MARCH 15, 2022

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

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