ORA-04063: View "OFSA_TABLES_V" Has Errors Opening RM Process ID
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.
In Oracle Risk Manager (RM) 4.5.39, you receive the following error when trying to open a Process ID:
OCI Function:  - oexec(), oexn()
SQL Function:  - 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.
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