R12: FV: Patch 34340122:R12.FV.C Fails With Error "ORA-00904: "DUNS": invalid identifier"
(Doc ID 2950816.1)
Last updated on JUNE 30, 2023
Applies to:
Oracle U.S. Federal Financials - Version 12.2.7 and laterInformation in this document applies to any platform.
Symptoms
Patch 34340122:R12.FV.C Fails With Error "ORA-00904: "DUNS": invalid identifier".
This error can be seen in the worker log executing fv_ccr_vendors.xdf
ERROR
-----------------------
Table Name is FV_CCR_VENDORS
Table exists in the target database
Checking for differences
Number of columns for the table in the xml file is 423
The table in the Xml file and in the target database match
Index hashcode(s) extracted from the XDF.
Hashcodes generated for DB indexes.
Index FV_CCR_VENDORS_F1 does not exist in FV.
Drop query is DROP INDEX FV."FV~CCR~VENDORS~F1"
Drop query is DROP INDEX FV."FV~CCR~VENDORS~F1"
Error in executing statement: CREATE INDEX "FV"."FV~CCR~VENDORS~F1" ON "FV"."FV_CCR_VENDORS" ("DUNS"||"PLUS_FOUR")
PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 4096 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_TX_IDX"
PARALLEL
ONLINE NOLOGGING
Error message is: ORA-00904: "DUNS": invalid identifier
Error in executing statement: ALTER INDEX FV."FV~CCR~VENDORS~F1" NOPARALLEL LOGGING
Error message is: ORA-01418: specified index does not exist
CREATE INDEX "FV"."FV~CCR~VENDORS~F1" ON "FV"."FV_CCR_VENDORS" ("DUNS"||"PLUS_FOUR")
PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 4096 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_TX_IDX"
PARALLEL
ONLINE NOLOGGING
ALTER INDEX FV."FV~CCR~VENDORS~F1" NOPARALLEL LOGGING
Start time for statement above is Thu Mar 30 12:45:54 EDT 2023
Start time for statement above is Thu Mar 30 12:45:54 EDT 2023
ORA-904 error occured during Index creation.
Table exists in the target database
Checking for differences
Number of columns for the table in the xml file is 423
The table in the Xml file and in the target database match
Index hashcode(s) extracted from the XDF.
Hashcodes generated for DB indexes.
Index FV_CCR_VENDORS_F1 does not exist in FV.
Drop query is DROP INDEX FV."FV~CCR~VENDORS~F1"
Drop query is DROP INDEX FV."FV~CCR~VENDORS~F1"
Error in executing statement: CREATE INDEX "FV"."FV~CCR~VENDORS~F1" ON "FV"."FV_CCR_VENDORS" ("DUNS"||"PLUS_FOUR")
PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 4096 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_TX_IDX"
PARALLEL
ONLINE NOLOGGING
Error message is: ORA-00904: "DUNS": invalid identifier
Error in executing statement: ALTER INDEX FV."FV~CCR~VENDORS~F1" NOPARALLEL LOGGING
Error message is: ORA-01418: specified index does not exist
CREATE INDEX "FV"."FV~CCR~VENDORS~F1" ON "FV"."FV_CCR_VENDORS" ("DUNS"||"PLUS_FOUR")
PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 4096 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_TX_IDX"
PARALLEL
ONLINE NOLOGGING
ALTER INDEX FV."FV~CCR~VENDORS~F1" NOPARALLEL LOGGING
Start time for statement above is Thu Mar 30 12:45:54 EDT 2023
Start time for statement above is Thu Mar 30 12:45:54 EDT 2023
ORA-904 error occured during Index creation.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patch 34340122:R12.FV.C
Changes
NONE
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 |
Changes |
Cause |
Solution |
References |