We load the Clarity informations to our corporate Business Warehouse Application. On daily basis we load the the timeslice related data (availability, allocations, ETC and actuals) based on a delta load mechanism. We only load the records that are created/ changed in the last 3days to prevent that we have to load all records. We have implemented some
workarounds in the loading logic to ensure records that are deleted from the timeslice tables are also removed in the business warehouse environment.This mechanism works well.
We noticed that the "Last_Updated_Date" column is removed from the PRJ_BLB_Slices table of v13.3, this seriously hampers our loading logic to our business warehouse solution and prevents us to upgrade from 13.0.1 patch 6 to 13.3.
Can any one provide us a solution?
How can we ensure we can continue to identified the last updated date for the
records in the PRJ_BLB_SLICE table?
Thanks and Regards,