3 EBS Source Instances - When Common Supplier Across Multiple Instances - Key Data Lost During Release - MSC_PO_REQUISITIONS_INTERFACE.SUGGESTED_VENDOR_SITE (Doc ID 2223971.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3.9.2 and later
Information in this document applies to any platform.

Symptoms

12.1.3.9.2 on multiple EBS sources connected to a single APS destination

PROBLEM
-------------
Supplier Site name is not populated when releasing reqs to PO.
This causes Create Release process to fail for items that have blanket PO

STEPS
--------
Run plan
Set profile MSC: Retain Released data - Yes
Release planned order to create Req for item that has Blanket PO
-- see that release is not created

KEY POINTS
1 They have 3 EBS source instances
2. AND ALSO This only happens when they have common supplier shared between 2 different EBS source instances.
3. We can see that interface table no longer has column SUGGESTED_VENDOR_SITE populated
 - this was working fine before upgrade to 12.1.3.9.2


EXPECTED BEHAVIOR
----------------------------
MSC_PO_REQUISITIONS_INTERFACE.SUGGESTED_VENDOR_SITE should have data

BUSINESS IMPACT
----------------------
cannot release properly

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