My Oracle Support Banner

EPY: Actuals Distribution (PSPPFUND) errors with Load-xxxxx (Max-Array) , (Rcd Max-Array) or (Job Array) (Doc ID 1069141.1)

Last updated on APRIL 11, 2024

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 8 SP1 to 9 [Release 8 to 9]
PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Purpose

When attempting to run actuals distribution (PSPPFUND) one of the following errors occurs.

ERROR 1:
Application Program Failed
In Pgm Section: LOAD-BENEFIT-RCD (MAY-ARRAY)
With Return Code: 00000
Error Message:  ORA-00001: unique constraint (SYSADM.PS_PAY_DED_DIST) violated.


ERROR 2:
Application Program Failed
In Pgm Section : LOAD-BENEFIT-RCD(RCD MAX-ARRAY)
With Return Code: 00000
Error Message : No error recognized

OR:

Application Program Failed
 In Pgm Section  : LOAD-BENEFIT-RCD(RCD MAX-ARRAY)                     
 With Return Code: 00000 
 Error Message   : ORA-00942: table or view does not exist

ERROR 3:
Application program failed
In Pgm Section: LOAD-JOB-DATA (JOB ARRAY)
Error Message: ORA-00001: unique constraint (SYSADM.PS_PAY_DED_DIST) violated 

 

Troubleshooting Steps

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
Purpose
Troubleshooting Steps


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