The value of ETC on OWB and the Slice table is not matching. Here the Slice job has successfully completed.
For a specific week the value on OWB is coming as 16 but on Slice table the value is showing as 8.
So what could be the possible reason.
WHERE SLICE_REQUEST_ID = 300 /*This is for WEEKLYRESOURCEBASECURVE Slice Request*/
WHERE OBJECT_ID = PRASSIGNMENT.PRID /*passing a particular Assignment ID */
AND OBJECT_TYPE = 'ASSIGNMENT')
AND SLICE_DATE = t_date) /* Passing a date instead of t_date date */
If the above query is not correct also please suggest me.
Thanks in advance.