My Oracle Support Banner

UK Retro Error - Data GET_AGGREGATED_EARNINGS NOT FOUND AT LINE 69 OF PENSIONS_ASSESSMENT (Doc ID 2765327.1)

Last updated on APRIL 02, 2021

Applies to:

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

Symptoms

Problem Statement:


When attempting to run Retropay Enhanced process, for some employees having Pension Information element,
the following error occurs (error is present in the process log file):

Error was encountered when processing Element Type Pensions Information
Error was encountered when processing formula PENSIONS_ASSESSMENT
An error occurred during formula execution
Data GET_AGGREGATED_EARNINGS not found at line 69 of PENSIONS_ASSESSMENT
Cause: A SQL SELECT statement, obtained from the application dictionary, returned no rows
when executed.

 

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

1. Apply <Patch 32385818> :R12.PAY.B
2. Using UK HRMS manager Responsibility > People > Enter and Maintain
3. Select an employee having Pension Information element >  Assignment > Entries > make an update for any element on previous months
4. Navigate to Process and Report - Submit a Single Request - Run Retropay Enhanced process

Changes

 Issue is present after applying <Patch 32385818>:R12.PAY.B

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