Benefit plan slices not generating

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

A slice request definition has been defined against "Project::Detailed Planned Benefit". However, it is noticed that slice data is not getting generated in the odf_sl_plan_benefit table.

Resolution

Cost Plan that is the plan of record has to have its field called "Benefit Plan" populated with the name of the appropriate Benefit Plan.

Following query is provided as a sample to check for slice data once this condition is fulfilled.

select
    ii.name,
    fp.name,
    ospb.slice,
    ospb.slice_date
from
    fin_plans fp
    join fin_benefit_plan_details fbpd on fbpd.plan_id = fp.id
    join inv_investments ii on ii.id = fp.object_id
    join odf_object_instance_mapping ooim on ooim.primary_object_instance_id = ii.id
    and primary_object_instance_code = 'project'
    and secondary_object_instance_code = 'financials'
    join fin_financials ff on ff.id = ooim.secondary_object_instance_id
    join odf_sl_plan_benefit ospb on ospb.prj_object_id = ff.id
    and ospb.slice_request_id = <populate with correct prj_blb_slicerequests.id value>
where
    ooim.secondary_object_instance_id = <populate with internal ID of the Benefit Plan>;