Get Started with Redwood for Oracle Cloud HCM Begin Now
How to add custom attribute in oracle cloud OTL time card
Summary:
Hi All
I have a requirement to visible below format in Responsive UI Layout
Assignment Name| Position name | Business Units Name
for this created two value set
1.POSITION_BU_VALUE_SET(Table)
From Clause:-hr_all_positions_f_tl haot, per_all_assignments_f paaf, HR_ORGANIZATION_UNITS_F_TL houf
Value Column Name-->houf.Name ||' | '|| haot.Name ||' | '|| paaf.Assignment_number
where clause
houf.organization_id=paaf.organization_id
AND paaf.POSITION_ID=haot.POSITION_ID
AND paaf.Assignment_type='E'
AND paaf.effective_latest_change = 'Y'
AND TRUNC(SYSDATE) BETWEEN haot.EFFECTIVE_START_DATE AND haot.EFFECTIVE_END_DATE
Tagged:
0