Planning or ATP Data Collection Failing with ORA-00955 in Planning ODS Load (Doc ID 983616.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.1 and later
Information in this document applies to any platform.
MSCPDC
ORA-0955
Create_Temp_Tab_PVT

Symptoms

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


Steps:
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

Changes

At least one customer reported this problem after an aborted Planning / ATP Data Collections run.

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