Teachers Periodic Returns 2015 Process Errors If There Is No Email Address
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.
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
Million Knowledge Articles and hundreds of Community platforms