Skip to Main Content

Database table for vacation delegation

User_P797OOct 20 2022

Hi, we are currently using the auto-reject feature for Purchase Requisitions if a user is not in the correct approval group for the PR. This is accomplished with a SQL database query involving the flex value sets for approval groups. However, when someone sets a vacation delegate, the auto-reject may not work because there is no way to reference the approval delegate. As a result, an approver that has been delegated via the vacation delegation workflow may be able to approve a PR that they should not be able to. Being able to reference the vacation delegated approver in the SQL query would allow this work, as well as being able to reference it in ad hoc reports and data models could be useful.

Post Details
Added on Oct 20 2022