Order Status Booked-Workflow Error ORA-01654: unable to extend index APPLSYS.WF_ITEM_ACTIVITY_STATUSES_N1 (Doc ID 849725.1)

Last updated on JULY 13, 2016

Applies to:

Oracle Order Management - Version 11.5.1 to 11.5.10.3 [Release 11.5.1 to 11.5.10]
Information in this document applies to any platform.
FORM:OEXOEORD.FMB - Sales Orders
***Checked for relevance on 20-Jun-2011***
***Checked for relevance on 26-Feb-2013***


Symptoms

On 11.5.10.2 in Production:
Order line status of the 2 orders remain in 'Booked', It does not changed to 'Closed'.
Using the workflow "Bill only with inventory interface" and all the processes are run using scheduled concurrent request.

Workflow shows 'Booking' activity failed with following error.

ERROR

ORA-01654: unable to extend index APPLSYS.WF_ITEM_ACTIVITY_STATUSES_N1 by 16 in tablespace

APPS_TS_TX_IDX ORA-01654: unable to extend index APPLSYS.WF_ITEM_ACTIVITY_STATUSES_N1 by 16 in
tablespace APPS_TS_TX_IDX [Error Process Error: ORA-01654: unable to extend index
APPLSYS.WF_ITEM_ATTRIBUTE_VALUES_PK by 16 in tablespace APPS_TS_TX_IDX]


-- Steps To Reproduce:

The issue can be reproduced at will with the following steps:
1.Enter the Sales Order
2.Book the Sales Order
3.Run the “Workflow Background Process”
4.Launch and run the “Material Transaction“ Interface Manager

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