Journey Eligibility for Pending Workers based on Proposed Person Type – is it actually achievable?
in Journeys
Hi team,
I'm working on an Oracle HCM Cloud implementation (Journeys module) and I've hit what appears to be a fundamental data access limitation. I'd like to share our setup and findings, and ask whether anyone has managed to solve this differently.
Business Requirement
We need to automatically allocate a Journey to Pending Workers (created via Move to HR from ORC) only when:
- Proposed Person Type = Regular OR Trainee/Stagiaire
- Grade ≠ HOURLY
Our Setup
Eligibility Profile (Profile Usage: Checklist)
- Employment > Grade: HOURLY, Exclude = ✅
- Other > Formula: "IVG Proposed Person Type"
Fast Formula (Type: Participation and Rate Eligibility)
Plain Text
L_ASG_ID = get_context(HR_ASSIGNMENT_ID, -1)L_PERSON_ID = get_context(person_id, -1)ELIG_EP_1 = ' 'ELIGIBLE = 'N'l_asg_id_char=TO_CHAR(L_ASG_ID)l_person_id_char=TO_CHAR(L_PERSON_ID)ELIG_EP_1 = GET_VALUE_SET('IVG_JOURNEY_FF_PROPOSED_PERSON_TYPE','|=ASSIGNMENT_ID='''||l_asg_id_char||'''')IF ( (ELIG_EP_1 = 'Trainee/Stagiaire' OR ELIG_EP_1 = 'Regular'))THEN (ELIGIBLE = 'Y')RETURN ELIGIBLE
Tagged:
0