ESOCIAL: Unique Constraint Error in Esocial Basic Initial.

(Doc ID 2338108.1)

Last updated on MAY 11, 2018

Applies to:

PeopleSoft Enterprise HCM Global Payroll Brazil - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ESOCIAL - Error in the Initial Load for events S-1000 e S-1020.
The issue occurs when Establishment has change in the city code and has more than one effective date.

ERROR
----
1 - Event S-1000
Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_GPBR_M_HQ_TMP4) violated

2 - Event S-1020
Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_GPBR_STG_LCTN) violated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Set Up HRMS-> Product Related-> Workforce Administration-> Establishment BRA and add more than one effective date with different City Codes.
2. Navigate to Global Payroll & Absence Mgmt-> Reports-> eSocial-> eSocial Basic Initial and select S-1000 and after S-1020
3. Review the Logs.


Changes

 

Cause

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