MSCPDC - ODS Load Fails ORA-01658: Unable To Create Initial Extent For Segment (Doc ID 377391.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
EXECUTABLE:MSCPDC - Planning ODS Load
EXECUTABLE:MSCPDCW - Planning ODS Load Worker

Symptoms

ODS errors with the following:

Linking of Sales Order line in MDS to its Parent Sales orders is successful.....
Index Dropping on Temp Tables successful.
<>
<>CREATE INDEX SUPPLIES_N4_IDX ON
SUPPLIES_IDX(PLAN_ID,SR_INSTANCE_ID,ORGANIZATION_ID,APPLIED,STATUS,UPDATED) PARALLEL TABLESPACE
APPS_TS_TX_IDX STORAGE( INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE
0) PCTFREE 10 INITRANS 11 MAXTRANS 255
ORA-12801: error signaled in parallel query server P000
ORA-01658: unable to create INITIAL extent for segment in tablespace APPS_TS_TX_IDX
<>
<>ALTER TABLE MSC_SUPPLIES EXCHANGE PARTITION SUPPLIES__1 WITH TABLE SUPPLIES_IDX INCLUDING
INDEXES
ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
Calling Linking of Sales Order for 11i source ...
Procedure LINK_SUPP_SO_DEMAND_EXT started


STEPS
Run standard data collections

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