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:

Oracle Workflow - Version 12.1.3 and later
Information in this document applies to any platform.

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

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