Configuring Rate-Based Salary Basis with Conditional Calculation Logic for XX Fund in HCM.
in Compensation
We have a requirement to configure a Rate-Based Salary Basis in Oracle Fusion HCM involving four interdependent rates, where one of the rates requires conditional/tiered calculation logic. Looking for guidance on the best approach (Salary Basis + Elements + Fast Formula vs. other options) to achieve this.
Business Requirement:
We have four components:
- Total Pay (Element rate) – entered by the user (input value, base rate)
- Basic Salary (Derived rate)– derived as 40% of Total Pay
- XX Allowance – an existing rate component
- XX Fund (Derived rate) – calculated using the following conditional logic:
- a) If Basic > 25,000 → XX Fund = 15% of Basic
- b) If Basic ≤ 25,000:
- i.
Tagged:
0