Payroll and OTL - EBS (MOSC)

MOSC Banner

Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!

Rounding Final Payments

edited Apr 9, 2020 7:15AM in Payroll and OTL - EBS (MOSC) 1 commentAnswered

Hi,

We have an overpayment plan pay element which is working ok except the last payment doesn’t seem to be recovering to 1p or 2p roundings. We are aiming that the final payment recovers the remaining rounding pence.

Any input is highly appreciated. Thank You

Formula:

Inputs are Amount_of_Overpayment,Periods_to_Deduct,Amount_Outstanding

If Emp_Term_Date >= Pay_Proc_Period_Start_Date

and

Emp_Term_Date <= Pay_Proc_Period_End_Date

Then

(Earnings = Amount_Outstanding *(-1)

     Return Earnings)

Else

Earnings = Roundup(((Amount_of_Overpayment / Periods_to_Deduct)*(-1)),2)

If Emp_Term_Date < Pay_Proc_Period_Start_Date

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center