Open Lines Don't Go On Credit Check Hold When Customer Hits Credit Limit (Doc ID 471226.1)

Symptoms

Find that open Order Lines are not going on Credit Check failure Hold when the Customer reaches Credit Limit. Orders continue to ship, even when exceeding the Customers overall Credit limit.

You run the "Initialize Credit Summaries Table" concurrent program every 12 hours, and at one point the Customer briefly did not exceed the Credit Limit that was set up, so the Sales Orders were released from Credit Check Failure Hold automatically.

The issue is that there were still open Lines on the Sales Orders, and even though the fulfillment of some of those Order Lines did put the Customer over the Credit Limit again, the Sales Orders did not go back on to Credit Check Failure Hold at that point.

Product has therefore been shipped to a Customer who has exceeded their Credit Limit.


Expect Sales Orders to go back onto Credit Check Failure Hold at the point where the Customer
Credit Limit is again exceeded by particular Sales Order Lines.

Cause

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