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

Configurable Form Not Defaulting Fields

  1. We want to default the DFF field value to an existing value from the same journey e.g. last year value. For this we are trying to write the Default statement using below query

FROM PER_ALLOCATED_CHECKLISTS PAC

,PER_ALLOCATED_CHECKLISTS PAC2

Per_allocated_tasks pat

WHERE PAC.CHECKLIST_STATUS = 'COM'

and pac2.allocated_checklist_id=:{PARAMETER.ALLOCATED_CHECKLIST_ID}

and pat.ALLOCATED_CHECKLIST_ID=pac.ALLOCATED_CHECKLIST_ID

and pat.attribute_category='Ownership Interest'

and pac2.PERSON_ID=PAC.PERSON_ID

and pac2.checklist_id=pac.checklist_id

This is working fine in BI Publisher when we are checking the data. But not getting defaulted in the Journey

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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