My Oracle Support Banner

Unable To Limit Compensation Cumulative Entry To X Hours A Month - Validation Fast Formula (Doc ID 2786066.1)

Last updated on JUNE 21, 2021

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version to [Release 1.0]
Information in this document applies to any platform.


Have created an individual compensation plan for Overtime, and need to restrict employees from entering more than 36 hours overtime a month.
Had created validation formula and attached it to Overtime element. On Personal contribution screen, it validates the entry correctly but it again validates after the line manager approves it.
During this stage, it doubles the value and shows error which shouldn't be the case.

In triggering validation fast formula post approval the value is doubled - considering cached values. The transaction is not completing due to above issue.

Retrieving all element entries for the month through DBI, summing OT hours of those and adding current input OT Hours to it to validate if it crosses 36 hours.
If person already has 35 hours, and he adds 1 more hour, it passes validation as expected (35 hours from DBI + 1 hr input), and goes for approval.
Once line manager approves, it seems to again trigger validation FF, and in this stage it gets 36 hours through DBI + 1 hr input.
DBI is considering the current entered 1 hour from cache even though this is not yet committed - i.e. not flowed to element entries table yet.

From the formula logic:

inputs are OT_Hours(number)
l_hrs = GET_OUTPUT('L_OT_HOURS',0)

l_tot_hrs = OT_Hours + l_hrs

l_hrs value will also contain the input value of the element being committed.




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

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