R12 Payroll Error When Processing 2 DEA Orders For Employee - " Formula DIRECT EARNINGS ATTACHMENT INVDED_INIT, line 14, array data value missing." (Doc ID 2269097.1)

Last updated on MAY 23, 2017

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.12.1.0.0 version, UK - United Kingdom Legislation

When attempting to run Payroll for an employee with 2 current Direct Earnings Attachment court orders, the following error occurs.
Have checked the employee's court order calculation card and the data seems ok so, don't understand why the payroll is erroring. Note that a similar scenario is working in another environment.

ERROR
-----------------------
"HR_51118_HRPROC_ERR_OCC_ON_ASG
ASGNO 580525
AFDICT_APP_PREFIX-PAY-1635156: Error was encountered when processing payroll relationship XXXXXX.
  In { pyxipmt
message text = Error was encountered when processing payroll relationship XXXXXX
.
message level = F,F
payroll_id text = 300000ZZZZZ
source_id text = TTTTTTTT
line_text = 66, Error was encountered when processing payroll relationship XXXXXX
5.
  Out } pyxipmt
  In { pylogpop
  Out } pylogpop
HR_51119_HRPROC_ERR_OCC_ON_ET
ETNAME Direct Earnings Attachment
AFDICT_APP_PREFIX-PAY-1635252: An error occurred when processing element {ELEM_NAME. (ETNAME=Direct Earnings Attachment)
  In { pyxipmt
message text = An error occurred when processing element {ELEM_NAME. (ETNAME=Dir
ect Earnings Attachment)
message level = F,F
payroll_id text = 300000043951427
source_id text = 254707525
line_text = 89, An error occurred when processing element {ELEM_NAME. (ETNAME=Di
rect Earnings Attachment)
  Out } pyxipmt
  In { pylogpop
  Out } pylogpop
HR_51120_HRPROC_ERR_OCC_ON_FML
FMLANAME DIRECT EARNINGS ATTACHMENT INVDED_INIT
AFDICT_APP_PREFIX-PAY-1635031: An error occurred when processing formula DIRECT EARNINGS ATTACHMENT INVDED_INIT.
  In { pyxipmt
message text = An error occurred when processing formula DIRECT EARNINGS ATTACHM
ENT INVDED_INIT.
 
line_text = 81, An error occurred when processing formula DIRECT EARNINGS ATTACH
MENT INVDED_INIT.
  Out } pyxipmt
  In { pylogpop
  Out } pylogpop
HR_6867_HRPROC_FMLA_ORA_ERR
ORACLE_ERROR_TEXT
FORMULA_ERROR_TEXT Formula DIRECT EARNINGS ATTACHMENT INVDED_INIT, line 14, arra
y data value missing. (3=A_SORT_PRIORITY) (4=10559758)
AFDICT_APP_PREFIX-PAY-1635399: An error occurred during formula execution. (ORACLE_ERROR_TEXT=) (FORMULA_ERROR_TEXT=Formula DIRECT EARNINGS ATTACHMENT INVDED_INIT, line 14, array data value missing. (3=A_SORT_PRIORITY) (4=10559758))
  In { pyxipmt
message text = An error occurred during formula execution. (ORACLE_ERROR_TEXT=)
(FORMULA_ERROR_TEXT=Formula DIRECT EARNINGS ATTACHMENT INVDED_INIT, line 14, arr
ay data value missing. (3=A_SORT_PRIORITY) (4=10559758))
 
line_text = 201, An error occurred during formula execution. (ORACLE_ERROR_TEXT=
) (FORMULA_ERROR_TEXT=Formula DIRECT EARNINGS ATTACHMENT INVDED_INIT, line 14, a
rray data value missing. (3=A_SORT_PRIORITY) (4=10559758))
  Out } pyxipmt
  In { pylogpop
  Out } pylogpop"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Payroll
2. Check results

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot pay the employee

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms