Sales Order Line Level Hold Information Not Seen In Order Corrections Form (Doc ID 2648903.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

On : 12.2.7 version, Transaction Control

ACTUAL BEHAVIOR

============

Sales Order Line Level Hold Information not seen in Order Corrections form

(i) Working scenario:
    --------------------

>> Respective sales order header data and line data along with header hold data are inserted into OE_ACTIONS_IFACE_ALL table.

>> Before triggering the order import, upon navigating to the order corrections form ,header actions record can be seen. When Order Import program is triggered now, order is processed successfully and hold is released at header level.


(ii) Scenario having issue:
-----------------------------------

>> Respective sales order header and sales order line data along with sales order line hold data are inserted into OE_ACTIONS_IFACE_ALL table

>> Before triggering the order import, upon navigating to the order corrections form, header actions record can be seen but the line hold information cannot be seen . However, triggering of Order Import results in successful release of sales order line-level hold


EXPECTED BEHAVIOR
=============

When sales order header and sales order line data along with sales order line level hold data is inserted into OE_ACTIONS_IFACE_ALL table, sales order line hold information should be seen in order corrections form

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

1. Insert sales order header and line data along with sales order line level hold data into OE_ACTIONS_IFACE_ALL table
2. Logon to Oracle Applications
3. Go to Order Management Super User - Orders, Return - Import Orders - Corrections
4. In header order actions, header details as well as header level hold information is seen
5. In line actions, line level information is seen, but line level hold information is missing
6. Upon running Order Import, both header level and line level holds are released

Cause

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