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

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.0 to 12.1.3.8 [Release 12 to 12.1]
Oracle Demand Planning - Version 12.0 to 12.1.3.8 [Release 12 to 12.1]
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

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