My Oracle Support Banner

Line Status Stuck In Shipped And/Or Fulfilled Status Where Line Workflow Progressed To Close Line Complete Preventing Order Header From Closing (Doc ID 2811739.1)

Last updated on OCTOBER 16, 2024

Applies to:

Oracle Order Management - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Order header will not close. Most lines are in a closed status, but there exists few lines stuck in a SHIPPED and/or FULFILLED status.
Despite line fulfillment, invoice interface and close line workflow activities completing, the order line status remains stuck in a SHIPPED and/or FULFILLED status.
The fulfilled flag is N and the fulfilled quantity is null.  The invoice_interface_status is N and the invoiced quantity is null.

For order line stuck in SHIPPED status yet line workflow fulfill, invoice interface and close line activities have completed.
Example line workflow from order output
Line workflow shows that it has progressed past shipped to closure.

Line Flow - Generic Fulfill COMPLETE #NULL R_STANDARD_LINE FULFILL_LINE   17-MAY-21 15:25:49 17-MAY-21 15:25:49
Line Flow - Generic Invoice Interface - Line COMPLETE COMPLETE R_STANDARD_LINE LINE_INVOICE_INTERFACE_SUB   17-MAY-21 15:25:49 17-MAY-21 15:25:49
Invoice Interface - Line Start COMPLETE #NULL LINE_INVOICE_INTERFACE_SUB START   17-MAY-21 15:25:49 17-MAY-21 15:25:49
Invoice Interface - Line Invoice Interface COMPLETE COMPLETE LINE_INVOICE_INTERFACE_SUB INVOICE_INTERFACE   17-MAY-21 15:25:49 17-MAY-21 15:25:49
Invoice Interface - Line End COMPLETE #NULL LINE_INVOICE_INTERFACE_SUB END   17-MAY-21 15:25:49 17-MAY-21 15:25:49
Line Flow - Generic Close - Line COMPLETE   R_STANDARD_LINE CLOSE_LINE_PROCESS   17-MAY-21 15:25:49 17-MAY-21 15:25:50
Close - Line Start COMPLETE #NULL CLOSE_LINE_PROCESS START   17-MAY-21 15:25:49 17-MAY-21 15:25:49
Close - Line Close COMPLETE COMPLETE CLOSE_LINE_PROCESS CLOSE_LINE   17-MAY-21 15:25:49 17-MAY-21 15:25:50
Close - Line Close - Continue Header COMPLETE #NULL CLOSE_LINE_PROCESS CLOSE_CONT_H   17-MAY-21 15:25:50 17-MAY-21 15:25:50
Line Flow - Generic End COMPLETE #NULL R_STANDARD_LINE END


For order line status stuck in FULFILLED status yet line workflow invoice interface and close line activities has completed.
Example line workflow from order output
Line workflow shows that it has progressed past fulfilled to closure.

Line Flow - Generic, with Repricing at Fulfillment Invoice Interface - Line COMPLETE COMPLETE R_STANDARD_LINE LINE_INVOICE_INTERFACE_SUB 30-SEP-21_00:57:17 30-SEP-21_00:57:17
Invoice Interface - Line Start COMPLETE #NULL LINE_INVOICE_INTERFACE_SUB START 30-SEP-21_00:57:17 30-SEP-21_00:57:17
Invoice Interface - Line Invoice Interface         30-SEP-21_00:57:17 30-SEP-21_00:57:17
Invoice Interface - Lne End COMPLETE #NULL LINE_INVOICE_INTERFACE_SUB END 30-SEP-21_00:57:17 30-SEP-21_00:57:17
Line Flow - Generic, with Repricing at Fulfillment Close - Line COMPLETE   STANDARD_LINE_REPRICE CLOSE_LINE_PROCESS 30-SEP-21_00:57:17 30-SEP-21_00:57:17
Close - Line Start NULL COMPLETE CLOSE_LINE_PROCESS START 30-SEP-21_00:57:17 30-SEP-21_00:57:17
Close - Line Close COMPLETE COMPLETE CLOSE_LINE_PROCESS CLOSE_LINE 30-SEP-21_00:57:17 30-SEP-21_00:57:17
Close - Line Close - Continue Header NULL COMPLETE CLOSE_LINE_PROCESS CLOSE_CONT_H 30-SEP-21_00:57:17 30-SEP-21_00:57:17



Expect all lines to show as CLOSED with the  fulfilled and/or invoiced quantity populated with the invoice interface flag = Y since the line workflow is close line complete.


The issue cannot be reproduced at will as it is data corruption.

Changes

 

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
Changes
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.