Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

13424903 12.1.3 GMFLOTC.odf CREATE INDEX GMF.GMF_MATL_LOT_COST_TXNS_N1 ON GMF.GMF_MATERIAL_LOT_COS

edited Aug 6, 2012 10:27AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 8 commentsAnswered

When DBA was applying patch, an error occured, this is what DBA sent me:
The patch 13424903 failed on job GMFLOTC.odf with below details.

CREATE INDEX GMF.GMF_MATL_LOT_COST_TXNS_N1 ON  GMF.GMF_MATERIAL_LOT_COST_TXNS (COST_HEADER_ID) LOGGING  PCTFREE 10  INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS PARALLEL TABLESPACE  APPS_TS_TX_IDX

Statement executed.

The CREATE INDEX statement above failed because there is another index on the same columns.
Looking for the existing index on the same columns...

AD Worker error:
Unable to find existing index on the same columns

AD Worker error:
Unable to compare or correct tables or indexes or keys

Tagged:

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

EBS LCM Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center