My Oracle Support Banner

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 FEBRUARY 09, 2022

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 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

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