Upgrading from E-Business Suite 11i to R12 is a major step and some errors are to be expected during applying the English American patch driver, u6678700.drv. Some of the errors, seen during several upgrades on different customer sites, are listed below.
Seen errors during applying of upgrade patch driver, u6678700.drv | |
1 | Unable to allocate memory in procedure aiumab().
Error message: Solution: Reference: |
2 | amviccn.sql fails with: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
Error message: Solution: Reference: |
3 | jtfDiagReportMig.sql fails with: ORA-20101: Exception while trying to migrate data from jtf_diagnostic_log to jtf_diagnostic_download_rpt
Error message: sqlplus -s APPS/***** @/<middle tier>/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/jtfDiagReportMig.sql &un_jtf &pw_jtf &un_apps &pw_apps Solution: Reference: |
4 | p002ncpls.sql fails with: ORA-04068: existing state of packages has been discarded
Error message: sqlplus -s APPS/***** @/<middle tier>/apps/apps_st/appl/admin/<ENV>/out/p002ncpls.sql &un_apps CTXSYS &un_csSession altered.Package body created. Solution: Reference: |
5 | p001ncpls.sql fails with: ORA-00955: name is already used by an existing object
Error message: sqlplus -s APPS/***** @/<middle tier>/apps/apps_st/appl/admin/<ENV>/out/p001ncpls.sql Solution: drop table IGI.IGI_UPG_GL_BUDORG_BC_OPTIONS; drop table IGI.IGI_EFC_BUDGET_ASSIGNMENT_BCK; drop table IGI.IGI_BUDORG_BC_OPTIONS_BCK; drop table IGI.IGI_EFC_UPG_BACKUP_INFO; drop table IGI.IGI_GL_BUDGET_ASSIGN_BCK; 2. Restart failed workers in adctrl. |
6 | Uploading file ibecitem.ldt fails with: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
Error message: Uploading from the data file /<middletier>/apps/apps_st/appl/ibe/12.0.0/patch/115/import/US/ibecitem.ldt Solution: INDEX_NAME OWNER STATUS DOMIDX_STATUS DOMIDX 2. Fix Intermedia Tables: |
7 | EGOSILDU.sql fails with: ORA-02149: Specified partition does not exist
Error message: sqlplus -s APPS/***** @/<middle tier>/apps/apps_st/appl/ego/12.0.0/patch/115/sql/EGOSILDU.sql &un_ego Solution: Reference: |
8 | zpbremcwm.sql fails with: ORA-06550: line 235, column 6: PLS-00904: insufficient privilege to access object OLAPSYS.CWM2_OLAP_CUBE
Error message: sqlplus -s APPS/***** @/<middle tier>/apps/apps_st/appl/zpb/12.0.0/patch/115/sql/zpbremcwm.sqlcwm2_olap_cube.drop_cube(G_SCHEMA, v_cube.name); Solution: Reference: |
9 | csmidxdel.sql fails with: ORA-06550: line 15, column 2: PLS-00201: identifier ‘CSM_UTIL_PKG.LOG’ must be declared
Error message: sqlplus -s APPS/***** @/opt/ebsr12/apps/apps_st/appl/csm/12.0.0/patch/115/sql/csmidxdel.sql Cause: Solution: |
10 | pechktsk.sql fails with: ORA-00979: not a GROUP BY expression
Error message: sqlplus -s APPS/***** @/opt/ebsr12/apps/apps_st/appl/per/12.0.0/patch/115/sql/pechktsk.sql Solution: Reference: |
11 | armquet.sql fails with: ORA-20000: Add subscriber Error ( AR_REV_REC_Q) : -4063 – ORA-04063: AR.AR_REV_REC_Q has errors
Error message: sqlplus -s APPS/***** @/opt/ebsr12/apps/apps_st/appl/ar/12.0.0/patch/115/sql/armquet.sql &un_ar &pw_ar &un_ar Solution: OWNER OBJECT_NAME OBJECT_TYPE STATUS 2. Drop the queue and the queue table: OWNER OBJECT_NAME OBJECT_TYPE STATUS 7. Launch adctrl and restart the failed worker |
12 | XNPQFIX.sql fails with: ORA-20001: Error While modifying queue XNP.XNP_OUT_MSG_Q, ORA-06512: at line 77
Error message: sqlplus -s APPS/***** @/opt/ebsr12/apps/apps_st/appl/xnp/12.0.0/patch/115/sql/XNPQFIX.sql &un_xnp &pw_xnp &un_xnp Solution: OWNER OBJECT_NAME OBJECT_TYPE STATUS 2. Stop the queues: OWNER OBJECT_NAME OBJECT_TYPE STATUS Reference: |
13 | PO_VENDORS_OBS_F1.xdf fails with: AD Worker error: The utility FndXdfCmp returned error for the above task.
Error message: AD Worker error: Solution: Reference: |
14 | cstfifo.odf fails with: ORA-00979: not a GROUP BY expression
Error Message: ORA-00979: not a GROUP BY expression Solution: Reference: |
15 | ircntf.wft fails with: ITEM_TYPE ‘WFSTD’ is protected …
Error message: Access level: 20, Mode: UPGRADE Solution: Reference: |
16 | OKLIAADD.wft fails with: ITEM_TYPE ‘WFSTD’ is protected, no changes were saved…
Error message: Access level: 20, Mode: UPGRADE Solution: Reference: |
17 | PAPWPARN.wft fails with: ITEM_TYPE ‘WFSTD’ is protected, no changes were saved…
Error message: Access level: 20, Mode: UPGRADE Solution: Reference: |
18 | IGIGITRA.wft fails with: ORA-00001: unique constraint (APPLSYS.WF_MESSAGE_ATTRIBUTES_TL_U2) violated.
Error message: wferr: Solution: Reference: |
19 | oklresp.ldt fails with: Error calling FNDLOAD function – ORA-01403: no data found
Error message: Error calling FNDLOAD function. Solution: |
20 | MSDODPCODE.sql fails with: ORA-33292: Insufficient permissions to access analytic workspace APPS.ODPCODE
Error message: sqlplus -s APPS/***** @/opt/ebsr12/apps/apps_st/appl/msd/12.0.0/patch/115/sql/MSDODPCODE.sql Solution: USERNAME ACCOUNT_STATUS SQL> ALTER USER OLAPSYS ACCOUNT UNLOCK; Reference: |
21 | rgcolset.ldt fails with: ORA-01422: exact fetch returns more than requested number of rows
Error message: Error calling FNDLOAD function. Solution: |
22 | wfstartq.sql fails with ORA-04063: APPLSYS.WF_DEFERRED_QUEUE_M has errors
Error message: sqlplus -s APPS/***** @/opt/ebsr12/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/wfstartq.sql &un_fnd Solution: OWNER OBJECT_NAME OBJECT STATUS SQL> exec dbms_aqadm.drop_queue(queue_name=> ‘APPLSYS.WF_DEFERRED_QUEUE_M’); Reference: |
23 | cskbcat.ldt fails with: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
Error message: Error calling FNDLOAD function. Solution: |
24 | jtfpfstart.sql fails with: PLS-00905: object APPS.JTF_PF_CONV_PKG is invalid
Error message: sqlplus -s APPS/***** @/opt/ebsr12/apps/apps_st/appl/jtf/12.0.0/patch/115/sql/jtfpfstart.sql &un_apps &un_jtf Solution: Reference: |
25 | okladtxm.sql fails with: ORA-02289: sequence does not exist
Error message: ERROR at line 110: Solution: Reference: |
26 | zpbremcwm.sql fails with: PLS-00904: insufficient privilege to access object OLAPSYS.CWM2_OLAP_CUBE
Error message: ERROR at line 235: Solution: Reference: |
27 | biv_b_age_h_sum_mv.xdf fails with: ORA-54015 duplicate column expression was specified
Error message: Exception occured ORA-54015: Duplicate column expression was specified Solution: Reference: |
28 | MSC_RESOURCE_HIERARCHY_MV.xdf fails with: ORA-00955: name is already used by an existing object
Error message: Exception occured ORA-00955: name is already used by an existing object Solution: OWNER OBJECT_NAME OBJECT_TYPE STATUS CREATED 2. Check if MSC_RESOURCE_HIERARCHY_MV contain any rows: COUNT(*) 3. Drop the object if it contains no rows: |
29 | MSC_ITEM_HIERARCHY_MV.xdf fails with: ORA-00955: name is already used by an existing object
Error message: Job failed with error below: Solution: OWNER OBJECT_NAME OBJECT_TYPE STATUS CREATED 2. Check if MSC_ITEM_HIERARCHY_MV contain any rows: COUNT(*) 3. Drop the object if it contains no rows: |
30 | fem_bal_nacc_hier_l2_mv.xdf fails with: ORA-54015: Duplicate column expression was specified
Error message: Exception occured ORA-54015: Duplicate column expression was specified Solution: Reference: |
31 | czhist.sql fails with: ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old
Error message: BEGIN FND_STATS.GATHER_COLUMN_STATS(‘CZ’,’CZ_DEVL_PROJECTS’,’DELETED_FLAG’); END; Solution: Reference: |
32 | ademusr.sql fails with: ORA-01031: insufficient privileges
Error message: GRANT select on WF_DEFERRED to em_oam_monitor_role Solution: Reference: |