My Oracle Support Banner

GPAUS: STP - Create Payment Summary Data AUS - Unique Constraint Error (Doc ID 2474291.1)

Last updated on DECEMBER 25, 2019

Applies to:

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

Goal

On: 9.2 PeopleSoft Enterprise HCM Global Payroll Australia, Legislative

STP - Create Payment Summary Data AUS - unique constraint error
The Create Payment Summary Data AUS process failed with a unique constraint error when using the new input option for Include Unfinalized Calendars.


Error Position: 29  Return: 1407 - ORA-01407: cannot update ("SYSADM"."PS_GPAU_PSMR_TAO4"."USER_KEY2") to NULL
Failed SQL stmt: UPDATE PS_GPAU_PSMR_TAO4 SET USER_KEY2 = ( SELECT MAX(BALANCE_GRP_NUM) FROM PS_GPAU_EE_TAX_DTL T , PS_GP_PYE_PRC_STAT P WHERE T.EMPLID=PS_GPAU_PSMR_TAO4.EMPLID AND P.EMPLID=T.EMPLID AND P.CAL_RUN_ID=PS_GPAU_PSMR_TAO4.CAL_RUN_ID AND P.GP_PAYGROUP=PS_GPAU_PSMR_TAO4.GP_PAYGROUP AND P.CAL_ID=PS_GPAU_PSMR_TAO4.CAL_ID AND P.ORIG_CAL_RUN_ID=PS_GPAU_PSMR_TAO4.ORIG_CAL_RUN_ID AND T.PAY_ENTITY=PS_GPAU_PSMR_TAO4.USER_KEY1 AND T.EFFDT <= P.PRD_END_DT ) WHERE PROCESS_INSTANCE = 814556 AND PIN_NUM= ( SELECT PIN_NUM FROM PS_GP_PIN WHERE PIN_CODE='AUS TAX AUS') AND EXISTS( SELECT MAX(BALANCE_GRP_NUM) FROM PS_GPAU_EE_TAX_DTL T , PS_GP_PYE_PRC_STAT P WHERE T.EMPLID=PS_GPAU_PSMR_TAO4.EMPLID AND P.EMPLID=T.EMPLID AND P.CAL_RUN_ID=PS_GPAU_PSMR_TAO4.CAL_RUN_ID AND P.GP_PAYGROUP=PS_GPAU_PSMR_TAO4.GP_PAYGROUP AND P.CAL_ID=PS_GPAU_PSMR_TAO4.CAL_ID AND P.ORIG_CAL_RUN_ID=PS_GPAU_PSMR_TAO4.ORIG_CAL_RUN_ID AND T.PAY_ENTITY=PS_GPAU_PSMR_TAO4.USER_KEY1 AND T.EFFDT <= P.PRD_END_DT )

Process 814556 ABENDED at Step GPAU_PSM_CRE.A2_Data.Upd_key2 (SQL) -- RC = 1407 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
PSAESRV completed service request at 15.02.35 2018-11-16

 

Solution

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
Goal
Solution


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