GMFCMGT.odf File FAILED While Applying The Patch 20203366. (Doc ID 2034318.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Process Manufacturing Financials - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Patch Application Issues

GMFCMGT.odf file FAILED While applying the <Patch:20203366>.

They are upgrading EBS 11.5.10.2 To R12.1.3.

They are applying <Patch:20203366>(12.1.3 RPC3).

While applying this GMFCMGT.odf file filed with the error below.
 


ERROR
-----------------------

The table is missing the index CM_CMPT_DTL_U1
or index CM_CMPT_DTL_U1 exists on another table.
Create it with the statement:


Start time for statement below is: Mon Jul 20 2015 15:35:42

CREATE INDEX GMF.CM_CMPT_DTL_U1 ON GMF.CM_CMPT_DTL (PERIOD_ID,
 COST_TYPE_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, COST_CMPNTCLS_ID,
 COST_ANALYSIS_CODE, COST_LEVEL) LOGGING STORAGE (FREELIST GROUPS 4
 FREELISTS 4 ) PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
 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
because of the error above
 




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade EBS 11.5.10.2 To R12.1.3.
2. Apply <Patch:20203366>


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the upgrade from EBS 11.5.10.2 To R12.1.3 is halted.

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