Dear Friend , 

  Lets Understand how to Configure an approval rule to route a notification using a supervisory hierarchy using Business Process Management(BPM) 


Lets take an Business use case that The business requirement is that an invoice needs to be approved by managers based on the amount limits set for each approver. 

Example 

An invoice amount of more than $10,000 dollars needs the approval of two groups. The first group is made up of the Manager, Senior Manager, and Finance Manager. The invoice can be approved by the next group of approvers. That approval group consists of the CFO, COO, and CEO. If the invoice amount is less than $10,000 dollars it only needs to be approved by the Manager, Senior Manager, and Finance Manager depending on the invoice amount. 

Solution: This requirement can be achieved by using two participants (First one is Serial type participant in parallel mode to complete first three levels of approvals and next is to use Parallel type participant in parallel mode)'

1 . Configure the approval rule for the invoice amount less than 1000 using serial type participant in parallel mode with supervisory hierarchy.




2 . Configure the approval rule for the invoice amount more than 1,000 and less than 10,000 using serial type participant in parallel mode with supervisory hierarchy.




3. Configure the approval rule for the invoice amount more than 10,000 using serial type participant in parallel mode with supervisory hierarchy.




4 . Configure the approval rule for the invoice amount more than 10,000 using parallel type participant one in sequential mode with the approval group.




5. Configure the approval rule to ignore the participant ID the invoice amount less than 10,000 using the parallel type participant one in sequential mode.



Thank You .

Comments

Post a Comment

Popular posts from this blog

How to Customize AP Invoice Approval in Oracle Fusion cloud Application using Business Process Management(BPM)

Image
Dear Viewers ,   Lets Understand with different case studies How to Customize AP Invoice Approval in Oracle Fusion cloud Application using Business Process Management(BPM) .   Case Study 1 #Configure an approval rule to route a notification to a requestor  It covers the most common business use cases of invoice approval in a Payables Department.   Each business use case provides how to configure the invoice approval rules, using various participants, invoice attributes, and list builders such as:   • Single Approver   • Approval Group   • Supervisor Hierarchy   • Job level Hierarchy   • Position Hierarchy   The information presented in this document is intended to help various users (Payables business users, Approval workflow administrators and Consultants) who are involved in the configuration of invoice approval policy to meet the various business use cases of invoice approvals in a Payables...
Read more
Image
Sometime , We need to know specific relationship between some important tables . Lets come to know one such important SQL Query to know the relationship between Transfer Order, Pick Slip Number, and Supply Orchestration SQL Query can be used to show the link between a Transfer Order, Pick Slip Number, and Supply Orchestration Belo is the screenshot for instance    The Required output We need from the report is below  The Query used for above requirement is below  SELECT  a.pick_slip_number ,   b.source_header_number transfer_order_number,   c.supply_order_number ,   c.supply_order_reference_number FROM   INV_PICK_SLIP_NUMBERS a ,   WSH_DELIVERY_DETAILS b ,   DOS_SUPPLY_HEADERS c ,   INV_TRANSFER_ORDER_HEADERS d,   INV_TRANSFER_ORDER_LINES e WHERE 1 =1   AND a.PICK_SLIP_NUMBER = 11022   AND a.pick_slip_batch_id = b.batch_id   AND b.source_header_number = d.header_number   AND d.header_id = e.header_...
Read more
Dear Friends ,  Below Query can be useful to find the Unit cost of Item at costing Module . We can have  FOR Unit cost OF Material under specified Val Unit code AND Cost Book SELECT TO_CHAR ( CICT . total_cost , 'fm99999999d00' ) UNIT_COST FROM CST_ITEM_COSTS_V CICT , CST_TRANSACTIONS CT WHERE 1 = 1 AND CICT . ITEM_NUMBER = :P_Item_Number AND CICT . TRANSACTION_ID = CT . TRANSACTION_ID AND TRUNC ( CICT . PREVIOUS_COST , 6 ) = ( SELECT TRUNC ( UNIT_COST_AVERAGE , 6 ) FROM cst_perpavg_cost WHERE PERPAVG_COST_ID = ( SELECT MIN ( PERPAVG_COST_ID ) FROM cst_perpavg_cost WHERE TRANSACTION_ID = CICT . TRANSACTION_ID ) ) AND CICT . VAL_UNIT_CODE LIKE 'XXXXXX' AND TO_CHAR ( CT . TRANSACTION_DATE , 'DD-MM-YYYY' ) BETWEEN TO_CHAR ( :P_START_DATE , 'DD-MM-YYYY' ) AND TO_CHAR ( :P_END_DATE , 'DD-MM-YYYY' ) And If you want to have the Query to fetch Current Item cost ...
Read more