My Oracle Support Banner

iberep.odf failed on 12.2 upgrade (Doc ID 1665529.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle iStore - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

While applying 12.2 upgrade patch driver Patch 10124646 (ORACLE E-BUSINESS SUITE RELEASE 12.2.0 [R12.2] UPGRADE DRIVER)

12.2.3 (from 11.5.10.2) upgrade fails:

Worker log shows error related to IBE.

/opt/egapc1a/fs1/EBSapps/appl/ibe/12.0.0/patch/115/odf/iberep.odf


Comparing objects in username IBE with ODF file
/opt/egapc1a/fs1/EBSapps/appl/ibe/12.0.0/patch/115/odf/iberep.odf


Reading objects from ODF file

Reading table IBE_ECR_QUOTES_FACT ...
Reading table IBE_ECR_ORDERS_FACT ...
Reading table IBE_ECR_MVLOG ...
Reading table IBE_ECR_ORDER_HEADERS_FACT ...
Reading table IBE_WF_NOTIF_SETUP ...
Reading table IBE_WF_NOTIF_MSG_MAPS ...

 *** Reading objects from IBE schema

Reading table IBE_ECR_QUOTES_FACT from IBE schema ...
Reading table IBE_ECR_ORDERS_FACT from IBE schema ...
Reading table IBE_ECR_MVLOG from IBE schema ...
Reading table IBE_ECR_ORDER_HEADERS_FACT from IBE schema ...
Reading table IBE_WF_NOTIF_SETUP from IBE schema ...
Reading table IBE_WF_NOTIF_MSG_MAPS from IBE schema ...

===== Table IBE_ECR_QUOTES_FACT all columns match.
*******************************************************
The table is missing the index IBE_ECR_QUOTES_FACT_N1
or index IBE_ECR_QUOTES_FACT_N1 exists on another table.
Create it with the statement:


Start time for statement below is: Thu Apr 17 2014 17:30:02

CREATE INDEX IBE."IBE_ECR_QUOTES_FACT_N1" ON IBE.IBE_ECR_QUOTES_FACT
 (ORGANIZATION_ID, INVENTORY_ITEM_ID) LOGGING STORAGE (FREELIST GROUPS 4
 FREELISTS 4 )  PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS  
 TABLESPACE APPS_TS_SUMMARY

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

Time when worker failed: Thu Apr 17 2014 17:30:02
AdjavaWorker has reached the maximum wait timeout specified( 36000000 ). So Exiting.

Restarting job that failed and was fixed.

Time when worker restarted job: Fri Apr 18 2014 10:14:19

Start time for file is: Fri Apr 18 2014 10:14:19


Comparing objects in username IBE with ODF file
/opt/egapc1a/fs1/EBSapps/appl/ibe/12.0.0/patch/115/odf/iberep.odf

Reading objects from ODF file

Reading table IBE_ECR_QUOTES_FACT ...
Reading table IBE_ECR_ORDERS_FACT ...
Reading table IBE_ECR_MVLOG ...
Reading table IBE_ECR_ORDER_HEADERS_FACT ...
Reading table IBE_WF_NOTIF_SETUP ...
Reading table IBE_WF_NOTIF_MSG_MAPS ...

 *** Reading objects from IBE schema

Reading table IBE_ECR_QUOTES_FACT from IBE schema ...
Reading table IBE_ECR_ORDERS_FACT from IBE schema ...
Reading table IBE_ECR_MVLOG from IBE schema ...
Reading table IBE_ECR_ORDER_HEADERS_FACT from IBE schema ...
Reading table IBE_WF_NOTIF_SETUP from IBE schema ...
Reading table IBE_WF_NOTIF_MSG_MAPS from IBE schema ...

===== Table IBE_ECR_QUOTES_FACT all columns match.
*******************************************************
The table is missing the index IBE_ECR_QUOTES_FACT_N1
or index IBE_ECR_QUOTES_FACT_N1 exists on another table.
Create it with the statement:


Start time for statement below is: Fri Apr 18 2014 10:14:19

CREATE INDEX IBE."IBE_ECR_QUOTES_FACT_N1" ON IBE.IBE_ECR_QUOTES_FACT
 (ORGANIZATION_ID, INVENTORY_ITEM_ID) LOGGING STORAGE (FREELIST GROUPS 4
 FREELISTS 4 )  PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS  
 TABLESPACE APPS_TS_SUMMARY

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



Time when worker failed: Fri Apr 18 2014 10:14:19

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.