Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

R12.1.3 : Patch R12.PJ_PF.B.delta.6 (17839156) fails creating index

edited Sep 24, 2014 4:57AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓

hello,

Applying the Patch R12.PJ_PF.B.delta.6 (17839156), it fails because one of the indexes that try to create already exists

We are trying to apply this path in the development environment of Oracle Financials R12.

RDBMS: 11.2.0.3.0
Applications: 12.1.3

Error to create following indexes:

CREATE INDEX AR.RA_INTERFACE_DISTRIBUTIONS_N1 ON
AR.RA_INTERFACE_DISTRIBUTIONS_ALL (INTERFACE_LINE_ID) LOGGING STORAGE
(FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE 10 INITRANS 11 MAXTRANS 255
COMPUTE STATISTICS  TABLESPACE APPS_TS_INTERFACE

CREATE INDEX AR.RA_INTERFACE_LINES_N1 ON AR.RA_INTERFACE_LINES_ALL
(REQUEST_ID) LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE 10
INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS  TABLESPACE APPS_TS_INTERFACE

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center