My Oracle Support Banner

GPAUS: STP Prep Process Running to Error Unique Constraint (SYSADM.PS_GP_RPTW_TMP4) Violated Failed SQL Stmt: Insert into PS_GP_RPTW_TMP4(PROCESS_INSTANCE, EMPLID, (Doc ID 2819991.1)

Last updated on NOVEMBER 07, 2021

Applies to:

PeopleSoft Enterprise HCM Global Payroll Australia - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

STP prep process running to Unique Constraint error when a payee recieve Termination payments with a EOY VR CATEGORY of LA (Lump A) & Laundry Allowance which has a STP VR CATEGORY of LA (Laundry) in same period


The issue can be reproduced at will with the following steps:
1. Terminate payee
2. Make sure the LUMP A and Laundry Allowance are processed for payee
3. Run STP Prep Process, observe that the process fails with the above error

Changes

 

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
Changes
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.