Creating Indexes Has 8 Tables With Errors Due To Oracle Maximum Index Columns Of 32

(Doc ID 2312635.1)

Last updated on SEPTEMBER 29, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Patching and Maintenance

Creating Indexes has 8 tables with Errors Due to Oracle maximum index columns of 32
The following tables are throwing ORA-01793 error. Can you let us know why Oracle is creating tables with 33 indexes when the maximum limit is 32?

PS_DATA_C_AUDIT
PS_DATA_C_PO_TAO -
PS_DATA_C_PO_TAO2
PS_DATA_C_PO_TAO3
PS_DATA_C_PO_TAO4
PS_DATA_C_PO_TAO5
PS_DATA_C_PO_TAO6
PS_DATA_C_PO_TAO7

20:54:26 SQL> CREATE UNIQUE iNDEX PS_DATA_C_PO_TAO ON PS_DATA_C_PO_TAO
20:54:26 2 (PROCESS_INSTANCE,
20:54:26 3 TAS_GWA,
20:54:26 4 BUSINESS_UNIT,
20:54:26 5 BUSINESS_UNIT_GL,
20:54:26 6 ACCOUNT,
20:54:26 7 ALTACCT,
20:54:26 8 DEPTID,
20:54:26 9 OPERATING_UNIT,
20:54:26 10 PRODUCT,
20:54:26 11 FUND_CODE,
20:54:26 12 CLASS_FLD,
20:54:26 13 PROGRAM_CODE,
20:54:26 14 BUDGET_REF,
20:54:26 15 AFFILIATE,
20:54:26 16 AFFILIATE_INTRA1,
20:54:26 17 AFFILIATE_INTRA2,
20:54:26 18 CHARTFIELD1,
20:54:26 19 CHARTFIELD2,
20:54:26 20 PROJECT_ID,
20:54:26 21 CURRENCY_CD,
20:54:26 22 STATISTICS_CODE,
20:54:26 23 FISCAL_YEAR,
20:54:26 24 ACCOUNTING_PERIOD,
20:54:26 25 ACCOUNTING_DT,
20:54:26 26 GTAS_BEGIN_END,
20:54:26 27 APPL_JRNL_ID,
20:54:26 28 REFERENCE_ID,
20:54:26 29 PROCURE_INSTRUM_ID,
20:54:26 30 PI_ID_PARENT,
20:54:26 31 FEDERAL_AWARD_ID,
20:54:26 32 UNIVERSAL_REC_ID,
20:54:26 33 FED_CLASS_FLD,
20:54:26 34 FED_PROGRAM) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000
20:54:26 35 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING
20:54:26 36 /
  FED_PROGRAM) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000
  *
ERROR at line 34:
ORA-01793: maximum number of index columns is 32

The issue can be reproduced at will with the following steps:
1. While upgrading noticing error messages with the mentioned tables
2. The following tables are throwing ORA-01793 error.
3. Oracle is creating tables with 33 indexes when the maximum limit is 32?


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