Benefit Plan Details Table ODF_SSL_BFT_DTL_BFT Not Providing Monthly Dollars

Products

• Clarity PPM SaaS

Issue/Introduction

The UI does not match the database table.
The benefit plan dollars in future years is incorrectly reported in other years.

What can be done to sync the data so it is consistent in UI and database table (ODF_SSL_BFT_DTL_BFT) for all projects and ideas?

Issue: User enters dollars in total column and the dollar amount is automatically split into corresponding months/years.

Expected : Both UI and database should be consistent and show consistent breakdown by period type (monthly/yearly)
Actual: UI is reported correctly but in backend, system is creating one slice for the total duration of the benefit plan.

Resolution

The values in the database are annual and by design.
The moment the monthly period is entered, it will override the value of the month.

Because the need to get the monthly breakdown for reporting purposes, create a portlet/channel to display the monthly values
as the queries only shows the annual / percentage/blob.

Use the following as a start:

SELECT * FROM ODF_SSL_BFT_DTL_BFT 
SELECT * FROM FIN_BENEFIT_PLAN_DETAILS

NOTE: An action trace was performed but it did go into the level of detail for how the monthly values.were calculated.

When selecting the periods in the UI, the system will display those based on the all the rows for the periods.
Clarity will sum the annual periods. If monthly periods are being used, it will use the annual and spread the value for all the months.
If monthly periods are being used, it will use the annual and spread the value for all the months.