Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
How to identify the changed record when effective start date change?
On changes only extracts in situations where the effective start date can change, do you have any suggestions on how to identify the changed record?
The use case is our element entry extract has key attributes of element entry id, effective start date, everything works fine on any updates UNLESS the start date moves. We don’t get the “old” values because it’s a new “primary key”.
The problem is that in our DB environment we don’t see the OLD and don’t have a record to tie back to so we end up creating a row that overlaps the existing value.
Tagged:
0