Archive Plan Summary Ended In Error - Log File shows ORA-14074

(Doc ID 1268963.1)

Last updated on JULY 11, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.2 and later
Information in this document applies to any platform.
***Checked for relevance on 30-APR-2013***

Symptoms

12.1.2 in Production and Test
with patch 12.1.2.1 applied

PROBLEM
-------------
MSCHUBA module: Archive Plan Summary
errors with

2010-11-16 07:28:38: msc_phub_pkg.build_items_from_pds: update=475
2010-11-16 07:28:38: msc_phub_pkg.build_items_from_pds: complete
2010-11-16 07:28:38: msc_phub_pkg.manage_partitions: 215002,1
2010-11-16 07:28:38: alter table MSC_SUPPLIES_F add partition SUPPLIES_F_215002 values less than (215003)
2010-11-16 07:28:38: msc_phub_pkg.manage_partitions.exception: ORA-14074: partition bound must collate higher than that of the last partition
2010-11-16 07:28:38: msc_phub_pkg.populate_details: ORA-14074: partition bound must collate higher than that of the last partition

STEPS
--------
Launch plan this morning.

EXPECTED BEHAVIOR
----------------------------
completes without error

BUSINESS IMPACT
----------------------
cannot archive plans.

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