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
Extracting Position DFFs using HCM Extracts
Summary
Unable to locate the Position DFF and how to link this with employeeContent
Hi,
I have a requirement to use HCM extracts and retrieve our custom DFF values which are held within in positions (PER_POSITIONS_DFF).
Within the tables this data is located below:
Select hapf.ATTRIBUTE1
From hr_all_positions_f hapf,
per_all_assignments_m paam
where paam.POSITION_ID = hapf.POSITION_ID
AND TRUNC (SYSDATE) BETWEEN hapf.effective_start_date and hapf.effective_end_date
1. Are these values held in the User entity (PER_EXT_SEC_POSITION_UE)?
2.If they are what attribute does this belong to?
Tagged:
1