Payroll For NA Calc Error During FLSA Bonus Payment
Last updated on JUNE 13, 2018
Applies to:PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 and later
Information in this document applies to any platform.
On : 9.2 version, Core Processes
Payroll for NA Calc Error during FLSA bonus payment
While running pay calc for a quarterly VC bonus payment we hit a unique constraint error inserting into PAY_OTH_EARNS due to a bug in the PSPMFLSA COBOL and associated stored statement PSPMFLSA_S_ADDLOTH. That statement is missing WHERE clause criteria to ensure it is only selecting data for the current employee being processed. As a result that SQL returned an ADDL_NBR value from another employee's pay line which resulted in the program trying to insert using keys that were already present on PAY_OTH_EARNS. Because the stored statement SQL does not include EMPLID and has an OR for PAYGROUP criteria it can pick up another paygroup in the same company which also has the same page/line number but that pay line belongs to another employee.
Return Code: 00805, ORA-00001
Application Program Failed
In Pgm Section : INSERT-PAY-OTH-EARNS-REV(INSERT)
With Return Code: 00805
Error Message : ORA-00001: unique constraint (SYSADM.PS_PAY_OTH_EARNS) violated
The issue can be reproduced at will with the following steps:
1. Create Paysheets
2. Run Paycalc process
The issue has the following business impact:
Due to this issue, users cannot complete Payroll and pay their employees correctly.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms