My Oracle Support Banner

An Order Line Status is Stuck in Fulfilled Status, While Other Lines in the Same Order Progressed to Closure Belonging to the Same Fulfillment Set (Doc ID 3035459.1)

Last updated on JULY 19, 2024

Applies to:

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

Symptoms

Line 1.1 is stuck in 'Fulfilled' status, but has not yet interfaced to AR, while line 2.1 has already progressed to closure. Both lines belong to the same fulfillment set, so line 2.1 should have not closed until 1.1 is ready for closure as well. The following shows the last workflow activity for Line 1.1

Invoice Interface - Line Start Complete Null LINE_INVOICE_INTERFACE_SUB START COMPLETE #NULL 24-JUN-24 20:51:06 24-JUN-24 20:51:06 24-JUN-24 1113
Invoice Interface - Line Invoice Interface Error Exception LINE_INVOICE_INTERFACE_SUB INVOICE_INTERFACE ERROR #EXCEPTION 24-JUN-24 20:51:06

 

When attempting to perform Retry Activity on the line, the following error is seen in the debug logs:

 

PREPARE TERRITORY INFORMATION. l_territory_code: BILL
Inside Others Exception
UNEXPECTED ERROR. EXITING INTERFACE_SINGLE_LINE User-Defined Exception
RETURN STATUS :S OUT RESULT :
INTERFACED W/REQUEST_ID : X_RETURN_STATUS: U
UNEXPECTED ERROR. EXITING FROM LINE INVOICING : User-Defined Exception
LEAVING OE_MSG_PUB.COUNT_AND_GET 0
INFO-L_RETURN_STATUS: U
INFO-L_RESULT_OUT:
OEXWINVB.pls - in unexpected error raise exception
LEAVING OE_MSG_PUB.ADD
In WF save messages
ENTER Save_API_Messages
l_errmsg ORA-20001:
L_MSG_DATA=Workflow activity Invoice Interface has failed due to an unexpected error. Please retry the activity from the Order Form or the Workflow Monitor. If it fails again, then contact your System Administrator.
Order Number :1392235 Line Number :1.1
Message :Workflow activity Invoice Interface has failed due to an unexpected error. Please retry the activity from the Order Form or the Workflow Monitor. If it fails again, then contact your System Administrator.

EXIT Save_API_Messages


It is expected that the line should interface to AR.

The issue can be reproduced at will with the following steps:
1. Create a Sales Order with some lines in the same Fulfillment set
2. Progress the lines to Receivables

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.