Value Chain Planning - EBS (MOSC)

MOSC Banner

ODS Load worker

edited Sep 25, 2012 6:47PM in Value Chain Planning - EBS (MOSC) 3 commentsAnswered
 Hi,We are implementing ASCP for centerlized installation. I ran standard collection and request 'Planning ODS Load Worker' completes with error. Log file shows following error message.

''
18-SEP 10:34:43 : Unique index violated - ITEM_CATEGORIES_U1_ABL
18-SEP 10:34:43 : ORA-12801: error signaled in parallel query server P000
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
18-SEP 10:34:43 : ======= Below records violate the unique constraint =======
18-SEP 10:34:43 : ORGANIZATION_ID 101 / SR_INSTANCE_ID 2022 / INVENTORY_ITEM_ID 1391 / CATEGORY_SET_ID 8 / SR_CATEGORY_ID 1238
18-SEP 10:34:43 : ORGANIZATION_ID 101 / SR_INSTANCE_ID 2022 / INVENTORY_ITEM_ID 1391 / CATEGORY_SET_ID 11 / SR_CATEGORY_ID 3130
18-SEP 10:34:43 : ===========================================================
18-SEP 10:34:43 : <<create_temp_table_index>>
18-SEP 10:34:43 : <<SQL>> CREATE UNIQUE INDEX ITEM_CATEGORIES_U1_ABL ON ITEM_CATEGORIES_ABL(ORGANIZATION_ID,SR_INSTANCE_ID,INVENTORY_ITEM_ID,CATEGORY_SET_ID,SR_CATEGORY_ID) PARALLEL  TABLESPACE APPS_TS_TX_IDX PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
18-SEP 10:34:43 : ORA-12801: error signaled in

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center