My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.