Order Lines At 'Awaiting Shipping',Workflow-Ora-01653-Wf_item_activity_statuses (Doc ID 829298.1)

Last updated on JULY 13, 2016

Applies to:

Oracle Order Management - Version 12.0.6 and later
Information in this document applies to any platform.

***Checked for relevance on 20-Jan-2014***

Symptoms

-- Problem Statement:
On 12.0.6 in Production:

One order has 3 lines , which are stuck with following errors.

3 lines.
1.1, 1.2 - status at 'Invoice Incomplete' status.
1.3 - Awaiting Shipping status

with workflow error

ERROR
163887 Ship - Line, Manual Ship Exception Error -1653 ORA-01653: unable to extend table
APPLSYS.WF_ITEM_ACTIVITY_STATUSES by 16 in tablespace APPS_TS_TX_DATA
Wf_Item_Activity_Status.Create_Status(OEOL, 163887, 208057, ACTIVE)
Wf_Engine_Util.Process_Activity(OEOL, 163887, 208057, 50) Wf_Engine_Util.Complete_Activity(OEOL,
163887, 208065, SHIP_CONFIRM) Wf_Engine.CompleteActivity(OEOL, 163887, SHIP_CONFIRM:SHIP_LINE,
SHIP_CONFIRM)

-- Steps To Reproduce:
The issue can NOT be reproduced at will .

-- Business Impact:
The issue has the following business impact:
Due to this issue, cannot process and complete the interfaces for the order.

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