My Oracle Support Banner

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 12.1.3.8 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.1.3.8 or 12.1.3.9.1 or 12.1.3.9.2 version, Planner workbench

ACTUAL BEHAVIOR
---------------
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.

Further details:
============
Users are on 12.1.3 and have applied VCP 12.1.3.9.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:

Item AA1
Org M1

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

SUPPLIER_ID
SUPPLIER_SITE_ID
SOURCE_SUPPLIER_ID
SOURCE_SUPPLIER_SITE_ID

B. For released planned orders -- the table MSC_PO_REQUISITIONS_INTERFACE shows NULL for the following columns

SUGGESTED_VENDOR_ID
SUGGESTED_VENDOR_SITE_ID
SUGGESTED_VENDOR_SITE

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

EXPECTED BEHAVIOR
-----------------------
They are expecting for the SUGGESTED_VENDOR_ID and SUGGESTED_VENDOR_SITE_ID to be completed also

Changes

 No changes

Cause

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
Symptoms
Changes
Cause
Solution
References


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