After R12.1 Upgrade Holds Are Not Getting Released On The Sales Orders APP-ONT-251123 (Doc ID 1285546.1)

Last updated on JULY 26, 2021

Applies to:

Symptoms

After upgrading from version 12.0.4 to 12.1.2, few holds are not getting released in Transaction Control. You try to remove the hold and the following message occurs, but the hold is not removed:

MESSAGE
-----------------------
APP-ONT-251123: Hold released Successfully

Further research identified pre-req <Patch 8985958:R12.ONT.B> was missed and now you require a data fix  with scripts like:

a. Hold_Upgrade_Item_Not_release.sql : to populate data for Hold type-Item and hold NOT released
b. Hold_Upgrade_Item_release.sql :to populate data for Hold type-Item and hold released
c. Hold_Upgrade_Not_Item_Not_release.sql : to populate data for Hold type NOT equal to Item and hold NOT released
d. Hold_Upgrade_NOT_Item_release.sql :to populate data for Hold type not equal to Item and hold released

Sample sql output:

This issue is referenced in the following note:

• <Document 1199627.1>  After 12.1.x upgrade, Upgraded Orders on Hold can be Pick Released

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

1. Responsibility: Order Management Super User
2. Navigate: Orders Workbench, Order Organizer > Query a Sales Order
3. Go to a Line
4. Select > Actions > Release Holds
5. Select hold Make & Hold provide reason and Press Release.
6. Message “APP-ONT-251123: Hold released Successfully “ is displayed but hold is not released

Due to this issue, users cannot release the holds.

This issue is occurring for holds irrespective of type when in the table OE_HOLD_SOURCES_ALL for these records the column HOLD_ENTITY_ID is null.  Therefore, this record is not getting fetched by the routine OE_Holds_Pvt.release_orders hence and it is not getting released.

Changes

Cause

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