Invalid FN_POPDIMACCOUNT Function Due to DIM_ACCOUNT_V
Last updated on APRIL 29, 2011
Applies to:Oracle Financial Services Asset Liability Management - Version: 5.2
Oracle Financial Services Analytical Applications Infrastructure - Version: 7.2 and later [Release: 7 and later]
Information in this document applies to any platform.
PL/SQL: ORA-00923: FROM keyword not found where expected.
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.
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