Current Balances Dashboard does not have Correct Data Due to Caching
Last updated on MAY 19, 2009
Applies to:Oracle Financial Services Profitability Analytics - Version: 4.5.39
This problem can occur on any platform.
Oracle Financial Services Applications (OFSA)
-- Steps To Reproduce:
1. Check the Dashboard Current Balances and found only one of the deposit account was displayed.
2. Check the Account Category table to find the code for each category:
select account_category_cd, account_category from PFT_ACCOUNT_CATEGORY_DSC;
3. Check the aggregated table OFS_BI_H_COA_A where the data is stored, and found there are other account groups within the deposit category.
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