Balance Initialization is Wrong for Some Periods When Payroll Has Positive Offset

(Doc ID 1983558.1)

Last updated on OCTOBER 03, 2016

Applies to:

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


User is unable to initialise some Period To Date (PTD) and Year To Date (YTD) balances correctly


1. Define Payroll and payroll calendar with +6 days payment date offset


Period Start date = 23-MAR-2014, Period End Date = 19-APR-2014
Regular Payment Date= 25-APR-2014
Period Name= 4 2014 Lunar Month

2. Populate tables pay_balance_batch_headers and pay_balance_batch_lines to load the initial balances

using upload dates of


but none of the upload dates are initialsing the balance correctly



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