MSRFWOR - Refresh Collection Snapshots - Parameter Snapshot Name Does Not Have Some Snapshots Listed -How to Add Them To The List? (Doc ID 1086104.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Executable:MSRFWOR - Refresh Collection Snapshots

Goal

There are missing snapshot names for the Snapshot Name parameter of this request.  If you need to run a standalone refresh of these snapshots, they will not appear in the list.

Some of these snapshots may not be on the system until you apply the latest Collections Rollup Patch from Section IV of <Note 223026.1>.

You should use SQL to check if they exist on the system BEFORE you add them to the list of values.

select * from dba_snapshots where name like '&snapshot_name';


Note: This is only for 11.5.10.

In R12.x the list of snapshots is maintained via Lookup MSC_COLL_SNAPSHOTS which can be accessed via Advanced Planning Administrator / Admin / Lookups.
AND if you have distributed installation where EBS Source is also R12.x then you must use this responsibility in the EBS Source to check the list of snapshots.  We have no reports of missing snapshots in the list for R12.

Solution

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