'Oracle Error: [0] - ORA- 00000: normal, successful' After FSI_DATA_IDENTITY Running Allocation

(Doc ID 1958768.1)

Last updated on JANUARY 08, 2015

Applies to:

Oracle Financial Services Profitability Management - Version 6.1 and later
IBM AIX on POWER Systems (64-bit)
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT), in an IBM AIX environment, when you run any Allocation, they all fail.  There is no error message in the ofspa log in $FIC_DB_HOME/bin.  However, all logs end with the following SQL:


There is nothing after this point.

In your environment, you have a large number of rows in FSI_DATA_IDENTITY (over 199,000).

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