Purge Configurator Tables Fails: ORA-20001: Table CZ_MODEL_PUBLICATIONS has no PK defined

(Doc ID 2311847.1)

Last updated on SEPTEMBER 27, 2017

Applies to:

Oracle Configurator - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3.31.10 version, SCHEMA

When attempting to run the concurrent program Purge Configurator Tables, the following error occurs and is reported to the concurrent program log file.

ERROR
-----------------------
Purge terminated due to fatal error: ORA-20001: Table CZ_MODEL_PUBLICATIONS has no PK defined..


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Configurator Administrator responsibility
2. Concurrent programs
3. Schedule Purge Configurator Tables
4. Submit
5. Process ends in error

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