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.


On : 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.

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

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


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