Teachers Pensions Monthly Data Collection Error ORA-20001 and Unexpected Behavior

(Doc ID 2195888.1)

Last updated on MAY 01, 2018

Applies to:

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


Problem Description
Teachers Pension Monthly Extract Process completes with error and/or unexpected behavior:


ORA-20001: Data PQP_GB_TP_MDC_CRITERIA not found at line 28 of PQP_GB_TP_MDC_CRITERIA_RULE

Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Login using UK HRMS
2. (N)-> Process and Reports -> Submit new process -> Teachers Pension Monthly Extract Process
3. Review log file


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