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

SQL query in BPM to auto reject

edited May 15, 2025 4:28PM in Purchasing 10 comments

Summary:

We have a requirement to auto reject requisitions if the deliver-to location is not an approved location for requester. We are maintaining a mapping set to store the requester and valid deliver-to locations. Only valid combinations are loaded in this mapping set.

I've setup a dedicated approval stage with a simple 1=1 auto rejection rule and added the below query as the skip rule. The SQL will result in 0 if all PR line locations are valid for the requester or results in 1 if any one of the PR line is invalid. However, none of the below 4 seems to work in BPM.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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