Indexes Not Sustained After Following Document 340118.1 (MSC_DEMANDS_N9, MSC_SUPPLIES_N10, MSC_DOC_ATTACHMENTS_U1, MSC_LONG_TEXT_U1 and MSC_SHORT_TEXT_U1) (Doc ID 2145763.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

On : 12.2.5 version, followed Note 340118.1 and the following indexes consistently become invalid after running Data Collections:

TABLE_NAME INDEX_NAME PARTITION_NAME
-----------------------------------------------------------------
MSC_DEMANDS MSC_DEMANDS_N9 DEMANDS__1
MSC_DOC_ATTACHMENTS MSC_DOC_ATTACHMENTS_U1 DOC_ATTACHMENTS__1
MSC_LONG_TEXT MSC_LONG_TEXT_U1 LONG_TEXT__1
MSC_SHORT_TEXT MSC_SHORT_TEXT_U1 SHORT_TEXT__1
MSC_SUPPLIES MSC_SUPPLIES_N10 SUPPLIES__1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. ASCP>Collections>Oracle Systems>Standard Collections

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, per business requirements, goal is to always have zero invalid objects on our database for products we use.

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