My Oracle Support Banner

Fusion Compensation: How To Access The Salary for a Previous Assignment in Fast Formula (Doc ID 1998724.1)

Last updated on MARCH 21, 2024

Applies to:

Oracle Fusion Workforce Compensation Cloud Service - Version 11.1.9.2.0 and later
Oracle Fusion Compensation - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Goal

How can we access the Salary of a person's previous assignment so we can use it in calculating the prorated salary?

 

Additional information:

Attempting to write a 'Compensation Default and Override' type fast formula, modifying a copy of the seeded Formula (CMP_ELIGIBLE_SALARY_PRORATION_DAILY_AVERAGE_USING_FTE). The client has frequent Global Transfers where the LDG of the employee will change and as a result the employee will get a new assignment.
The client wants to have the prorated salary calculated for an employee for the whole compensation cycle regardless of the assignment change. However, the DBI (CMP_ASSIGNMENT_SALARY_AMOUNT) only returns the value for the "Current Active" assignment.


 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.