Retropay (Enhanced) Errors: 'The value returned from formula [FORMULA NAME] for [VARIABLE] is NULL.'
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.
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.
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.
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
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