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.
PRJ_BLB_SLICES table displays multiple rows for Resource Availability
Article ID: 198805
Updated On:
Products
Clarity PPM On Premise
Issue/Introduction
PRJ_BLB_SLICES table displays multiple rows for Availability of a labor resource on a single day even though availability is not updated.
Cause
End user was running Select queries on the incorrect table column
Environment
Release : All Release
Component : CA PPM Timeslice
Resolution
In the PRJ_BLB_SLICES table to obtain correct slice data, the Select query should retrieve data based on 'SLICE_DATE' column instead of 'CREATED_DATE'.
Feedback
Yes
No
Powered by
