ORA-01031 Insufficient Privilege or ORA-0942 Table or View Not Found Errors Running Process in OFSA (Doc ID 163809.1)

Last updated on JUNE 08, 2016

Applies to:

Oracle Financial Data Manager - Version 4.5 and later
Oracle Profitability Manager - Version 4.5 and later
Oracle Transfer Pricing - Version 4.5 and later
Oracle Risk Manager - Version 4.5 and later
Information in this document applies to any platform.
Oracle Financial Data Manager - Version: 4.5
Oracle Balance & Control - Version: 4.5
Oracle Performance Analyzer - Version: 4.5
Oracle Profitability Manager - Version: 4.5
Oracle Transfer Pricing - Version: 4.5
Oracle Risk Manager - Version: 4.5

Note: All OFSA 4.5 products have reached sustaining support.

Symptoms

When attempting to run an OFSA process on a client or instrument table with a new user, the following error occurs:

ERROR
ORA-01031 Insufficient privileges error running process
ORA-00942 table or view not found

Any OFSA process may be affected, RM Process ID, TP Process ID, Data Verification ID, Allocation ID, etc.. The process works if it is run by the database or schema owner.

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