My Oracle Support Banner

MSCCFPAR - Create APS Partition Concurrent Request Errors with ORA-14074 FOR R11 - R12 See 552415.1 (Doc ID 251233.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.5 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
MSCCFPAR - Create Plan Partition

*** Checked for relevance on 14-Mar-2012 ***


Symptoms

DO NOT USE THIS FOR R 12 ISSUES - see <Note 552415.1> Known Issues for R12

Customer encountered an error running

MSCCRPAR module: Create APS Partitions

j := 1
table := MSC_ATP_SUMMARY_SO
partition_name : ATP_SUMMARY_SO__1
l_count := 1
Partition for instance 1 already exists
table := MSC_ATP_SUMMARY_SD
partition_name : ATP_SUMMARY_SD__1
l_count := 1
Partition for instance 1 already exists
l_share_partition := N
plan count := 5
j := 1
plan_ids := 1
table := MSC_ATP_SUMMARY_SD
partition_name : ATP_SUMMARY_SD_1
In exception of CREATE_PARTITIONS
sqlerrm := ORA-14074: partition bound must collate higher than that of the last
partition

Verified the table setups for partitioned tables using the following SQL

 

 

 

Found that the error reported in the log file matches with customer table which had 5 lines
Customer had 4 active plans and only 4 plan partitions when ALL_TAB_PARTITIONS info was reviewed.

BUT
found  a line with plan_id =1, partition_number = 1 in the table.
This did not exist in the tables created in all_tab_partitions.

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.