Issue with Compensation Hierarchy Determination Formula - How to achieve a particular requirement — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Issue with Compensation Hierarchy Determination Formula - How to achieve a particular requirement

edited Jul 10, 2025 4:58PM in Compensation 2 comments

Summary:

Hi All,

As part of compensation implementation, we have below requirement for Work force compensation plan approval.

Approval Hierarchy for Workforce Compensation plans:

Manager needs to enter values for his subordinates in Compensation Worksheet.

1st Approver : CEO-1 (person just below CEO) in the manager hierarchy

2nd Approver: HR attached for that person at employment DFF level.

We used Fast formula to achieve the same. The formula type is: Compensation Hierarchy Determination Formula

Issues being faced:

  1. When we code the FF as:

When CMP_IV_ASSIGNMENT_ID <> Assignment ID of ( CEO-1 )

Then RETURN CEO-1(-999)

In this case only CEO-1 is able to see the worksheet, Line manager is not able to see the plan as we are by passing that person.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!