Quickpay Error Prompted For DBI ‘ORA_HRX_GB_PAY_PERIOD_START’ Used In Fast Formula (Doc ID 2274106.1)

Last updated on JUNE 06, 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 running payroll, the following error is received


ERROR
-----------------------
"Error prompted for DBI ‘ORA_HRX_GB_PAY_PERIOD_START’ use in fast formula

The standard derived fast formula template had used the DBI ‘ORA_HRX_GB_PAY_PERIOD_START’ for the calculation.
 
AFDICT_APP_PREFIX-PAY-1635399: An error occurred during formula execution. (ORACLE_ERROR_TEXT=) (FORMULA_ERROR_TEXT=Formula STATUTORY MATERNITY PAY SMP ENTITLEMENT RESULT, line 351, no data returned. (3=ORA_HRX_GB_PAY_PERIOD_START))
Formula STATUTORY MATERNITY PAY SMP ENTITLEMENT RESULT, line 351, no data return
ed. (3=ORA_HRX_GB_PAY_PERIOD_START)  "



STEPS
-----------------------
1. Run payroll / quickpay
2. Check the log / run results



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot process the payroll for 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