R12.1.x Finds Many OM Credit Check Hold Notifications Daily (Doc ID 3030529.1)

Last updated on JUNE 24, 2024

Applies to:

Symptoms

Receiving complaints from business about many credit check hold notifications every day after the Credit Hold is applied,
The notification emails are also being triggered every time Credit Check is performed even in the scenario where Hold already exists on
a sales order and Notification is already sent for the first time. 

Users are receiving the same email every day multiple times as program is scheduled for every 3 Hours.
Hence users are receiving email 8 times per day. Expects that the application should not send hold notification (email) except for the first time hold is applied.

The issue can be reproduced at will with the following steps:
1. Setup Credit Check Rule, Credit Check Level is "Sales order line", Credit Hold Level is "Sales order line".
2. Assign the Credit Check Rule to Ordering phase of Order Type.
3. Create and Book an order, order is placed on hold, and a Hold Notification is sent.
4. Pick release the order and pick release fails because of order on hold,
5. A new notification is sent out.

Cause

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