My Oracle Support Banner

Rate Definition - Element Input Validation formula not working (Doc ID 2358282.1)

Last updated on FEBRUARY 07, 2018

Applies to:

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

Symptoms

PROBLEM STATEMENT
=================
Added Input validation Formula in Manage Rate Definition Screen, When attempting to add new salary we are not getting warning message even though when we hardcoded the values for the FF.

STEPS TO REPRODUCE
==================
A. Create the following Standard Earnings Element
Monthly Salary Rate-US -> Amount
Employee Base Salary US with Override option -> Factor
Employee Sales commission for US with override -> Factor

B. Create Element Input Validation FF
formula_message = 'Value Exceeds'
formula_status = 'E'
return formula_message, formula_status

C. Create Manage Rate Definitions
1)
Name: Monthly Salary Rate-US
Category : Element
Effective Start Date : 1-Jan-2000
Legislative Data Group HCm11 LDG
Storage Type : Amount
Element Name :Monthly Salary Rate-US
Return FTE Rate is checked

2) Name: Employee Sales commission for US with override
Category : Element
Effective Start Date : 1-Jan-2000
Legislative Data Group HCM11 LDG
Storage Type : Factor
Element Name : Employee Sales commission for US with override
Override and Defaulting Rules Tab
Check Override Allowed
Validation Formula : Element Input Validation
Rate Contributor
Contributor Type : Rate Definition
Contributor Name: Monthly Salary Rate-US
Periodicity : Calendar Month
Add or Subtract :Add

3) Name: Employee Base Salary US with Override option
Category : Element
Effective Start Date : 1-Jan-2000
Legislative Data Group HCM11 LDG
Storage Type : Factor
Element Name : Employee Base Salary US with Override option
Rate Contributor
Contributor Type : Rate Definition
Contributor Name: Monthly Salary Rate-US
Periodicity : Calendar Month
Add or Subtract :Add

D. Create Salary Basis:
Name : Annual salary Basis for US with override option
Salary Basis Properties:
Salary Basis Type : Salary amount is determined by rates
Frequency : Annually
Annualization Factor 1.00
Rates
Monthly Salary Rate-US
Employee Base Salary US with Override option
Employee Sales commission for US with override

E. Enter Salary for Employee Emp_CMP03a
Monthly Salary Rate-US : 100000
Employee Base Salary US with Override option: 5
Employee Sales commission for US with override : 6
Continue and submit

Element Input validation FF is not triggering

EXPECTED BEHAVIOR
=================
Business requirement: Individual rate factor should not go above 100 % and combination of Rate factor should not go above 100 %

Changes

 

Cause

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

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


In this Document
Symptoms
Changes
Cause
Solution
References


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