Create Invoice Approval Process in Oracle Accounts Payable Using AME
Bottom
It is important to know how the invoice approval process will work in Accounts Payable in the Oracle application using AME (approval management engine).
AME works based on our definitions of delegations and if accounts payable require AP invoices to be submitted for approval based on the invoice payment group, invoice source, and invoice type.
The AP invoice approval workflow has been customized to handle invoice routing.
AME is used to derive the approvers to whom the workflow will send invoices for approval.
To satisfy the approval requirements for AP invoice approval, new rules must be created along 3 custom attributes.
Next, we will know how AME will work and how to define all the necessary settings for AME to work correctly. The following are the required settings for AME.
Attributes
Define attributes:
We need to create 3 custom attributes that will be used in the rules to satisfy the requirements of the Clients.
Note: Please note that these 3 custom attributes have already been created and should not be modified; otherwise this will affect the workflow process. These attributes refer to custom packages.
The 3 new custom attributes are:
LMAP_ASSOCIATED_INVOICE_TYPE,
LMAP_DM_CM_%,
LMAP_DM_CM_AMOUNT.
Navigation:
Responsibility = AME Application Administrator
Approvals> select the ‘Attributes’ tab
Steps to create the ABCDAP_ASSOCIATED_INVOICE_TYPE custom attribute:
1. Click on the “Transaction Type” drop-down menu and select “Payable Invoice Approval”.
list of values option Click Continue
2. Scroll down and click the ‘Add Attribute’ button.
3. The next screen to display will be ‘Choose an attribute level’. On this screen, select ‘header attribute’ as the attribute level.
4. Click the “Continue” button.
5. On the next ‘Create an Attribute-Step 1’ screen, click the ‘Create New Name’ button to create a new custom attribute.
6. In the next step ‘Create an attribute – Step 2’, enter the Name for the custom attribute.
‘LMAP_ASSOCIATED_INVOICE_TYPE’.
7. Click Continue.
8. In the next screen ‘Create an attribute – Step 3’, enter the Attribute Type = ‘String’, Description = ‘Attribute to verify the type of associated invoice type’, Status usage = ‘No’, Usage = ‘SELECT LMAP_WFAPPROVAL_PKG_36 .get_dm_cm_type (: transactionId) FROM DUAL’ ..
9. Click on ‘Continue’.
10. The custom attribute ‘LMAP_ASSOCIATED_INVOICE_TYPE’ has been created.
In the same way you can create another 2 custom attributes.
Steps to create 2 other custom attributes:
The other 2 attributes are also created in the same way with the following values:
1. LMAP_DM_CM_%:
Name = ‘LMAP_DM_CM_%:’
Enter the Attribute Type = ‘number’,
Dscription = ‘LMAP attribute to calculate the DM / CM value as a percentage for
interconnected invoice ‘,
Use of state = ‘No’,
Use =
‘SELECT LMAPLMAP_WFAPPROVAL_PKG_36.get_dm_cm_percent (: transactionId)
FROM ap_invoices_all inv1
, ap_system_parameters_all asp
WHERE inv1.org_id = asp.org_id ‘
And inv1.invoice_id =: transactionId
2. LMAP_DM_CM_AMOUNT:
Name = ‘LMAP_DM_CM_AMOUNT’
Enter the Attribute Type = ‘Currency’,
Dscription = ‘LMAP attribute to calculate DM / CM amount for approval routing’,
Use of state = ‘No’,
Use =
‘SELECT abs (LMAP_WFAPPROVAL_PKG_36.get_dm_cm_amt (: transactionId))
, NVL (inv1.Invoice_Currency_Code, asp.Invoice_Currency_Code)
, NVL (inv1.Exchange_Rate_Type, asp.Default_Exchange_Rate_Type)
FROM ap_invoices_all inv1
, ap_system_parameters_all asp
WHERE inv1.org_id = asp.org_id
And inv1.invoice_id =: transactionId ‘
Terms and Conditions
Define conditions:
Responsibility = AME Application Administrator
Navigation:
Responsibility- AME Application Administrator
Approvals: select the ‘Conditions’ tab
The following example shows the creation of a condition and a rule:
A rule must be created based on the following conditions and the approver will be DAVID.
1. The invoice payment group (concept) can be “NON-COMMERCIAL” and “EMPLOYEE”
2. Operating unit = ABCD
3. All invoices except prepayments
4. Manually created invoices
5. Invoice amount in the range of $ 0 to $ 50,000
Steps to create the first condition:
1. Click on the “Transaction Type” drop-down menu and select “Payable Invoice Approval”.
option from the list of values.
2. Click on ‘Continue’.
3. The next screen is the ‘Conditions’ screen as shown below. Scroll down and click the ‘Add a condition’ button.
4. On the next screen, ‘Choose a condition type’, select Condition type = ‘ordinary header’.
5. On the next screen, the ‘Choose the condition attribute’ screen shown below, select the
attribute name ‘SUPPLIER_PAY_GROUP_LOOKUP_CODE’ as shown below and click the ‘Continue’ button.
6. On the next screen, create a Condition on a String Attribute ‘, enter the values for the
attribute as NO TRADE and EMPLOYEE as shown below and click ‘Continue’.
Now click ‘Exit’ to exit creating conditions. On the next screen, you can see that your condition has been created as shown below.
Define rules:
Responsibility = AME Application Administrator
Responsibility = AME Application Administrator
> Approvals> Alternative ‘Rules’ region
1. Select Transaction Type = Accounts Payable Invoice Approval from the drop-down list as shown below.
2. Click Continue.
3. The next screen will show the list of existing rules in AME.
4. On this screen, scroll down to the bottom of the page and click the “Add rule and usage” button.
5. The next screen displayed is’ Add a rule-Step 1.
6. Enter the description of the rule as shown below. The rule description should summarize the rule conditions as shown below as an example and click “continue”.
‘LMAP (ABCD) NON-COMMERCIAL, EMPLOYEE (SOMNATH) Invoice for the range of INR 0-50K’
7. On the next ‘Add a rule-Step 2’ screen, select the radio button for the approval type. Select approval type = ‘chain of authority includes approval group’
8. On the next screen, ‘Add a rule-Step 3’, select the approver from the ‘Approval’ drop-down menu.
9. The next screen is ‘Add a rule-Step 4’. Here you select a condition to complete the rule. The minimum requirements to create a rule include an approval group and a condition.
Here, select one of the condition attributes ‘SUPPLIER_INVOICE_PAYGROUP_LOOKUP_CODE’ as shown below. In the list of conditions for the payment group, select the required condition and click ‘Continue’.
10. When ‘Continue’ is clicked, the rule is created and you will be redirected to a confirmation.
11. Now click on this rule to add the rest of the conditions. When you click on this rule on the previous page, you will be redirected to the ‘Edit a rule’ screen.
12. In the drop-down menu of ‘Element to change’, select the option ‘ordinary conditions’, to add new conditions to the same rule.
13. On the next screen, click on ‘Add Condition’ to add the conditions.
14. The next screen is ‘Select ordinary condition attributes’, select the other conditions.
15. From the drop down menu, select the attribute ‘SUPPLIER_INVOICE_SOURCE’ and select the condition for the attribute as ‘Manual Invoice Entry’ and click ‘Continue’
16. By clicking ‘Continue’, this condition will be added to the rule as shown below.
17. Follow the steps to create other conditions for invoice type, invoice amount, and organization identification, as shown below.
** Please note that there are 5 conditions in this rule, one for each of the requirements.
With this, the rules have been created according to the requirements described above and from now on, Invoice Approval works according to the conditions and rules that we define.
By completing this document, you will be able to create AME for Accounts Payable.