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 DECEMBER 03, 2019
Applies to:Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Data Collections in Test:
Users are on 12.1.3 and have applied VCP 18.104.22.168.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
WHERE vendor_site_id = 40399;
Returns 0 rows
Rerunning all concurrent requests and validating steps in note 730061.1 does not resolve the issue
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
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
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