E-INST: Indexes Reappear in Alter Audit PT 8.48+ (Doc ID 662519.1)

Last updated on JULY 18, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version: 8.4 and later   [Release: 8.4 and later ]
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 201070468



"""""reviewed for currency Feb 2010"""""

Symptoms

After a Demo installation using PeopleTools 8.48, whenever an Alter Audit is run, most (or all) of the indexes appear to show up again and again.



ISSUE:
After a new demo installation of PeopleTools 8.48, whenever an alter audit is run, most (or all) of the indexes appear to show up again and again. Below is an example of what is showing up:

DROP INDEX PS_AE_SECTION_TBL
/
CREATE UNIQUE INDEX PS_AE_SECTION_TBL ON PS_AE_SECTION_TBL
(AE_PRODUCT,
AE_APPL_ID,
AE_SECTION,
DB_PLATFORM,
EFFDT DESC) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000
MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING
/
ALTER INDEX PS_AE_SECTION_TBL NOPARALLEL LOGGING

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