My Oracle Support Banner

Datafix To Progress Sales Order Headers Stuck in Booked Status And WF Activity Book_Cont_L With All Lines In Closed or Cancelled Status (Doc ID 2967890.1)

Last updated on MAY 01, 2024

Applies to:

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

Symptoms

Sales order headers status is booked but lines are closed.  After the lines status progressed to closed, the expectation is
the order header would also progress to a closed status, but it remains in booked status.


The issue can be reproduced at will with the following steps:

1. Responsibility: Order Management Super User.
2. Order Organizer > Query Sales Order: 1396186
3. Header: Booked
    Header WF: Book - Order, Manual Book - Continue Line ACTIVE
4. Lines are Closed and Cancelled > Open Flag N, Booked Flag Y and Cancelled Y & N
5. Delivery Detail ID's show as Closed or Cancelled
6. Following select Identified all problematic Orders.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.