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 FEBRUARY 19, 2019
Applies to:
Oracle Workflow - Version 12.1.3 and laterInformation 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |