My Oracle Support Banner

'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 NOVEMBER 16, 2020

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.7.4.0 and later
Oracle 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


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