Patch Fails on FEM_BAL_NACC_HIER_L2_MV.XDF With ORA-00955 (Doc ID 2816147.1)

Last updated on FEBRUARY 24, 2022

Applies to:

Symptoms

While applying an Oracle Applications interoperability patch 30033914, the adpatch process fails with the following error in the adpatch log:

Error:

The adworkxxx.log contains the following error on a materialized view create statement:

==========================================================
XDF file application started. Current time is: Tue Oct 19 17:23:50 WIT 2021
================================================================================
Applying XDF file : /data/oracle/apps/appl/fem/12.0.0/patch/115/xdf/fem_bal_nacc_hier_l2_mv.xdf
================================================================================
Materialized View Name is FEM_BAL_NACC_HIER_L2_MV
Materialized View does not exist in the target database 

Executing create Statement  
Create Statement is 

     CREATE MATERIALIZED VIEW "APPS"."FEM_BAL_NACC_HIER_L2_MV"
  ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255 LOGGING
  STORAGE(INITIAL 4096 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
  TABLESPACE "APPS_TS_SUMMARY" 
  BUILD DEFERRED
  USING INDEX PCTFREE 10 INITRANS 11 MAXTRANS 255 
  STORAGE(INITIAL 4096 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
  TABLESPACE "APPS_TS_SUMMARY" 
  REFRESH FORCE ON DEMAND
  WITH ROWID USING DEFAULT LOCAL ROLLBACK SEGMENT
  ENABLE QUERY REWRITE
  AS select
FEM_BAL_BASE_SUMMARY_MV.LEDGER_ID,
FEM_BAL_BASE_SUMMARY_MV.DATASET_CODE,
FEM_BAL_BASE_SUMMARY_MV.CAL_PERIOD_ID,
FEM_BAL_BASE_SUMMARY_MV.CURRENCY_CODE,
FEM_BAL_BASE_SUMMARY_MV.COMPANY_COST_CENTER_ORG_ID,
FEM_BAL_BASE_SUMMARY_MV.COMPANY_COST_CENTER_ORG_VS_ID,
FEM_DIS_NAT_ACCTS_HIER_B.VALUE_SET_ID,
FEM_DIS_NAT_ACCTS_HIER_B.OBJECT_ID,
FEM_DIS_NAT_ACCTS_HIER_B.OBJECT_DEFINITION_ID,
FEM_DIS_NAT_ACCTS_HIER_B.LEVEL1_ID,
FEM_DIS_NAT_ACCTS_HIER_B.LEVEL2_ID ,
SUM( FEM_BAL_BASE_SUMMARY_MV.XTD_BALANCE_E) XTD_BALANCE_E,
SUM( FEM_BAL_BASE_SUMMARY_MV.XTD_BALANCE_F) XTD_BALANCE_F,
SUM( FEM_BAL_BASE_SUMMARY_MV.QTD_BALANCE_E) QTD_BALANCE_E,
SUM( FEM_BAL_BASE_SUMMARY_MV.QTD_BALANCE_F) QTD_BALANCE_F,
SUM( FEM_BAL_BASE_SUMMARY_MV.YTD_BALANCE_E) YTD_BALANCE_E,
SUM( FEM_BAL_BASE_SUMMARY_MV.YTD_BALANCE_F) YTD_BALANCE_F,
SUM(PTD_CREDIT_BALANCE_E) PTD_CREDIT_BALANCE_E,
SUM(PTD_DEBIT_BALANCE_E) PTD_DEBIT_BALANCE_E,
SUM(YTD_CREDIT_BALANCE_E) YTD_CREDIT_BALANCE_E,
SUM(YTD_DEBIT_BALANCE_E) YTD_DEBIT_BALANCE_E
from FEM_DIS_NAT_ACCTS_HIER_B,
FEM_BAL_BASE_SUMMARY_MV
where
 FEM_DIS_NAT_ACCTS_HIER_B.VALUE_SET_ID = FEM_BAL_BASE_SUMMARY_MV.NATURAL_ACCOUNT_VS_ID
AND FEM_DIS_NAT_ACCTS_HIER_B.LEVEL20_ID = FEM_BAL_BASE_SUMMARY_MV.NATURAL_ACCOUNT_ID
GROUP BY
FEM_BAL_BASE_SUMMARY_MV.LEDGER_ID,
FEM_BAL_BASE_SUMMARY_MV.DATASET_CODE,
FEM_BAL_BASE_SUMMARY_MV.CAL_PERIOD_ID,
FEM_BAL_BASE_SUMMARY_MV.CURRENCY_CODE,
FEM_BAL_BASE_SUMMARY_MV.COMPANY_COST_CENTER_ORG_ID,
FEM_BAL_BASE_SUMMARY_MV.COMPANY_COST_CENTER_ORG_VS_ID,
FEM_DIS_NAT_ACCTS_HIER_B.VALUE_SET_ID,
FEM_DIS_NAT_ACCTS_HIER_B.OBJECT_ID,
FEM_DIS_NAT_ACCTS_HIER_B.OBJECT_DEFINITION_ID,
FEM_DIS_NAT_ACCTS_HIER_B.LEVEL1_ID,
FEM_DIS_NAT_ACCTS_HIER_B.LEVEL2_ID
  
Start time for statement above is Tue Oct 19 17:23:50 WIT 2021
Exception occured  ORA-00955: name is already used by an existing object
ORA-06512: at "APPS.AD_MV", line 131
ORA-06512: at "APPS.AD_MV", line 289
ORA-06512: at line 1

java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
ORA-06512: at "APPS.AD_MV", line 131
ORA-06512: at "APPS.AD_MV", line 289
ORA-06512: at line 1

==========================================================
Done calling the utility function. Return Code = [1] TimeStamp = [Tue Oct 19 17:23:50 WIT 2021]
Updating task with status 1

AD Worker error:
The utility FndXdfCmp returned error for the above task.

AD Worker error:
The above program failed.  See the error messages listed
above, if any, or see the log and output files for the program.

Steps:
1. On EBS 12.1.3, apply Patch 30033914 and received error above.
2. Skip failed adworker to continue installation.

 

Changes

Cause

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