R12 E-Business Suite Workflow Script WFPART.SQL Fails With 'ERROR at line 1: ORA-01418: specified index does not exist' When Partitioning Workflow Tables (Doc ID 2308351.1)

Last updated on SEPTEMBER 21, 2017

Applies to:

Symptoms

E-Business Suite R12 Workflow, Workflow Server Engine related issues

Users report the following error when partitioning Workflow Tables via script wfpart.sql:

alter index WFN_WF_ITEM_ATTRIBUTE_VALUES_N rename to
WF_ITEM_ATTRIBUTE_VALUES_N1
*
ERROR at line 1:
ORA-01418: specified index does not exist

The issue occurs while partitioning Workflow Tables per the following steps:

1. Run the following command via sqlplus:
   $FND_TOP/patch/115/sql/wfpart.sql applsys apps apps apps <ult file location>
2. A new script, also named wfpart.sql, is created under utl file location
3. Run the new script wfpart.sql to perform the partitioning, and receive the below output:

.....
Recreating table WF_ITEM_ATTRIBUTE_VALUES
Table created.
Table altered.
Table altered.
Table altered.
Index altered.
alter index WFN_WF_ITEM_ATTRIBUTE_VALUES_N rename to
WF_ITEM_ATTRIBUTE_VALUES_N1
*
ERROR at line 1:
ORA-01418: specified index does not exist
----------------------------------------------

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.