My Oracle Support Banner

Planning Data Pull Fails On Create MRP Snapshots With ORA-00955 (Doc ID 207885.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.0 and later
Oracle Demand Planning - Version 12.0 and later
Information in this document applies to any platform.
EXECUTABLE:MSRFWOR - Refresh Collection Snapshots

***Checked for relevance on 10-Apr-2013***
*** Checked for relevance on 17-Sep-2014 ***


Symptoms

Data Collections for Advanced Supply Chain Planning
OR
Setup Data Collections for Demand Planning

Error running MSRFWOR Refresh Collections Snapshots when profile MSC: Source Setup Required = Y will launch the Setup Requests for Data Collections:

MSCWIPSN - Create WIP Snapshots 
MSCBOMSN - Create BOM Snapshots 
MSCINVSN - Create INV Snapshots 
MSCMRPSN - Create MRP Snapshots 
MSCPOXSN - Create PO Snapshots 
MSCAHLSN - Create AHL Snapshots
MSCONTSN - Create OE Snapshots
MSCWSMSN - Create WSM Snapshots
MSCWSHSN - Create WSH Snapshots

One of these processes may error with ORA-00955
ORA-00955: name is already used by an existing object
Creating Snapshot for MRP_FORECAST_DESIGNATORS ... 
ORA-00955: name is already used by an existing object 
ORA-20001: MSCMRPSN: ORA-00955: name is already used by an existing object 
This can occur in any of the create snapshot concurrent requests

Cause

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
Symptoms
Cause
Solution
References

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