Allocation Model with Management Ledger Allocations Fails with 'ORA-00942: Table or View Does Not Exist'
(Doc ID 2192959.1)
Last updated on MARCH 27, 2019
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document