Allocation Model with Management Ledger Allocations Fails with 'ORA-00942: Table or View Does Not Exist'
Last updated on OCTOBER 14, 2016
Applies to:Oracle Financial Services Profitability Management - Version 8.0.0 to 8.0.3 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Profitability Management (PFT) 8.0.2, when you run a "Standard" Allocation Model containing multiple Allocations processing against Management Ledger (FSI_D_MANAGEMENT_LEDGER), the Allocation Model fails and the following error is output to the ofspa log in $FIC_DB_HOME/log/FusionApps:
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: MERGE INTO FSI_D_MANAGEMENT_LEDGER TARGET USING (
It appears the global temp table (ex. GLBL3857TMP) does not exist when the merge statement is executed for Allocations after the first Allocation.
The error prevents you from running Management Ledger Allocations in an Allocation Model.
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