DATAFIX Header/Lines In 'Booked' or 'Awaiting_Shipping' Status. Header and Line Workflows Missing (Doc ID 1470700.1)

Last updated on FEBRUARY 23, 2017

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 22-SEP-2015***
***Checked for relevance on 23-FEB-2017***

Symptoms

On : 12.1.3 version, Transaction Control

ACTUAL BEHAVIOR
Have found 4 orders where the Header remain in BOOKED status, the lines are in BOOKED and/or
AWAITING_SHIPPING. Need a datafix to regenerate the workflow lines for the Awaiting_Shipping
lines and a script to progress the Booked order lines.

Example:
Order Number = xxxxxxx8
Header = BOOKED
Header WF = NULL
Warning List:
Order_Line status BOOKED but "Book" activity has not been completed.

Lines = BOOKED (Total of 2 lines, with WORKFLOW but cannot progress line)
xxxxxx2 Enter - Line Wait for Booking Notified ENTER BOOK_WAIT_FOR_H 14-JUN-12_09:43:41
xxxxxx3 Enter - Line Wait for Booking Notified ENTER BOOK_WAIT_FOR_H 14-JUN-12_09:43:41

Lines = AWAITING_SHIPPING (Total of 28 lines with NO WORKFLOW associated with the line)

OBSERVATION
Suggested to cancel the lines and create a new order, however, this is not a feasible solution
for the customer.  These order must all remain on the same order, therefore their only option
is a datafix.

EXPECTED BEHAVIOR
Expect the workflow to be present for the Awaiting_Shipping order lines.

STEPS
1. Responsibility: Order Management Super User
2. Order Organizer > Sales Order > Query Order xxxxxx8
3. Header Booked = Warning > Order_Line status BOOKED but "Book" activity has not been completed.
4. Lines BOOKED = Two lines but cannot progress
5. Lines AWAITING_SHIPPING = XX Lines, but no workflow lines exists.

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