Get Started with Redwood for Oracle Cloud HCM Begin Now
How to get the correct last update date in the "Workforce Health and Safety Incidents" module?
Summary:
Good morning,
some analysis have been developed on the subject area "Environment Health and Safety - Incidents Real Time" to extract the information in delta to feed the Data Warehouse regarding this module: by extracting the result of the OTBI reports, the porpouse was to get all the data that have been changed in the system in the last two days.
In our case, the OTBI analysis is "DW - Incident Event - Spill": to handle the delta of changes in this analysis is used the "Incident Event Additional Details"."Incident Event Last Update Date" and the concepts are coming from the folder "Spill or Realease" of the SA "Environment Health and Safety - Incidents Real Time".
0