RTI Year to Date Reconciliation Report Errors After Application of Patch 23060964 (Doc ID 2169856.1)

Last updated on AUGUST 08, 2016

Applies to:

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

Symptoms

Problem Statement:

RTI Year to Date Reconciliation Report ends in error  after the application of the following patches :
23060964: RTI - REAL TIME INFORMATION CHANGES : CONSOLIDATED PATCH : MAY 2016 and Patch 23098300:R12.PAY.B Released for Pensions Automatic Enrolment/Re-Enrolment Changes

The error message is as follows :

ORA-20001: An error encountered was - ORA-01403: no data found
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3
has occurred in table pay_archive.process_employee at location 1108

Steps to Reproduce

1. Login into the application with UK Super HRMS Manager Responsibility
2. Run RTI Year to Date Reconciliation Report
3. Notice that for the employees with no payments you receive the above error


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