PRJ_BLB_SLICES table displays multiple rows for Resource Availability

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'.