Setups Performed On Some Existing Supplier/Supplier Sites Are Not Picked Up By Refresh Collection Snapshots Concurren Request And Therefore Do Not Show Data In Table MRP_REGION_SITES For The Supplier Site

(Doc ID 2383456.1)

Last updated on APRIL 06, 2018

Applies to:

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

Symptoms

On : 12.1.3 version, Data Collections in Test:

Users are on 12.1.3 and have applied VCP 12.1.3.9.2 patch 22706126. They are following instructions in Note 730061.1 to setup supplier delivery calendar/organization receiving calendar so the setup is used during an ASCP plan run. For certain supplier/supplier sites, even though they performed all the setups, ran all of the EBS source concurrent requests, ran data collections and the ASCP plan, they do not see the calendar setups being used in the output. They find the supplier site data is not being picked up in source EBS table MRP_REGION_SITES

SELECT *
FROM MRP_REGION_SITES
WHERE vendor_site_id = 40399;

Returns 0 rows

Rerunning all concurrent requests and validating steps in note 730061.1 does not resolve the issue



EXPECTED BEHAVIOR
-----------------------
Expect supplier/supplier site data to be picked up in table MRP_REGION_SITES after all setups and EBS source concurrent requests have been run

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Follow setup instructions in note 730061.1
2. Run all EBS concurrent requests to populate appropriate setups in EBS source tables
3. Source table MRP_REGION_SITES is not being populated with vendor/supplier site information

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