Cost Plan Timeslices is out of sync

Products

• Clarity PPM SaaS

Issue/Introduction

We have a portlet that runs query on the budgets and displays budget information on project dashboard. It was noticed that this portlet is unable to display the budget info even if budget exists in project.

I started looking at the bug and noticed that the data exists for this budget in fin_plans and fin_cost_plan_details tables, but there are no rows available in odf_ssl_cst_dtl_cost table.

Cause

The Time Slicing job went into a waiting state after a performance issue and never actually kicked off. 

Environment

Release : 16.0.1

Resolution

Cancelled the Time Slicing job which was in waiting state and rescheduled a new instance of the job. 

Once the TS job completed, the portlets and reports had the correct data.