My Oracle Support Banner

Recalculate Payroll For Retroactive Changes Completes In Error: AFDICT_APP_PREFIX-PAY-1635399: An error occurred during formula execution... no data returned. (3=HWP_PER_AGE_IN_YEARS) (Doc ID 2577040.1)

Last updated on AUGUST 28, 2019

Applies to:

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

Symptoms

On : 11.13.19.01.0 version, Global Payroll

When attempting to Recalculate Payroll for Retroactive Changes,
the following error occurs:

ERROR
-----------------------
HR_51119_HRPROC_ERR_OCC_ON_ET
ETNAME Casual Work Result
AFDICT_APP_PREFIX-PAY-1635252: An error occurred when processing element {ELEM_NAME. (ETNAME=Casual Work Result)
  In { pyxipmt
message text = An error occurred when processing element {ELEM_NAME. (ETNAME=Casual Work Result)
message level = F,F

HR_51120_HRPROC_ERR_OCC_ON_FML
FMLANAME XXDFL_CASUAL_WORK
AFDICT_APP_PREFIX-PAY-1635031: An error occurred when processing formula XXDFL_CASUAL_WORK.
  In { pyxipmt
message text = An error occurred when processing formula XXDFL_CASUAL_WORK.
message level = F,F

HR_6867_HRPROC_FMLA_ORA_ERR
ORACLE_ERROR_TEXT
FORMULA_ERROR_TEXT Formula XXSIM_PAY_HR_DETAILS, line 54, no data returned. (3=H
WP_PER_AGE_IN_YEARS)
AFDICT_APP_PREFIX-PAY-1635399: An error occurred during formula execution. (ORACLE_ERROR_TEXT=) (FORMULA_ERROR_TEXT=Formula XXSIM_PAY_HR_DETAILS, line 54, no data returned. (3=HWP_PER_AGE_IN_YEARS))
  In { pyxipmt
message text = An error occurred during formula execution. (ORACLE_ERROR_TEXT=)
(FORMULA_ERROR_TEXT=Formula XXSIM_PAY_HR_DETAILS, line 54, no data returned. (3=
HWP_PER_AGE_IN_YEARS))
message level = F,F
line_text = 167, An error occurred during formula execution. (ORACLE_ERROR_TEXT=) (FORMULA_ERROR_TEXT=Formula XXSIM_PAY_HR_DETAILS, line 54, no data returned. (3=HWP_PER_AGE_IN_YEARS))

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Recalculate Payroll for Retroactive Changes process;
2. stuck error occurs.

Observation:
The fast formula were recompiled but the error still happens

User provided details:
"We have a number of employees who are in error on the Recalculate Payroll for Retroactive Changes process.
Please see attached GMFZT log file for one employee.
I have recompiled the fast formula but the employee still errors.
I have been unable to replicate the issue in ...... environment which refreshed with a P2T .....
The 19B patch is due to be applied ......."

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot successfully complete the Recalculate Payroll Process for Retroactive Changes.

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


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