My Oracle Support Banner

ESOCIAL: Unique Constraint Error in Esocial Basic Initial. (Doc ID 2338108.1)

Last updated on FEBRUARY 06, 2019

Applies to:

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


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.

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

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.




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.