My Oracle Support Banner

Error Message Prompt On Payroll Run: AFDICT_APP_PREFIX-PAY-1635031: An error occurred when processing formula STATUTORY SHARED PARENTAL ADOPTION ENTITLEMENT RESULT (Doc ID 2477896.1)

Last updated on APRIL 13, 2019

Applies to:

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

Symptoms

On : 11.13.18.05.0 version, Global Payroll

When attempting to run Run payroll for Jan 2018 until Jan 2019 / Statutory Shared Parental Adoption Entitlement Result,
the following error occurs:

ERROR
-----------------------
Oracle Human Resources Generic Process
Started at : 03-09-2018 13:03:09

statistics group id 39115
HR_51118_HRPROC_ERR_OCC_ON_ASG
ASGNO MOJ046797
AFDICT_APP_PREFIX-PAY-1635156: Error was encountered when processing payroll relationship X.
HR_51119_HRPROC_ERR_OCC_ON_ET
ETNAME Statutory Shared Parental Adoption Entitlement Result
AFDICT_APP_PREFIX-PAY-1635252: An error occurred when processing element {ELEM_NAME. (ETNAME=Statutory Shared Parental Adoption Entitlement Result)
HR_51120_HRPROC_ERR_OCC_ON_FML
FMLANAME STATUTORY SHARED PARENTAL ADOPTION ENTITLEMENT RESULT
AFDICT_APP_PREFIX-PAY-1635031: An error occurred when processing formula STATUTORY SHARED PARENTAL ADOPTION ENTITLEMENT RESULT.
HR_6867_HRPROC_FMLA_ORA_ERR
ORACLE_ERROR_TEXT
FORMULA_ERROR_TEXT Formula GFSL_ORA_HRX_GB_ABSENCE_PAYMENT, line 182, no data returned. (3=ORA_HRX_GB_ABS_DDF_SHPLA_AWE)
AFDICT_APP_PREFIX-PAY-1635399: An error occurred during formula execution. (ORACLE_ERROR_TEXT=) (FORMULA_ERROR_TEXT=Formula GFSL_ORA_HRX_GB_ABSENCE_PAYMENT, line 182, no data returned. (3=ORA_HRX_GB_ABS_DDF_SHPLA_AWE))
Formula GFSL_ORA_HRX_GB_ABSENCE_PAYMENT, line 182, no data returned. (3=ORA_HRX_GB_ABS_DDF_SHPLA_AWE)

Ended processing at : 03-09-2018 13:03:16
Total Pay Relship count : 1
Total Action count : 1
Successfully processed : 0
Skipped : 0
Unprocessed : 0
Errored : 1
===============================================================================
-------------------------------------------------------------------------
PL/SQL Output
-------------------------------------------------------------------------
+---------------------------------------------------------------------------+
UTIL-CURRENT TIME (DATE=03-SEP-2018) (TIME=13:03:16)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run Run payroll for Jan 2018 until Jan 2019 / Statutory Shared Parental Adoption Entitlement Result;
2. stuck error occurs.

Details

A. @User initial situation:
As per Shared_Parental_Leave_Adoption_absence_type_setup
Type Attributes
General Attributes
Name: Shared Parental Leave Adoption Validation Formula: ORA_HRX_GB_SHPL_ABS_VALIDATION
Legislative Data Group: Gov Facility Services Limited Legislative Grouping Code: --- left blank ----

B. @Support Action Plan:
As per document Setting Up and Migrating UK Statutory Absences (Doc ID 2235239.1) > R12_HRX_UK_Absences-Setup.pdf
On Shared Parental Pay and Leave (ShPL) / Setting Up Plan and Type Attributes for ShPL
Legislative grouping code on the plan = UK Statutory Shared Parental Plan
Legislative grouping code on the absence type = UK Shared Parental Leave Birth

Upon checking, the same erred outcome was confirmed by user.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
They are on test instance and Payroll is not yet live, will go live for Payroll in October, but this will affect the Payroll testing which needs to be completed by tomorrow to allow them to complete user testing.

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
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.