Introduction

Understanding approval rules in Oracle Fusion can often seem like a puzzle. This is particularly true when comparing modules like Transaction Manager and BPM Worklist. For instance, in Transaction Manager, the approval for Individual Compensation Plans (ICPs) is known as “Administer Individual Compensation“, while in BPM Worklist, it’s referred to as “VariableAllocationTask“.

The Key to Comparison: A SQL Query

A helpful SQL query is available for Oracle Fusion users. This query not only compares the approval names in Transaction Manager and BPM Worklist but also provides essential details like Description, Category Name, Sub-Category Name, and Approval Status for each approval.

SQL Code:

SELECT HAPT.NAME
   ,HAPT.DESCRIPTION
   ,HRPB.TASK_FILE_NAME TaskName
   ,HRPB.TXN_MODULE_IDENTIFIER
 ,HAPT.CATEGORY_NAME
   ,HRPB.CATEGORY_CODE
 ,HAPT.SUBCATEGORY_NAME
   ,HRPB.SUBCATEGORY_CODE
   ,HRPB.FAMILY
   ,DECODE(HAAO.APPROVAL_DISABLED,'true','Bypassed','false','Enabled') "Enabled Status"
 FROM FUSION.HRC_ARM_PROCESS_B HRPB
   ,FUSION.HRC_ARM_PROCESS_TL HAPT
   ,FUSION.HRC_ARM_APPROVAL_OPTIONS HAAO
 WHERE HRPB.PROCESS_ID=HAAO.PROCESS_ID
  AND HRPB.PROCESS_ID=HAPT.PROCESS_ID
  AND HAPT.LANGUAGE = 'US'
  AND HRPB.FAMILY = 'HCM'
 ORDER BY 1  

Analyzing the Results

Running this query allows users to effectively map and understand the differences and similarities in approval rules across these two platforms.

Screenshot: Transaction Manager for “Administer Individual Compensation”.

Screenshot: BPM Worklist screen for “VariableAllocationTask”.

Practical Example: Individual Compensation Plans

Let’s delve into the specifics with the example of ICPs. The difference in naming conventions between the two systems can be a source of confusion for users and administrators. This SQL query aids in clarifying these ambiguities.

Special thanks to Mandeep k. Gupta for his invaluable assistance with the SQL code that made this blog possible.

Conclusion

This SQL query tool is a valuable resource for Oracle Fusion users, simplifying the understanding of approval processes across different modules. It’s a testament to the importance of having the right tools and knowledge in managing complex ERP systems.