'PL/SQL: ORA-00904: "SEARCH_CONDITION_VC": invalid identifier' Error Installing OFSAAI 8.0.7.4 with 11gR2 Database
(Doc ID 2727775.1)
Last updated on APRIL 04, 2024
Applies to:
Oracle Financial Services Profitability Management - Version 8.0.7.4.0 and laterOracle Financial Services Analytical Applications Infrastructure - Version 8.0.7.4.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.7.4.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Symptoms
When installing OFSAA Infrastructure 8.0.7.4 in an environment with Oracle Database version 11gR2, you get the following errors in the OFSAAIUpdate.log:
Log [2020-10-02 09:03:25.593] [OFSAAIUPDATE] [ERROR] - Exception while executing the query - BEGIN
FOR cnames IN (select table_name, constraint_name
from user_constraints
where table_name = 'AAI_OBJECT_B' and search_condition_vc like '%N_VERSION BETWEEN 0 AND 99') LOOP
EXECUTE IMMEDIATE 'alter table ' || cnames.table_name || ' drop constraint ' || cnames.constraint_name;
END LOOP;
END;
java.sql.SQLException: ORA-06550: line 4, column 40:
PL/SQL: ORA-00904: "SEARCH_CONDITION_VC": invalid identifier
ORA-06550: line 2, column 17:
PL/SQL: SQL Statement ignored
ORA-06550: line 5, column 38:
PLS-00364: loop index variable 'CNAMES' use is invalid
ORA-06550: line 5, column 2:
PL/SQL: Statement ignored
.
.
.
Log [2020-10-02 09:03:25.596] [OFSAAIUPDATE] [DEBUG] - Error while executing - BEGIN FOR cnames IN (select table_name, constraint_name from user_constraints where table_name = 'AAI_OBJECT_B' and search_condition_vc like '%N_VERSION BETWEEN 0 AND 99') LOOP EXECUTE IMMEDIATE 'alter table ' || cnames.table_name || ' drop constraint ' || cnames.constraint_name; END LOOP; END;
Log [2020-10-02 09:03:25.596] [OFSAAIUPDATE] [DEBUG] - ORA-06550: line 4, column 40:
PL/SQL: ORA-00904: "SEARCH_CONDITION_VC": invalid identifier
ORA-06550: line 2, column 17:
PL/SQL: SQL Statement ignored
ORA-06550: line 5, column 38:
PLS-00364: loop index variable 'CNAMES' use is invalid
ORA-06550: line 5, column 2:
PL/SQL: Statement ignored
You do not know the impact of the error.
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 |
Cause |
Solution |
References |