ESOCIAL: Unique Constraint Error in Esocial Basic Initial.
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.
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.
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