My Oracle Support Banner

ABMGT: GP_PAYAFTER App Engine Fails With Unique Constraint Error When Absence Analytics is Turned On (Doc ID 3058389.1)

Last updated on NOVEMBER 08, 2024

Applies to:

PeopleSoft Enterprise HCM Absence Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When Absence Analytics is invoked, GP_PAYAFTER application engine fails with unique constraint error. 

Process 2641048 ABENDED at Step GP_RPT_DATA.EXECUTE.Step10 (SQL) -- RC = 805 
(198, 524)

Steps to reproduce:

After defining the Analytics Dashboards and Loading Absence Analytic data (see PeopleBooks Section on Analytics, Defining the Absence Analytics Dashboard Content and Layout)

  1. Global Payroll and Absence Management>Absence and Payroll Processing>Calculate Absence and Payroll.
  2. Enter run control details and run.
  3. GP_PAYBEFORE, GPPDPRUN run to success, GP_PAYAFTER runs to no success.
  4. Log file displays error above.

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.