Teachers Periodic Returns 2015 Process Errors If There Is No Email Address

(Doc ID 2031114.1)

Last updated on JULY 13, 2016

Applies to:

Oracle HRMS (UK) - Version 12.1.3 and later
Information in this document applies to any platform.


Problem Statement:

When attempting to generate the teachers pension ASR extract (PQP GB TP Type 1 - Teachers Periodic Returns 2015( England and Wales ) ), the following error occurs:


ORA-01086: savepoint 'CUR_TRANSACTION' never established in this session or is invalid
ORA-06512: at "APPS.BEN_EXT_PERSON", line 4650
ORA-20001: ORA-6503 occurred at line 22 of formula PQP_GB_TP4_TEACHERS_APPOINTMENTS

Cause: Whilst executing PL/SQL, an Oracle error occurred. The line number and line position, are given where available

Action: Please refer to your system administrator.



Steps to Reproduce:

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

1. Apply patch 21032266
2. Find a terminated employee, and ensure that they don't have an email address present
3. Process the extract
4. Review the archive results.


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