ORA-00942 on Allocation Model Using Scenario <Use Application Preference>
Last updated on OCTOBER 06, 2016
Applies to:Oracle Financial Services Profitability Management - Version 8.0.0 to 22.214.171.124.4 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
On : 8.0.1 version, Allocation Entries
When using <Use Application Preferences> in Scenario to submit an Allocation Model on Management Ledger, allocations show failure.
ofspa err file shows:
Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function:  -oexec(),oexn() SQL Function:  - SQL function not found! Oracle Error:
ORA- 00942: table or view does not exist Driver Function: drv_oci::Execute() SQL
Statement: TRUNCATE TABLE GLBL1561TMP
1. Create Allocation Rule and use Management Ledger in Source, Driver, Target.
2. Use Application Preferences for Scenario in Source or Driver
3. Create another allocation using Scenario Actual and include in the model.
4. Allocation Model failed.
5. Ran Allocation Rules individually and they are successful.
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