EPY: PAYGL02 Errored Due to "Cannot insert duplicate key row in object 'dbo.PS_HR_ACCTG_LINE' with unique index 'PS_HR_ACCTG_LINE" in PAY_DED_LIAB_AP (Doc ID 2917092.1)

Last updated on APRIL 15, 2024

Applies to:

Symptoms

When running the paygl02 process, it is erroring out with the following error.


Processing Paygroup H24
 
SQL-STATEMENT-ERROR
PAYGL02, Insert-Error - COPY-FROM-ACCTG-LN-STG
Bind Varables: PROGRAM NAME PAYGL02, RUN DATE 2022-12-16, PROCESS INSTANCE 774912
 Error : [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_HR_ACCTG_LINE' with unique index 'PS_HR_ACCTG_LINE'. The duplicate key value is (Dec 16 2022 12:00AM, 1, 1).

 SQL Status : 2601.000000

Error on line 10482:
  (SQR 3301) Program stopped by user request.

SQR for PeopleSoft: Program Aborting.



The issue can be reproduced with the following steps:
1. Run PAYGL02.SQR - Payroll for North America>Payroll Distribution>Provide GL Information>Commitment Accounting Actuals

Cause

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