My Oracle Support Banner

GP BRA: Unique Constraint Error in GPBR_EFT_AE Application Engine. (Doc ID 2694363.1)

Last updated on JULY 24, 2020

Applies to:

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

Symptoms

GPBR_EFT_AE Application Engine abended with the error below:

SQL error. Function: SQLExec
  Error Position: 0
  Return: 805 - ORA-00001: unique constraint (SYSADM.PS_GPBR_LAYSTB_WRK) violated
  Statement: INSERT INTO PS_GPBR_LAYSTB_WRK (PRCSINSTANCE, GPBR_KEY_ORDER, GPBR_ROW_SEQUENCE, GPBR_MSG_LONG) VALUES (:1, :2, :3, :4)
  Original Statement: INSERT INTO PS_GPBR_LAYSTB_WRK (PRCSINSTANCE, GPBR_KEY_ORDER, GPBR_ROW_SEQUENCE, GPBR_MSG_LONG) VALUES (:1, :2, :3, %TextIn(:4))

SQL error in Exec. (2,280) FUNCLIB_GPBR.GPBR_LAYOUT_ID.FieldFormula Name:Process_Layout_Row PCPC:38143 Statement:713
Called from:FUNCLIB_GPBR.GPBR_LAYOUT_ID.FieldFormula Name:Process_Layout Statement:772
Called from:GPBR_EFT_AE.MAIN.GBL.default.1900-01-01.Step04.OnExecute Statement:35

Process 139857 ABENDED at Step GPBR_EFT_AE.MAIN.Step04 (PeopleCode) -- RC = 8 (108,524)

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


Steps to reproduce the issue:

1. Navigate to Global Payroll & Absence Mgmt-> Payment Processing-> Create EFT Payment BRA
2. Add a new Run Control or edit one.
3. Fill the information required and run the process.


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.