My Oracle Support Banner

Payroll Connector:ORA-20001: This date already exists while loading salary (Doc ID 2536747.1)

Last updated on AUGUST 27, 2019

Applies to:

Oracle Human Resources - Version 12.2 HRMS RUP8 and later
Information in this document applies to any platform.


While trying to integrate employee having salary basis changed from weekly to monthly, following error is seen in payroll integration per_bi_errors table

Error - ORA-20001: This date already exists. Please enter a new date.

The issue can be reproduced at will with the following steps:
1. Created employee with weekly salary basis> successfully integrated in Fusion
2.Changed the Salary basis from weekly to monthly>New created salary did not integrate> Error is seen


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.