Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Dynamic Approval Rules based on PO Total Amount — 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

Dynamic Approval Rules based on PO Total Amount

Accepted answer
45
Views
11
Comments
edited Apr 16, 2021 8:32AM in Purchasing 11 comments

Content

Hi,

With reference to post : https://cloudcustomerconnect.oracle.com/posts/00d17df2cc,

I was able to achieve dynamic approvals for PO based on project number. However, I want to add more condition like if  total PO amount > input_value_constant2 and  total PO amount < input_value_constant3 so as to achieve dynamic approvers based on PO amount and project combination. I came to know that total PO amount is not stored directly in the PO_HEADERS_ALL table and we can find total amount using Doc ID 433220.1, but when I try to merge the 2 queries, approval rules fail, however the same query fetches data while running normal SQL. Not sure what is going wrong. 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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