My Oracle Support Banner

ETL8.x/9/x: While Running PY_PULL_COST the Program Abended With a Unique Constraint Error on PSADM.PS_WRK_XREF_CALC4 (Doc ID 784587.1)

Last updated on MARCH 19, 2021

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 8.9 to 9.2 [Release 8.9 to 9]
Information in this document applies to any platform.
***Checked for relevance on 24-Aug-2010***



Symptoms

Issue with PY_PULL_COST
While running PY_PULL_Costs the program abended with a unique constraint error on PSADM.PS_WRK_XREF_CALC4

Error message:

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1603 Error Position: 0 Return: 805 - ORA-00001: unique constraint (PSADM.PS_WRK_XREF_CALC4) violated
Failed SQL stmt:INSERT INTO PS_WRK_XREF_CALC4 (PROCESS_INSTANCE, SEQ_NBR, XREF_NUM, TL_QUANTITY1, TL_QUANTITY2, LBR_DIST_AMT, DILUTED_GROSS, DISTRIB_PCT, XREF_COST, DILUTION_TOTAL, TL_QUANTITY, TRC_TYPE, DILUTE_LBDST_FLAG, DIST_ACTION_TYPE, CURRENCY_CD, EMPLID, EMPL_RCD, DUR, WRK_PCT, TRC, ORIG_SEQ_NBR, RECORD_ONLY_ADJ, ADD_GROSS) SELECT 271239, A.SEQ_NBR, A.XREF_NUM, A.TL_QUANTITY1, A.TL_QUANTITY2, A.LBR_DIST_AMT, A.DILUTED_GROSS, A.DISTRIB_PCT, A.XREF_COST, A.DILUTION_TOTAL, A.TL_QUANTITY, A.TRC_TYPE, D.DILUTE_LBDST_FLAG, A.DIST_ACTION_TYPE, A.CURRENCY_CD, A.EMPLID, A.EMPL_RCD, A.DUR, A.WRK_PCT, A.TRC, A.ORIG_SEQ_NBR, A.RECORD_ONLY_ADJ, D.ADD_GROSS FROM PS_WRK_XREF_CAL4 A , PS_TL_TRC_TBL D WHERE A.PROCESS_INS

Process 271239 ABENDED at Step TL_DIST_DIL.MAIN.Step036F (SQL) -- RC = 805 (108,524)

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

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.