Recently I described in a blog post how and why you want to migrate to Analytics Publisher 12c for your Oracle E-Business Suite built-in reporting.
After doing so for two different customers we ran into a small bug during patching that is so far unpublished; so here it is described should you run into issues with etcc/OPatch afterwards. Let's have a look at the details:
ETCC failing
After having activated Analytics Publisher 12c by setting s_xdo_runtime_release to xdo12c in the config file and running autoconfig on a subsequent checkMTpatch.sh (after sourcing the RUN or PATCH filesystem) you'll see:
=============================================================================== Oracle Fusion Middleware (FMW) - Web Tier =============================================================================== Now examining Oracle Fusion Middleware (FMW) - Web Tier. Inventory load failed... OPatch cannot load inventory for the given Oracle Home. LsInventorySession failed: Unable to create patchObject Possible causes are: ORACLE_HOME/inventory/oneoffs/22290164 is corrupted. /u01/install/APPS/fs1/FMW_Home/webtier/inventory/oneoffs/22290164/etc/config/actions.xml with Invalid index Cannot confirm bugfixes applied to /u01/install/APPS/fs1/FMW_Home/webtier Inventory could not be checked. Error code: 73. Exiting.
Drilling into the logfile of the actual opatch session is not really helpful either:
[oracle@entw241211app01 etcc]$ cat /u01/install/APPS/fs1/FMW_Home/webtier/cfgtoollogs/opatch/opatch2025-01-21_13-50-38PM_1.log [Jan 21, 2025 1:50:39 PM] OPatch invoked as follows: 'lsinventory -invPtrLoc /u01/install/APPS/fs1/FMW_Home/webtier/oraInst.loc -detail ' [Jan 21, 2025 1:50:39 PM] OUI-67077: Oracle Home : /u01/install/APPS/fs1/FMW_Home/webtier Central Inventory : /u01/install/APPS/oraInventory from : /u01/install/APPS/fs1/FMW_Home/webtier/oraInst.loc OPatch version : 11.1.0.12.9 OUI version : 11.1.0.11.0 OUI location : /u01/install/APPS/fs1/FMW_Home/webtier/oui Log file location : /u01/install/APPS/fs1/FMW_Home/webtier/cfgtoollogs/opatch/opatch2025-01-21_13-50-38PM_1.log [Jan 21, 2025 1:50:39 PM] Patch history file: /u01/install/APPS/fs1/FMW_Home/webtier/cfgtoollogs/opatch/opatch_history.txt [Jan 21, 2025 1:50:39 PM] OPatch detects the Middleware Home as "/u01/install/APPS/fs1/FMW_Home" [Jan 21, 2025 1:50:39 PM] Starting LsInventorySession at Tue Jan 21 13:50:39 CET 2025 [Jan 21, 2025 1:50:40 PM] [Jan 21, 2025 1:50:40 PM] OUI-67028:Inventory load failed... OPatch cannot load inventory for the given Oracle Home. [Jan 21, 2025 1:50:40 PM] OUI-67073:LsInventorySession failed: Unable to create patchObject Possible causes are: ORACLE_HOME/inventory/oneoffs/22290164 is corrupted. /u01/install/APPS/fs1/FMW_Home/webtier/inventory/oneoffs/22290164/etc/config/actions.xml with Invalid index [Jan 21, 2025 1:50:40 PM] Finishing LsInventorySession at Tue Jan 21 13:50:40 CET 2025 [Jan 21, 2025 1:50:40 PM] Stack Description: java.lang.RuntimeException: Unable to create patchObject Possible causes are: ORACLE_HOME/inventory/oneoffs/22290164 is corrupted. /u01/install/APPS/fs1/FMW_Home/webtier/inventory/oneoffs/22290164/etc/config/actions.xml with Invalid index [Jan 21, 2025 1:50:40 PM] StackTrace: oracle.opatch.HomeInventoryHelper.getOneOffEntry(HomeInventoryHelper.java:591) [Jan 21, 2025 1:50:40 PM] StackTrace: oracle.opatch.OracleHomeInventory.load(OracleHomeInventory.java:2736) [Jan 21, 2025 1:50:40 PM] StackTrace: oracle.opatch.LsInventorySession.loadAndPrintInventory(LsInventorySession.java:348) [Jan 21, 2025 1:50:40 PM] StackTrace: oracle.opatch.LsInventorySession.process(LsInventorySession.java:308) [Jan 21, 2025 1:50:40 PM] StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:1825) [Jan 21, 2025 1:50:40 PM] StackTrace: oracle.opatch.OPatch.main(OPatch.java:718)
Root Cause and Workaround
After a lot of searching (it is not obvious that this was caused by xdo12c if you do the enablement of xdo12c with other patching, e.g. a 12.2.14 upgrade) we found the reason to be modifications in the Classpath set during the etcc session. For us it was:
[oracle@entw241211app01 etcc]$ echo $CLASSPATH /u01/install/APPS/fs1/EBSapps/comn/util/jdk32/lib/dt.jar:/u01/install/APPS/fs1/EBSapps/comn/util/jdk32/lib/tools.jar:/u01/install/APPS/fs1/EBSapps/comn/util/jdk32/jre/lib/rt.jar:/u01/install/APPS/fs1/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/u01/install/APPS/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-fmw/WEB-INF/lib/ebsFMWManifest.jar:/u01/install/APPS/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/install/APPS/fs1/FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/u01/install/APPS/fs1/EBSapps/comn/java/classes:/u01/install/APPS/fs1/EBSapps/10.1.2/forms/java:/u01/install/APPS/fs1/EBSapps/10.1.2/forms/java/frmall.jar:/u01/install/APPS/fs1/EBSapps/10.1.2/jlib/ewt3.jar:/u01/install/APPS/fs1/EBSapps/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar
The problematic part here is ebs3rdpartyManifest.jar. You can either modify CLASSPATH to be empty or at least remove that entry. Then the operation completes again:
Completed etcc run
Oracle Bug 36625901
Oracle is investigating the cause of this issue in Bug 36625901; I hope one of the upcoming versions of etcc (or opatch) will fix this issue.
Summary
While the above issue is easy to fix it may cause a lot of pain; especially since it is not yet well publicly documented. I hope this blog post helps as a workaround until a permanent solution is available.