Create Snapshots Fails With Error ORA-01471 and ORA-20001: Snapshot Creation on one or More Snapshots
(Doc ID 1314261.1)
Last updated on FEBRUARY 04, 2019
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.
When attempting to run data collections the following error occurs in Create Snapshots
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
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
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