My Oracle Support Banner

APP-PAY-06867 and "Payroll not found" Errors When Running QuickPay or Payroll Process (Doc ID 2625953.1)

Last updated on DECEMBER 11, 2023

Applies to:

Oracle Payroll - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:

QuickPay or Payroll Process fails with the following error.

HR_6867_HRPROC_FMLA_ORA_ERR
ORACLE_ERROR_TEXT
FORMULA_ERROR_TEXT UDF Error in formula <FORMULA_NAME> at line XXX: An error ha
s occurred in a user defined function at line XXX of the formula <FORMULA_NAME>. The error text associated with the function call is: The system cannot calcula
APP-PAY-06867: An error occurred during formula execution:

UDF Error in formula <FORMULA_NAME> at line XXX: An error has occurred in a user defined function at line XXX of the formula <FORMULA_NAME>. The error text associated with the function call is: The system cannot calcula

....

per_formula_functions.get_date 1
PAYROLL_PERIOD_START_DATE=<START DATE> per_formula_functions.get_date 5
per_formula_functions.get_date 1
PAYROLL_PERIOD_END_DATE=<END DATE> per_formula_functions.get_date 5
per_utility_functions.Get_Payroll_Period 5
Payroll Period not found per_utility_functions.Get_Payroll_Period 10     <======="Payroll Period not found" error is printed
per_formula_functions.raise_error 10
per_formula_functions.run_formula 99

 

 

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Run QuickPay or Payroll Process
  2.  Request fails with the error

 

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.