My Oracle Support Banner

UK MDC: Teachers Pension Error ORA-1861 Occurred At Line 28 Of Formula PQP_GB_TP_MDC_UPDATE_LINES_RULE (Doc ID 2416656.1)

Last updated on FEBRUARY 16, 2019

Applies to:

Oracle HRMS (UK) - Version 12.2.4 to 12.2 [Release 12.2]
Information in this document applies to any platform.


Problem Statement:

When attempting to run Teachers Pension Monthly Extract Process,
the following error occurs.

Error Message: ORA-20001: ORA-1861 occurred at line 28 of formula PQP_GB_TP_MDC_UPDATE_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.


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

  1.  run Teachers Pension Monthly Extract Process


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.