MSC_PHUB_PKG.MANAGE_PARTITIONS.EXCEPTION: ORA-20001: Cannot PATCH Table From Run Edition (Doc ID 2053531.1)

Last updated on NOVEMBER 30, 2016

Applies to:

Oracle Advanced Planning Command Center - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On a 12.2.3 PRODUCTION Instance, in Advanced Planning Command Center (APCC)

During the process of applying patches to ASCP (the final step "Cut-Over" is not complete to promote the patch edition to the run edition):

All other programs complete successfully except Archive Plan Summary and Purge Plan Summary.  They complete with the following errors:

ERROR
-----------------------
Archive Plan Summary:

2015-08-02 12:05:00: alter table MSC_ST_DEMANDS_F drop partition ST_DEMANDS_F_4642
2015-08-02 12:05:00: msc_phub_pkg.manage_partitions.exception: ORA-20001: Cannot PATCH table from Run Edition while Patch Edition exists
2015-08-02 12:05:00: msc_phub_pkg.finalize_plan_run.exception: ORA-20001: Cannot PATCH table from Run Edition while Patch Edition exists
2015-08-02 12:05:00: msc_phub_pkg.populate_details_fn: ORA-20001: Cannot PATCH table from Run Edition while Patch Edition exists


Purge Plan Summary:

2015-08-03 10:13:16: alter table MSC_DEMANTRA_F drop partition DEMANTRA_F_214018
2015-08-03 10:13:16: msc_phub_pkg.manage_partitions.exception: ORA-20001: Cannot PATCH table from Run Edition while Patch Edition exists
2015-08-03 10:13:16: An error occured while purging fact tables, please consider rerunning the concurrent program


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run ASCP Plan before cutover phase of online patching is complete
2. Note the errors above

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