PRC:PO: How To Make Approval Workflow Based On Cumulative Amount Of Changes on PO ? (Doc ID 2927650.1)

Last updated on FEBRUARY 12, 2023

Applies to:

Goal

Qn1:It's Required to make Purchasing Approval Workflow based on Cumulative Amount of changes for each time user make change order to the Same PO
 

For Example:-

Required behavior ( Approval based on cumulative amount of changes)
due the Approvals Workflow
- If the Cumulative amount of changes to the PO less than 500 it will be Approved by User X
- If the Cumulative amount of changes to the PO Between 500 and 1000 it will be Approved by User X, and Y
- If the Cumulative Amount of changes to the PO more than 1000, it will be approved by User X, Y and Z

- I have a Purchase Order with amount 6000
- Change Order Number 1, the net Change Order Amount is 300 >> the Approval will go to User X
- Change Order Number 2, the net change Order Amount is 100 and Cumulative Change Amount is 400 (300+100) >> then Approval will go to User X
- Change Order Number 3, the Net Change Order Amount is 200 and Cumulative Change Amount is 600 (300+100+200) >> then Approval should go to User X, and Y due to the Cumulative Amount
- Change Order Number 4, the net Change Order Amount is 500 and cumulative change order Amount is 1100 (300+100+200+500), then Approval should go to User X, Y and Z due to the Cumulative amount of changes

Actual Behavior
- Approval is based on Net amount of each change


is there a way to make Approval be based on Cumulative Amount of changes Not Spearate amount of Changes ?
 
Qn2:is there a way to make the value set derive the Change values automatically or i have to make the user enter those values manually ?
 
Qn3:For Final Confirmation the Steps would be as follow :
1- Create DFF on PO Header
2- Create Report which Generate the Cumulative of amount of changes
3- Add that amount derived from the report to that DFF
4- Build workflow based on the Amount at the DFF
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.