UK: Annual Service Return (ASR) Teachers Periodic Returns Errors on Address Line 2
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.
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:
- Process the ASR for employees, ensuring that at least 1 has the address format as specified.
- 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
Million Knowledge Articles and hundreds of Community platforms