Planning or ATP Data Collection Failing with ORA-00955 in Planning ODS Load
(Doc ID 983616.1)
Last updated on SEPTEMBER 12, 2021
Applies to:Oracle Advanced Supply Chain Planning - Version 12.1.1 and later
Information in this document applies to any platform.
Using Advanced Supply Chain Planning / Standard or ATP Data Collection
When attempting to perform Standard or ATP Data Collection, the following error occurs.
<>CREATE TABLE ITEM_CATEGORIES_xxx TABLESPACE APPS_TS_TX_DATA PCTFREE 10
INITRANS 10 MAXTRANS 255 AS SELECT * FROM MSC_ITEM_CATEGORIES WHERE NULL=NULL
ORA-00955: name is already used by an existing object
1. (R) Advanced Supply Chain Planner
2. (N) Collections > Oracle Systems > Standard or ATP Data Collection
3. Inspect MSCPDC log file and observe an ORA-0955 error in procedure Create_Temp_Tab_PVT
At least one customer reported this problem after an aborted Planning / ATP Data Collections run.
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