Teachers Pension Extract Ends With Errors - ORA-6511 Occurred At Line 23 Of Formula PQP_GB_TP_DETAIL_TYPE1_DAYS_EXCLUDED_RULE (Doc ID 2021445.1)

Last updated on JULY 15, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Teacher Pension Interface

When attempting to generate the teachers pension ASR extract, the following error occurs.

ERROR
-----------------------
  AA000000A Name ORA-20001: ORA-6511 occurred at line 23
  of formula
  PQP_GB_TP_DETAIL_TYPE1_CREATE_SERVICE_LINES_RULE

  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.

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-6510 occurred at line 23
  of formula
  PQP_GB_TP_CRITERIA_ANNUAL_TYPE1_RULE

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

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. From UK HRMS Manager responsibility
2. Submit the concurrent request: Teachers Pension Extract with the following options:

Extract name:: PQP GB Type 1 - Teachers Annual Returns (Engl
effective date: 31/3/2015
LEA: Yes
Non LEA Organisation: blank
LEA Number: 929

3. On completion, review the log file.


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