Invalid FN_POPDIMACCOUNT Function Due to DIM_ACCOUNT_V (Doc ID 1318077.1)

Last updated on APRIL 29, 2011

Applies to:

Oracle Financial Services Asset Liability Management - Version: 5.2 and later   [Release: 5 and later ]
Oracle Financial Services Analytical Applications Infrastructure - Version: 7.2 and later    [Release: 7 and later]
Information in this document applies to any platform.
OFSAA

Symptoms

When compiling FN_POPDIMACCOUNT function, it gives error that DIM_ACCOUNT_V view does not exist.

Error:
PL/SQL: ORA-00923: FROM keyword not found where expected.

Steps:
1. Install Infrastructure 7.2.4. then Asset Liability Management 5.2.
2. Check for invalid objects:
    SQL> select object_name from all_objects where status ='INVALID'
3. Found function FN_POPDIMACCOUNT is invalid.
4. Re-compile the function but shows DIM_ACCOUNT_V view does not exist.

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