My Oracle Support Banner

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

Last updated on FEBRUARY 14, 2022

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


Data Collections for Advanced Supply Chain Planning
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


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.