ORA-00942 on Allocation Model Using Scenario <Use Application Preference> (Doc ID 2190797.1)

Last updated on OCTOBER 06, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 to 8.0.2.0.4 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

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.

Error
ofspa err file shows:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] -oexec(),oexn() SQL Function: [85] - SQL function not found! Oracle Error:
ORA- 00942: table or view does not exist Driver Function: drv_oci::Execute() SQL
Statement: TRUNCATE TABLE GLBL1561TMP



Steps:
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.

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