Missing SUGGESTED_VENDOR_ID And SUGGESTED_VENDOR_SITE_ID In PO_REQUISITIONS_INTERFACE_ALL - PR/PO Created For Wrong Supplier/Supplier Site
(Doc ID 2191443.1)
Last updated on FEBRUARY 20, 2019
Applies to:Oracle Advanced Supply Chain Planning - Version 18.104.22.168 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.
On : 22.214.171.124 or 126.96.36.199.1 or 188.8.131.52.2 version, Planner workbench
Missing SUGGESTED_VENDOR_ID and SUGGESTED_VENDOR_SITE_ID in PO_REQUISITIONS_INTERFACE_ALL
After doing a release from the Planner Workbench for a Planned Order, the data is successfully inserted into the PO_REQUISITIONS_INTERFACE_ALL table. However, the information for the SUGGESTED_VENDOR_ID and SUGGESTED_VENDOR_SITE_ID are missing.
Users are on 12.1.3 and have applied VCP 184.108.40.206.2 aka R12.SCP_PF.B.Delta.4 - Patch 22706126 - They run Unconstrained ASCP plans. They just started setting up some new sourcing rule splits so that there are 2 rank 1 suppliers both having 50%. The ASCP plan is creating planned orders as expected for both supplier/supplier sites. However, when they manually release planned orders for some item/organization combinations or when autorelease runs during the ASCP plan, they are seeing all the Purchases Requisitions generated for only 1 supplier/supplier site. Example data:
This shows many planned orders and they are being assigned as expected to two different supplier/supplier sites
From OWC user preferences are set to Req Group By = Location. We manually released one planned order for supplier/site each supplier for the item/org above
Both planned orders were created as PR lines in Purchasing module for one supplier - not both as expected
This problem occurs in both Test and PROD with both manual release of planned orders and autorelease during the ASCP plan run. They do have some item/org combinations that are creating PR's with the expected supplier / supplier site.
Further investigation reveals
A. In table msc_supplies transaction id = 245765647 before releasing planned order it shows correctly populated data for columns
B. For released planned orders -- the table MSC_PO_REQUISITIONS_INTERFACE shows NULL for the following columns
This looks just like the issue shown in the following KM note and bugs
Bug 23521506 - SUGGESTED_VENDOR_ID IS NULL IN THE MSC_PO_REQUISITIONS_INTERFACE TABLE
Bug 24754597 - MISSING SUGGESTED_VENDOR_ID AND SUGGESTED_VENDOR_SITE_ID IN PO_REQUISITIONS_INTE
They are expecting for the SUGGESTED_VENDOR_ID and SUGGESTED_VENDOR_SITE_ID to be completed also
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