PR Approval routing based on Specific Position passed in the DFF field

Summary:

We have a requirement for Purchase Requisition / Purchase Order approval routing to be based on the position passed in a Descriptive Flexfield (DFF) field. The user associated with that position should be the approver for the PR / PO.

For example, if User A (a Manager) raises a requisition and captures 'Program Director' in the Position DFF field, the requisition approval should be routed to User Z (who holds the Program Director position).

Please let us know the possibilities to achieve this requirement.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):