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

Last updated on DECEMBER 15, 2016

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

 

SELECT
  table_name,
  partition_name,
  num_rows,
  high_value,
  sample_size,
  last_analyzed,
  global_stats
FROM
  all_tab_partitions
WHERE
  table_name like 'MSC%'  
  order by  substr(partition_name,instr(partition_name,'_',-1,1)+1)

 

 

Checked MSC_PLAN_PARTITIONS and MSC_INST_PARTITIONS tables for Plan and Instance partitions.

 

-- Checking Plan Partitions
select      plan_id,
            plan_name,
            free_flag,
            partition_number
from        msc_plan_partitions

-- Checking Instance Partitions
select      instance_id,
            free_flag,
            creation_date,
            last_update_date           
from        msc_inst_partitions;

 

 

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.

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