My Oracle Support Banner

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.


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.


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

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