My Oracle Support Banner

Current Balances Dashboard does not have Correct Data Due to Caching (Doc ID 823683.1)

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)


When reviewing the Dashboards for Current Balances, the balances for certain accounts are missing even though the data exists.

-- 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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.