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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

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!