Background
It is important to know how the Invoice Approval process will work under Accounts Payable in the Oracle Application using AME (Approval Management Engine).
AME works according to our definitions of delegations and if accounts payable require AP Invoices to be routed for approval based on the invoice payment group, invoice source, and invoice type.
AP’s invoice approval workflow has been customized to handle invoice routing.
AME is used to derive the approvers to whom the workflow will route invoices for approval.
To satisfy the approval requirements for Accounts Payable 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 configurations for AME to work correctly. The following are the settings required for AME.
attributes
Define attributes:
We need to create 3 custom attributes that will be used in the rules to satisfy the Clients’ requirements.
Note: Please note that these 3 custom attributes have already been created and should not be altered; 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_QUANTITY.
Navigation:
Responsibility = AME Application Administrator
Approvals > select the ‘Attributes’ tab
Steps to create custom attribute ABCDAP_ASSOCIATED_INVOICE_TYPE:
1. Click the ‘Transaction Type’ dropdown menu and select ‘Payable Invoice Approval’
option from the list of values. Click Continue
2. Scroll down and click the ‘Add Attribute’ button.
3. The next screen to be displayed 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. On the next ‘Create an Attribute – Step 3’ screen, enter the Attribute Type = ‘String’, Description = ‘Attribute to check the associated invoice type type’, Usage Status = ‘No’, Usage = ‘ SELECT LMAP_WFAPPROVAL_PKG_36 .get_dm_cm_type (:transactionId) FROM DUAL’..
9. Click ‘Continue’.
10. The custom attribute ‘LMAP_ASSOCIATED_INVOICE_TYPE’ has now been created.
2 other custom attributes can be created in the same way.
Steps to create another 2 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’,
Description = ‘LMAP attribute to calculate the DM/CM value as a percentage for
interconnected invoice’,
Usage 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_QUANTITY:
Name = ‘LMAP_DM_CM_AMOUNT’
Enter the Attribute Type = ‘Currency’,
Description = ‘LMAP attribute to calculate the amount of DM/CM for approval routing’,
Usage 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
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 payment group of the invoice (concept) can be ‘NON-COMMERCIAL’ and ‘EMPLOYEE’
2. Operating unit = ABCD
3. All invoices except advance payments
4. Manually created invoices
5. Invoice amount in the range of 0 to $50,000
Steps to create the first condition:
1. Click the ‘Transaction Type’ dropdown menu and select ‘Payable Invoice Approval’
value list option.
2. Click ‘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, ‘Select Condition Attribute’ 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 NON-BUSINESS and EMPLOYEE as shown below and click ‘Continue’.
Now click ‘Exit’ to exit the condition creation. 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>Alternate ‘Rules’ Region
1. Select the Transaction Type = Accounts Payable Invoice Approval from the drop down list as shown below.
2. Click Continue
3. The next screen will display 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-Ste 1.
6. Enter the rule description as shown below. The rule description should summarize the rule conditions as shown below as an example and click ‘continue’.
‘LMAP (ABCD) NO MERCHANT, EMPLOYEE (SOMNATH) Invoice for range INR 0-50K’
7. On the next ‘Add a Rule-Step 2’ screen, select the radio button for the type of approval. Select approval type = ‘the chain of authority includes an approval group’
8. On the next screen, ‘Add a rule-Step 3’, select the approver from the drop down menu for ‘Approval’.
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 payment group, select the required condition and click ‘Continue’.
10. Clicking ‘Continue’ will create the rule 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 ‘Item to change’, select the option ‘ordinary conditions’, to add new conditions to the same rule.
13. On the next screen, click ‘Add Condition’ to add the conditions.
14. The next screen is ‘Select attributes of ordinary conditions’, select the other conditions.
15. From the dropdown menu, select the attribute ‘PROVIDER_INVOICE_ORIGEN’ and select the condition for the attribute as ‘Manual entry of invoices’ and click ‘Continue’
16. Clicking ‘Continue’ will add this condition to the rule as shown below.
17. Follow the steps to create other conditions for Invoice Type, Invoice Amount, and Organization ID, as shown below.
** Note that there are 5 conditions in this rule, one for each of the requirements.
With this, the rules have been created based on the requirements outlined above, and from now on, Invoice Approval works based on the conditions and rules that we defined.
By completing this document, you will be able to create AMEs for accounts payable.