My Oracle Support Banner

AFTER WORKFLOW WAS RERUN, NEED FIX TO SET BOOKED SALES ORDER LINES TO CLOSED (Doc ID 2461163.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

On : 12.1.3 version, Transaction Entry

ACTUAL BEHAVIOR
---------------

Workflow was accidentally re-run for "OEOH -Booked Eligible" and it re-booked some Lines.

The Sales Order Header is closed. The Workflow is closed. Some of the Sales Order Lines are in BOOKED status.

The Workflow for those lines are closed.

EXPECTED BEHAVIOR
-----------------------
Expect that the lines should be closed so the order can be completed.

STEPS
-----------------------
As this is a data issue, it cannot be reproduced.

The following SQL identified the lines with this issue:
-----------------------

select line_id , flow_status_code , invoice_interface_status_code ,
invoiced_quantity , open_flag
from oe_order_lines_all
where flow_status_code ='BOOKED'
and header_id = <HEADER_ID> ;

Replace <HEADER_ID> with the impacted sales order's header id.

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.