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 JULY 26, 2017

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 = 970077622-
Org = ALI:093

This shows many planned orders and they are being assigned as expected to two different supplier/supplier sites

PERFECTION GEAR / ASHEVILLE 9
WPT POWER CORPORATION / WICHITA 8148

From OWC user preferences are set to Req Group By = Location. We manually released one planned order for supplier/site PERFECTION GEAR/ASHEVILLE 9 and WPT POWER CORPORATION/WICHITA 8148 for the item/org above

Both planned orders were created as PR lines in Purchasing module for Supplier / Supplier Site = WPT POWER CORPORATION/WICHITA 8148 - we also release one planned order only for Supplier/Site = PERFECTION GEAR / ASHEVILLE 9 - it still created a PR for supplier/site WPT POWER CORPORATION/WICHITA 8148

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

SUPPLIER_ID = 137487
SUPPLIER_SITE_ID = 480154
SOURCE_SUPPLIER_ID = 137487
SOURCE_SUPPLIER_SITE_ID = 480154

B. For released planned orders for supplier/ supplier site = PERFECTION GEAR / ASHEVILLE 9, 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms