Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
SQL based Approval Workflow
Due to attribute limitations of the job requisition approval workflow process, so we tried to explore the possibility of using a SQL-based. Unfortunately, we got stuck on the following errors
ORABPEL-30049
exception.code:30049exception.type: ERRORexception.severity: 2exception.name: Error in routing slip.exception.description: The task is assigned to an invalid user oraext:query-database-with-bindvar('select distinct usr.username from hr_org_unit_classifications_f hac 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.
Query :