Oracle Fusion application technology stack has an inbuilt approval management system and it’s built on top of the BPM ( Business process management) Engine. With this tool oracle fusion, cloud workflows can be configured as per the business needs. Note that this is only with respect to approvals and no process changes can be done.

BPM Approval Management

There are various reasons we may need to modify approvals of a process like

• AP Invoice Approval
• Journal Approvals
• Supplier Profile changes

and may want the notification actions to be executed by different users/approvers.

We will see in this article how approval works in Oracle Fusion SaaS and how do we modify a BPM approval Task.

Approval Tasks

Approval tasks are the BPM tasks that can be configured. These tasks can be accessed from the functional setup manager.

When you login to Fusion Functional setup manager and search for %Manage%Approvals%

When you click on task eg( Journal Approval) related to approval management they redirect to the BPM interface which looks like below

This is the interface where the BPM task can be modified for custom approvals

AP invoice Approval Configuration in fusion

We will take the example of AP invoice Approval.

Login with Administrator super user

Click on Task Configuration

• Select Task FinApInvoiceApproval
• Click Edit (Purple Arrow)
• click Assignees
• Click Go to Rule ( Red Arrow)

Identify Active , Inactive Rules

E.g Customizing Oracle Fusion Cloud Workflow for AP Invoice

In our requirement, we need to modify the AP invoice Approval so that if the Invoice Header (Amount>1000) has the Requestor Name the Approval should go to the name entered in the requestor field. else it should go to the person’s manager who is creating the invoice ( the default functionality).

So we create a rule name IDCMgrApprovalRule by hitting the Green + icon

and add our conditions in the IF and Then blocks. The Then block assigns the approvers for the workfow.

Test approval in Fusion Applications

To test if our customization is successful or not we need to create and invoice and send for approval.

Create invoice

Invoice Actions> Validate

Invoice Actions> Approval>Initiate

The Approval history without putting the requestor name

And once you put the Requestor name and check approval history you will see the new approves added to the workflow notification.

Tips And challenges

We face issues when we need to assign a value. For example how do I get the Requestor name in the assignment field.

Task and Invoice header are like Cursors to the Record Set and these will hold the value of data entered in the invoice screen.

Expand the invoice header , since Requestor is entered at header level. And find the requestor name field.

click insert to Expression. The value gets assigned to the workflow approval field.

Sql Query to check where the approval has gone .

SELECT APPROVAL_HISTORY_ID,CREATION_DATE,INVOICE_ID, LINE_NUMBER, AMOUNT_APPROVED, APPROVER_ID, HISTORY_TYPE, RESPONSE FROM AP_INV_APRVL_HIST_ALL WHERE INVOICE_ID IN(SELECT INVOICE_ID FROM AP_INVOICES_ALLWHERE INVOICE_NUM = ‘UPS101’) ORDER BY CREATION_DATE desc

How to check which workflow task is triggered

Go To tools > Transaction Console>

Actions> Download will download a local CSV file. This file has the task name which triggered.

Thanks for reading this article.

For more information of Approvals refer oracle documentation here

AP Invoice Approval MOS Note Doc ID 2641736.1

More fusion apps tech articles