Teachers Pensions Monthly Data Collection Error ORA-20001 and Unexpected Behavior (Doc ID 2195888.1)

Last updated on OCTOBER 23, 2016

Applies to:

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

Symptoms

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

Error

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

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