My Oracle Support Banner

Merged Upgrade Driver Failed On Asopp.odf (Doc ID 2548737.1)

Last updated on MAY 05, 2021

Applies to:

Oracle Sales Foundation - Version 12.2 and later
Information in this document applies to any platform.

Goal

While upgrading the application from R12.1.3 to R12.2 on DB 11.2.0.4, when running the merged upgrade driver, the adworker failed on asopp.odf


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

ALTER TABLE OSM.AS_SALES_CREDITS_DENORM MODIFY (OPP_DESCRIPTION VARCHAR2(240))

AD Worker error:
The following ORACLE error:

ORA-30556: either functional or bitmap join index is defined on the column to be modified

occurred while executing the SQL statement:

ALTER TABLE OSM.AS_SALES_CREDITS_DENORM MODIFY (OPP_DESCRIPTION VARCHAR2(240))

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. Merge the patch drivers in $APPL_TOP/admin/$TWO_TASK/preinstall directory with the 12.2.0 upgrade driver $AU_TOP/patch/115/driver/u10124646.drv
2. Apply the newly merged 12.2.0 upgrade driver (For example, - <AU_TOP>/patch/115/driver/u_merged.drv) with the command:
  $ adpatch options=nocopyportion,nogenerateportion

How can this be resolved so the patch can be successfully applied?
 

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.