Retropay (Enhanced) Errors: 'The value returned from formula [FORMULA NAME] for [VARIABLE] is NULL.'

(Doc ID 2368097.1)

Last updated on MAY 18, 2018

Applies to:

Oracle Payroll - Version 12.1 to 12.1 HRMS RUP10 [Release 12.0 to 12.1]
Oracle HRMS (UK) - Version 12.1 to 12.1 HRMS RUP10 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

Following the application of HRMS 12.X RUP10, RetroPay (Enhanced) is raising errors when formula with PQP_DERIVE_APP seeded function is called in the fast formula.

ERROR
-----------------------
APP-PAY-51119: Error was encountered when processing Element Type [ELEMENT NAME]
APP-PAY-51120: Error was encountered when processing formula [FORMULA NAME]
An error occurred during formula execution:
The value returned from formula [FORMULA NAME] for [VARIABLE] is NULL.
Cause: The value was set from a function call that returns NULL.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create open-ended absence for employee
2. Process payroll
3. Close absence
4. Process payroll
5. Amend assignment retrospectively
6. Run Retro-Notifications Report (Enhanced) - PDF
7. Run Retropay Enhanced
8. Issue replicated, RetroPay errors on assignment



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