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:

Symptoms

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

Cause

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