Salmaint Batch Does Not Rebuild Sub Partitions for WEEK_DATA And MONTH_DATA (Doc ID 1924226.1)

Last updated on SEPTEMBER 20, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.1 to 13.1.8 [Release 13.1]
Information in this document applies to any platform.

Symptoms

salmaint batch calls rebbuild_unusable instead of rebuild_unusable_sub for WEEK_DATA and MONTH_DATA table.

Even though the partitioning spreadsheet provided by Oracle (the file RMS_partition_definition.xls) calls for subpartitioning week_data and month_data, the salmaint program calls the rebuild_unusable Pro*C library routine instead of rebuild_unusable_sub.  When salmaint runs, indexes PK_WEEK_DATA, WEEK_DATA_I1, PK_MONTH_DATA and MONTH_DATA_I1 are all left in unusable condition.



Steps to Reproduce:
1. Sub-partition WEEK_DATA and MONTH_DATA per partitioning spreadsheet.  
2. Run salmaint for a period that require it to drop/add partitions.  
Indexes will be left in UNUSABLE state because rebuild_unusable does not rebuild them, only rebuild_unusable_sub can do this and it is not what is being called for these two tables in salmaint.

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