ORA-01031 Insufficient Privilege or ORA-0942 Table or View Not Found Errors Running Process in OFSA

(Doc ID 163809.1)

Last updated on NOVEMBER 06, 2017

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.


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

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.


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