ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Cost plan details not populated in ODF_SSL_CST_DTL_COST when XOGed

book

Article ID: 196953

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Cost plan details are not populating in ODF_SSL_CST_DTL_COST table after XOG. (It is updating after time slicing job run)
If we update/create  cost plan record manually it is appearing immediately in ODF_SSL_CST_DTL_COST.  we need same behavior with XOG.

Environment

All Clarity releases

Resolution

The instaslice tables are not updated via xog per design due to performance reasons.
The time slicing job by default runs once a minute. If you have changed the time slicing job run schedule, allow a time slicing job run after the XOG update happened.

 

Additional Information

The following observations are made on the ODF_SSL_CST_DTL_COST table population:

  • When the Plan Period of a Cost Plan is Monthly, the values in ODF_SSL_CST_DTL_COST are stored per month
  • When the Plan Period is Annual, the values are stored per year
  • However, in an Annual plan if we change the time scale to months, and enter values against only certain months, then values for only those months are separately stored, and the remaining period continues to hold aggregated values.