Can we call SQL in order to determine a workflow approver? — Cloud Customer Connect
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

Can we call SQL in order to determine a workflow approver?

edited Sep 21, 2020 3:26PM in Workforce Management 1 comment

Summary

We have a Descriptive Flexfield which holds name of Employee Mentor, we want to send a workflow approval to this Mentor

Content

We have a Descriptive Flexfield which holds name of Employee Mentor, we want to send a workflow approval to this Mentor

The flexfield as a valueset with Table Validation as defined below

MENTOR_PERSON_DETAILS

Module: Core Setup

Value Data Type: Character

From Clause

per_employees_x pex, PER_ASSIGNMENT_SECURED_LIST_V ASG, PER_ALL_PEOPLE_F PER

Value Column Name

pex.LAST_NAME || ' ' || pex.FIRST_NAME || ' ' || asg.assignment_name

Value Column Type: VARCHAR2

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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