Last updated on JULY 31, 2017
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Analytical Applications (OFSAA) 8.0, with the Profitability Pack, when you run the program to populate the Account dimension, fn_popDimAccount, the program fails with an error on STG_INVESTMENTS. The following error exists in FSI_MESSAGE_LOG:
SQLErrm User-Defined Exception. Table or Column Name Incorrect STG_INVESTMENTS.V_ACCOUNT_CODE
You may also get a similar error on STG_GUARANTEES:
SQLErrm User-Defined Exception. Table or Column Name Incorrect STG_GUARANTEES.V_GUARANTEE_CODE
As a result of this error, DIM_ACCOUNT is not populated with account numbers.
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