My Oracle Support Banner

GP-BRA: SQL Errors on Employee Registry Report BRA For Employees with Multiple Salaries (Doc ID 1589029.1)

Last updated on MAY 11, 2018

Applies to:

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

Symptoms

Employee Registry Report BRA has the following issues:

Issue 1:Error in FRE when employee has more than one Rate Code;

ERROR
-----
File: e:\pt85209c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1620 Error Position: 0 Return: 805 - ORA-00001: unique constraint (EMDBO.PS_EMPL_REG_T8_BRA) violated
Failed SQL stmt:INSERT INTO PS_EMPL_REG_T8_BRA (OPRID ,RUN_CNTL_ID ,EMPLID ,EMPL_RCD ,EFFDT ,EFFSEQ ,ACTION ,ACTION_REASON ,COMPRATE ,DESCR ,COMP_RATECD ,DESCR1) VALUES ('PS' ,'CAR' ,'KR000000003' ,0 ,TO_DATE('2008-01-15','YYYY-MM-DD') ,0 ,'HIR' ,'NPS' ,500 ,' ' ,'KRS' ,' ')

Process 1736 ABENDED at Step HR_EMRGBR_AE.UPDEMPL8.Step02 (SQL) -- RC = 805 (108,524)


Issue 2: Error in FRE when employee has an absence with more than 01 effective date in Absence Take Set up

ERROR
----
File: e:\pt85209c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1620 Error Position: 0 Return: 805 - ORA-00001: unique constraint (EMDBO.PS_EMPL_REG_TC_BRA) violated
Failed SQL stmt:INSERT INTO PS_EMPL_REG_TC_BRA (OPRID , RUN_CNTL_ID , EMPLID , EMPL_RCD , PIN_TAKE_NUM , BGN_DT , END_DT , EVT_CONFIG1 , ABS_TYPE_OPTN , DESCR) VALUES('PS' ,'CAR' ,'KR000000002' ,0 ,70245 ,TO_DATE('2009-03-20','YYYY-MM-DD') ,TO_DATE('2009-03-23','YYYY-MM-DD') ,'2000001' , ' ' , ' ')

Process 1745 ABENDED at Step HR_EMRGBR_AE.UPDEMPLC.Step01 (SQL) -- RC = 805 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 12.00.27 2012-09-05

 

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
References


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