Purge Publish History Table EGOPHPRG Error "Records are not deleted due to runtime exception ORA-00933: SQL command not properly ended", Table EGO_PUB_BAT_PARAMS_B Does Not Get Purged (Doc ID 1608737.1)

Last updated on NOVEMBER 02, 2016

Applies to:

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

Symptoms

When attempting to run the 'EGO Publish History Purge Program', the following error occurs.

ERROR

What is Working

Enter Parameters:

Batch Id
Target_system_name
Published Date From
Published Date To
Status
Published By
Entity Type

The publish history tables are as below :

EGO_PUB_BAT_HDR_B
EGO_PUB_BAT_PARAMS_B
EGO_PUB_BAT_SYSTEMS_B
EGO_PUB_BAT_ENT_OBJS_B
EGO_PUB_BAT_STATUS_B

All the other publish tables are getting purged except EGO_PUB_BAT_PARAMS_B.

Changes

 

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