Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
PER_POSITION_EXTRA_INFO_ALL_UE Pulling the EIT records for all rows in HCM Extract
Summary:
I am creating an HCM Extract with the historical Root UE for positions, identified as PER_EXT_SEC_HISTORY_POSITION_UE. For EIT information, I am using PER_POSITION_EXTRA_INFO_ALL_UE. I updated a position EIT as of June 15, 2024, but this update is appearing in all position-dated rows in the output.
What filter should I add to the extra info UE so that the position's effective start date falls between the EIT's effective start date and end date? I tried the query pos.effective_start_date between target.effective_start_date and target.effective_end_date, but it isn't valid.
0