You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

How to add custom attribute in oracle cloud OTL time card

edited Mar 1, 2022 4:08PM in Workforce Management

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!