IntroductionUnderstanding 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".Click to Enlarge Images for Detailed InsightClick to Enlarge Images for Detailed InsightThe Key to Comparison: A SQL QueryA 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 1Analyzing the ResultsRunning this query allows users to effectively map and understand the differences and similarities in approval rules across these two platforms.Click to Enlarge Images for Detailed InsightScreenshot: Transaction Manager for "Administer Individual Compensation".Click to Enlarge Images for Detailed InsightScreenshot: BPM Worklist screen for "VariableAllocationTask".Click to Enlarge Images for Detailed InsightPractical Example: Individual Compensation PlansLet'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.Click to Enlarge Images for Detailed InsightSpecial thanks to Mandeep k. Gupta for his invaluable assistance with the SQL code that made this blog possible.ConclusionThis 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.
