My Oracle Support Banner

GP BRA: ORA-00001: unique constraint (SYSADM.PS_EMPL_REG_T7_BRA) violated Error in Employee Registry Rpt BRA. (Doc ID 2660744.1)

Last updated on APRIL 21, 2020

Applies to:

PeopleSoft Enterprise HCM Global Payroll Brazil - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Running Employee Registry Rpt BRA (Workforce Monitoring-> Meet Regulatory Rqmts BRA) for one employee and had the following error:

ERROR
-----------------------
Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_EMPL_REG_T7_BRA) violated
Failed SQL stmt: INSERT INTO PS_EMPL_REG_T7_BRA (OPRID ,RUN_CNTL_ID ,EMPLID ,ACCOMPLISHMENT ,LICENSE_NBR ,COUNTRY ,STATE ,DESCR) SELECT 'xxxxx' ,'105811' ,A.EMPLID ,A.ACCOMPLISHMENT ,A.LICENSE_NBR ,A.COUNTRY ,A.STATE ,' ' FROM PS_ACCOMPLISHMENTS A , PS_EMPL_REG_T2_BRA B WHERE B.OPRID = 'xxxxx' AND B.RUN_CNTL_ID = '105811' AND A.EMPLID = B.EMPLID AND A.DT_ISSUED = ( SELECT MIN(A1.DT_ISSUED) FROM PS_ACCOMPLISHMENTS A1 WHERE A.EMPLID = A1.EMPLID AND A.ACCOMPLISHMENT = A1.ACCOMPLISHMENT)


Cause

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
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.