ORA-01450: Maximum Key Length Applying Patch 17020683

(Doc ID 1990588.1)

Last updated on SEPTEMBER 07, 2016

Applies to:

Oracle Applications DBA - Version 12.2.3 to 12.2.3 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On Oracle Applications 12.2.3 version, Patch Application Issues,
the following error occurs while applying patch 17020683:

PCTFREE 10 INITRANS 11 MAXTRANS 165 COMPUTE STATISTICS
STORAGE(INITIAL 16384 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_TX_IDX"
ONLINE
Error message is: ORA-00604: error occurred at recursive SQL level 1
ORA-01450: maximum key length (3800) exceeded

This can be reproduced with the following step:
1. Apply patch 17020683.

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