UK: Annual Service Return (ASR) Teachers Periodic Returns Errors on Address Line 2

(Doc ID 2029460.1)

Last updated on JULY 06, 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.


Problem Statement:

When attempting to generate the Teachers Pension ASR, and the employees address is entered in line 1, line 4(town) and postcode, the ASR output is reporting an issue with the address line 2 not being present, 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.  Process the ASR for employees, ensuring that at least 1 has the address format as specified.
  2.  Review the archive output 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