EGL 9.1: Receiving Error ORA-01408: Such Column List Already Indexed When Applying FSCM 9.1 Maintenance Pack 11 Delta (Doc ID 1515228.1)

Last updated on AUGUST 01, 2014

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to apply FSCM 9.1 MP 11 Delta: Task 1-1 People Soft Product : General Ledger - the following error occurs.

ERROR
-----------------------
Return 1408 - ORA-01408: such column list already indexed for the following tables:

PS_BP_APN_S_TAO
PS_BP_APV_S_TAO
PS_BP_ARM_S_TAO
PS_BP_ARR_S_TAO
PS_BP_BI_S_TAO
PS_BP_CM_S_TAO
PS_BP_GEN_S_TAO
PS_BP_GLB_S_TAO
PS_BP_GM_S_TAO
PS_BP_HR_S_TAO
PS_BP_POC_S_TAO
PS_BP_TA_S_TAO


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Unzip upd887959.zip and find BP_TAO_TBLS.zip under upd887959\upd887959_install
2 Apply BP_TAO_TBLS project

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