Sales Order Header Hold Applied by Hold Source does Not Progress Order Lines Upon Hold Release (Doc ID 2015592.1)

Last updated on SEPTEMBER 23, 2024

Applies to:

Symptoms

On : 12.1.3 version, Transaction Control

ACTUAL BEHAVIOR
---------------
Sales Order Hold which was applied by Hold Source does not progress order lines upon hold released.
There is a hold source to apply a hold to the sales order header to prevent the order lines from progressing to Account Receivable (AR) to create Invoices / Credit Memo's.
When the hold is manually applied to a sales order and manually released, the order lines progress as expected.
But when the hold is applied to the sales order header via a hold source, upon release the order lines are not progressing.

When the hold source is released, the sales order lines progress.
But, the hold source is in place to apply a certain hold for a given order type, the user does not want to release the hold source, it needs to be in place to always apply the hold to the sales orders with the given order type.

There is a Timeout of 12 that is assigned on the Invoice Interface - Eligible workflow node once the hold is released from the header (when the header hold was applied by the Hold Source).
When workflow background progress runs after 12 hours period, it progress the line to AR Interface.

EXPECTED BEHAVIOR
-----------------------
Expect the order line to progress after order hold is released.
We want to apply the hold to the order header so the users don't need to manage the holds being applied at the line level as these types of orders can have a large number of order lines.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login as Order Management responsibility
2. Navigate Orders, Returns > Orders Organizer > Tools Menu> Create Hold Sources> [Apply Holds]
Create an Order Header Hold that prevents any lines from progressing to AR for invoicing until the order is ready to be released to AR.
3. Create an order, in this example it’s a Bill Only order.
Manually apply this hold to prevent the order from Invoicing right away
3. Once the Workflow Background Process runs for OM Order Lines, the lines have a status of 'Awaiting Invoice Interface - On Hold'
4. Now, release the INVOICE HOLD – HEADER hold from the Order Header
Once the Workflow Background Process runs for OM Order Lines, all of the lines progress to a Status of Closed without the user needing to do anything else.
When manually applying and releasing the INVOICE HOLD – HEADER hold, the order lines are progressing as expected.

The issue is related to when the INVOICE HOLD – HEADER hold is applied to an order via a Hold Source.
1. Login as Order Management responsibility
2. Navigate Setup > Orders > Holds
Create a Hold Source based on Order Type.
3. Create a Sales Order with the Order Type of EU DE DFDG BILL ONLY ORDER.
4. Book the order. The Line Status on each of the lines is now 'Fulfilled'
5. Run the Workflow Background Process for OM Order Lines.
Once complete the Line Status on all the lines is 'Awaiting Invoice Interface - On Hold'
6. Manually release 'INVOICE HOLD – HEADER' hold from the Order Header
7. Run the Workflow Background Process for OM Order Lines.
Notice the Line Status on all the lines is still 'Awaiting Invoice Interface - On Hold' and not progressing to a Status of Closed.
8. Once the Order Header hold was released, expected the workflow to move to the Invoice Interface – Deferred node,
but it is staying on the Invoice Interface – Eligible node and now has a Timeout value of 12.

Cause

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