My Oracle Support Banner

GP BRA: ORA - 00001: UNIQUE CONSTRAINT (SYSADM.PS_GPBR_SEFIP_WRK) Error in SEFIP Report BRA. (Doc ID 2817243.1)

Last updated on FEBRUARY 04, 2022

Applies to:

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

Symptoms

After applying <Bug 30079975> and <Bug 30634821>, the following issues have been found when running the SEFIP file:

1 - Where clause in PS_JOB(ADM_DT), validates the highest effective date, but does not consider the highest effective sequence.

2 - SQL query for absence rule does not consider what absences should go or not in SEFIP file.

This causes error when employee has vacations and absence credit(abono pecuniario) or if employee has more than one effective sequence in Job Data.

ERROR
-----------------------
(SQR 5528) ORACLE OCIStmtExecute error 1 in cursor 20:
ORA - 00001: unique constraint (SYSADM.PS_GPBR_SEFIP_WRK) violated
 
 Error on line 1114:
 (SQR 3735) Could not execute SQL.
 
 SQR for PeopleSoft: Program Aborting.

Steps to reproduce the issue:

  1. Navigate to Global Payroll & Absence Mgmt > Payee Data > Maintain Absences > Vacation Leave BRA and schedule a vacation with s start date on the first day of month with the vacations credit selected.
  2. Navigate to Global Payroll & Absence Mgmt > Absence and Payroll Processing > Off-Cycle > Off Cycle on Demand and calculate the vacations.
  3. Calculate the regular payroll
  4. Navigate to Global Payroll & Absence Mgmt > Social Security / Insurance > SEFIP Report BRA  and run the report.

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.