Apps To Fusion

1. Enable AME- Workflow customization in Self Service 

2. Understanding AME Concepts

In AME, the approver list is calculated using something known as Approver Group. The approver group can be a static list of people or a dynamic list of people. The dynamic list of approvers is calculated by executing a SQL statement. This SQL statement and its unit testing will be shown as a video demo in the next article.

In this case, we will write a SQL Statement that returns the name of the Manager's Manager of the person that created the Holiday Rejection Complaint record.

In AME, each AME Flow can be considered as an "AME Transaction Type". The SSHR screens passes a parameter to the AME Transaction Type. The name of the parameter passed by Self Service HRMS to AME is called TransactionId. This Transaction Id gives a handle back to the original transaction, which in this case is data entered via Holiday Rejection Complaint screen. Therefore by using the TransactionId, the AME Engine/AME SQL's can reference the originating transaction for which Approver List is being calculated.

While the Approval is in progression, the data remains in temporary tables named HR_API_TRANSACTION_VALUES [in case of SIT. Some other screens use XML CLOB in hr_api_transactions.transaction_document].  Therefore if your custom logic within the AME wants to access the original transaction data, that can be done by either querying HR_API_TRANSACTION_VALUES or by parsing the XML within the CLOB column. 

The primary key for table HR_API_TRANSACTIONS is Transaction_id. This Transaction Id is passed as a parameter to the AME Engine for SSHR AME Transaction Type. Therefore AME Trx Type will be passed the TransactionId using which it can get the handle to contents of HR_API_TRANSACTIONS

If you revisit Part-2 of this article, you will notice that the AME Transaciton Type and AME Trx Type ApplicationId are passed as parameters to the AOL Form Function. 

The parameters field in AOL Function definition contains AMETranType=SSHRMS&pAMEAppId=800

If you recollect from Article Part-3 in this series, we passed the name of the Custom Workflow process XXFT_HR_SIT_JSP_PRC as a parameter to the AOL Function for this screen. Effectively, the Workflow Process parameter to the screen tells Self Service HRMS the name of the WOrkflow Process within the HRSSA workflow that must be excecuted. Name of this process is captured in HR_API_TRANSACTIONS table.In the Self Service HRMS AME Transaction Type, Oracle delivers a pre-defined attribute named WORKFLOW_PROCESS_NAME. This attribute has a SQL attached to it which reads HR_API_TRANSACTIONS  via a pl/sql API. It means that, whenever the AME is used in SSHR, the value of the attributes within the AME Transaction type is calculated. This Attribute uses a SQL Statement to find the name of the workflow process from table HR_API_TRANSACTIONS. Needless to say, this SQL statement uses the TransactionId as shown below image

 

We will be building a logic in AME that is similar to below

IF WORKFLOW_PROCESS_NAME='XXFT_HR_SIT_JSP_PRC' 

THEN

    Return Approver Name from AME Attribute XXFT_MANAGERS_BOSS_GROUP

END IF ;

XXFT_MANAGERS_BOSS_GROUP will be a custom defined AME Approval Group that you can define. To this AME Approver Group, you can attach the following SQL Statement. This SQL statement returns the FND_USER.USER_ID of the Manager's manager for the employee that created a record in "Holiday Rejection Complaint" screen. 

These are listed below

1. Create AME Condition that checks if the workflow process name = XXFT_HR_SIT_JSP_PRC

5. Create AME Approver Group XXFT_MANAGERS_BOSS_GROUP returns the name of Manager's Manager FND_USER.USER_ID

2. Create an AME Rule named "XXFT Holiday Rejection Complaint"

3. Attach this rule to the condition of Step 1

4. Add an action to this rule get the approver from XXFT_MANAGERS_BOSS_GROUP

6. When the end user initiates a "Holiday Rejection Complaint", then the custom HRSSA workflow process is instantiated. This calls the AME Engine to get next approver. 

The condition of Step (2) above is evaluated to be TRUE. Therefore the approver is returned by executing the SQL Statement against XXFT_MANAGERS_BOSS_GROUP

The above video also explains how to unit test your development for approval group.

Basically the above video joins different pieces like Workflow, Screen, AME and HR_API% tables together.

For in-depth AME hands-on practical training visit http://focusthread.com/training

In the next article you will see how to implement the above steps