Create Snapshots Fails With Error ORA-01471 and ORA-20001: Snapshot Creation on one or More Snapshots (Doc ID 1314261.1)

Last updated on OCTOBER 05, 2016

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to run data collections the following error occurs in Create Snapshots

ERROR

ORA-20001: Snapshot Creation on WSM_COPY_OP_RESOURCES failed : ORA-01471: cannot create a synonym with same name as object
ORA-20001: Snapshot Creation on BOM_RESOURCE_CHANGES failed : ORA-01471: cannot create a synonym with same name as object
ORA-20001: Snapshot Creation on WIP_LINES failed : ORA-01471: cannot create a synonym with same name as object


STEPS

The issue can be reproduced at will with the following steps:

1. Navigate to Advanced Supply Chain Planning > Collections > Collect From Oracle Systems > Standard Collections
2. Launch the data collections
3. See that collections fails with the said error

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