search cancel

FIN_BENEFIT_PLAN_DETAILS table is not populating

book

Article ID: 229220

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

When editing benefit plan details, the table FIN_BENEFIT_PLAN_DETAILS  is populated.
Its corresponding  view, RPT_FIN_BENEFIT_PLANS_V is also updated but not able to query for it.

Environment

All

Resolution

In order to get the non-zero values in the RPT_FIN_BENEFIT_PLANS_V,

1. Run query:
select * from RPT_FIN_BENEFIT_PLANS_V
where benefit_plan_id = <value in URL>
order by period_id desc
Get id.


2 Run query:
select * from FIN_BENEFIT_PLAN_DETAILS
where plan_id = <id in step 1>