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
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

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

    SQL based Approval workflow

    in Recruiting, Opportunity Marketplace 2 comments

    Facing error while configuring SQL based approval workflow for JOB requisitions.

    I have checked at backend query return correct USERNAME.

    Expression : orcl:query-database('SELECT USERNAME FROM PER_USERS USR WHERE USERNAME =''abc12765@test.com''',true(),true(),'jdbc/ApplicationDBDS')

    exception.description: The task is assigned to an invalid user orcl:query-database('select username from per_users usr where username =''abc12765@test.com''' in realm jazn.com. The routing slip is associated with the task definition default/HcmRecHiringCoreRequisitionApprovalComposite!11.13.23.04.0/RequisitionApprovalHumanTask.
    exception.fix: Verify that the user is specified correctly in the routing slip in the task definition.

    Issue Type

    TASK_30049

    Issue Title

    Error due to assignment of human task to invalid user.

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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