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
HCM Extract - User Entity BEN_EXT_ENRT_DPNT_UE provides incorrect value for Person ID
I am working on an HCM extract process to provide it to the insurance provider. I am trying to obtain the Life AD&D information for employee, spouse and child(ren).
I have used PER_EXT_SEC_PERSON_UE (employee root) followed by BEN_EXT_ENRT_DPNT_UE (level 1 - matched on parent.Extract Person ID = Person ID) and then BEN_EXT_ENRT_RTCVG_UE (level 2 - matched on parent.Person ID = Person ID).
The user entities should match based on employee's person ID. I believe BEN_EXT_DPNT_PERSON_ID should provide the employee person ID and BEN_EXT_DPNT_DPNT_PERSON_ID should yield dependent (in this case spouse) person id.
0