ORA-04063: View "OFSA_TABLES_V" Has Errors Opening RM Process ID (Doc ID 779249.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Risk Manager - Version 4.5 to 4.5.39 [Release 4.5]
Information in this document applies to any platform.
Note: All OFSA 4.5 products have reached sustaining support.

Symptoms

In Oracle Risk Manager (RM) 4.5.39, you receive the following error when trying to open a Process ID:

(203105) Oracle drv_oci error:

OCI Function: [4] - oexec(), oexn()
SQL Function: [0] - SQL function not found!
Oracle Error: ORA-04063: view "<dbowner>.OFSA_TABLES_V" has errors

Driver Function: drv_oci::Execute()

SQL Statememt: select
ofsa_tables_v.display_name, ofsa_tables_v.description, ofsa_tables_v.display_flg, 0,
ofsa_tables_v.table_name, ofsa_tables_v.owner, ofsa_tables_v.dbf_name from ofsa_tables_v where
(table_name, owner) in (select table_name, owner from ofsa_table_class_assignment a where
a.table_classification_cd in (select table_classification_cd from ofsa_table_usage where usage_cd
= 5)) order by ofsa_tables_v.display_name



This prevents you from running or updating the RM Process ID.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms