APS Partition ORA-14074: partition bound must collate higher than that of the last partition (Doc ID 2000336.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

VCP 12.1.3.9.1 ~ On a fresh installation for ASCP "create APS Partition" requested ends in error

PROBLEM STATEMENT
=================
Originally the customer had ..a fresh installation for ASCP and after having data collection being
submitted, ran "create APS Partition".  The request ended with error " ORA-02149: Specified partition does not exist".

-- while defining the plan option: after trying to save, they're getting message  "There is an error while getting plan id. No Free Partitions available"

-200 tables affected with: partition_name : ATP_PEGGING_2024 ; In exception of CREATE_PARTITIONS sqlerrm := ORA-14074: partition bound must collate higher than that of the last partition

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