My Oracle Support Banner

Update Employee Address Error- ORA-20001: A Payroll Exists Which Pre-Dates the Start Date for This Address. (Doc ID 1939792.1)

Last updated on SEPTEMBER 29, 2020

Applies to:

Oracle Human Resources - Version 12.1 HRMS RUP6 to 12.1 HRMS RUP7 [Release 12.1]
Information in this document applies to any platform.


An instance patched at 16000686 running Oracle Payroll for US
within People screen unable to update Employee Primary Address and receive error when Saving.

ORA-20001 A payroll exists which pre-dates the start date for this address.
If this is an update then please end date the last primary address and create a new record for the new primary address.
If this is a correction then please retain the original start date of this address.

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

1. US HRMS responsibility

2.   People >
      Enter and Maintain >
      query for Employee >
      People screen >
      click Address button >
      make change to address and Save >
      receive error

Not able to make changes to the Employee Primary Address.
This effects Tax records for the employee.




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.