My Oracle Support Banner

Balance Adjustment For FLSA Element Does not Behave the Same on API and PUI(Adjust Balance Form) (Doc ID 3062866.1)

Last updated on FEBRUARY 10, 2025

Applies to:

Oracle Payroll - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

The Adjust Balance form(PAYWSABL.fmb) and API(pay_balance_adjustment_api.create_adjustment) behaves differently.

When performing balance adjustment on FLSA element on forms without specifying Earned Start Date and Earned End Date, process completes without the error. Those 2 input values are null after the balance adjustment.
On the other hand, executing API for the same element without specifying Earned_start_date/Earned_end_date, following error occurs.

 

ORA-20001: Assignment is not valid as of Earned Start Date

 
The issue can be reproduced at will with the following steps:

  1.  Define FLSA Overtime Earnings.
     US HRMS Manager responsibility
     (N) Total Compensation > Basic > Earnings
      Check the "FLSA Overtime Earnings" box

  2.  Create an element link.
     
  3.  Hire the employee in the middle of the pay period.

  4.  Execute the API with p_effective_date = hire date (Middle of the pay period).

 

Sample API script:

 

 



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
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.