Fusion Compensation: Need To Pull Different Manager Type In Compensation Hierarchy Determine Formula (Doc ID 2052632.1)

Last updated on SEPTEMBER 08, 2015

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

Client needs to Pull Different Manager Type in Compensation Hierarchy Determine Formula

Client passing two supervisor types for Group, and they need to pull the manager type 'SALARY_PLANNER' as the supervisor for compensation instead of the LINE_MANAGER.

Below is the error log.

Client needs to return ASSIGNMENT_ID and PERSON_ID for the second supervisor listed on a person's record. They are getting an array error when they run the start workforce compensation process.

CMP_CWB_PARTI_PROCESS_PKG.get_cwb_manager_and_assignment
HIERARCHY RULE ERROR: 300000001625926
Get_cwb_manager_and_assignment Errored with error message as :ORA-20001: Formula RR_TEST, line 33, array data value missing.

 

Solution

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 hundreds of Community platforms