'ORA-00903: Invalid Table Name' Executing Portfolio Table to Ledger Stat Allocation (Doc ID 2103607.1)

Last updated on FEBRUARY 05, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Service Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT), when you execute a Portfolio Table to Ledger Stat Static Driver Allocation, the Allocation fails with an ORA-00903 in the log.  The following error exists in the ofspa from $FIC_DB_HOME/log/FusionApps:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [0] - SQL function not found! Oracle Error:
ORA- 00903: invalid table name Driver Function:
drv_oci::Execute() SQL Statement: TRUNCATE TABLE


and

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [0] - SQL function not found! Oracle Error:
ORA- 00903: invalid table name Driver Function:
drv_oci::Execute() SQL Statement:
DROP TABLE


Errors also exist in FSI_MESSAGE_LOG along with the following messages:

PORTFOLIO.CANAL_ID
Invalid Debit.
and
Allocation ID is empty.

(where CANAL_ID is a custom dimension)

The errors prevent the Allocation from generating results.

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