My Oracle Support Banner

Why Did Sales Order Go On A Credit Check Failure Hold when 'Include Payments at Risk' is not enabled? (Doc ID 788261.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Order Management - Version to 12.0.6 [Release 11.5.10 to 12.0]
Oracle Order Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


In Applications Release 11i or 12 you are finding that a Sales Order with a value of (say) $986.00 went onto 'Credit Check Failure' Hold at booking despite the fact that the Customer's Credit Limit is $5000.00 and the outstanding receivables balance is zero.

The issue happens for many Customers, so is not a setup problem for any one Customer.

In the reported case, the 'Credit Exposure Report' for this Customer is showing $14,878.12, which seems incorrect since the 'Customer Credit Snapshot' shows that all Sales have payments against them.

Customer Numbers From: xxxx To: xxxx
Credit Check Rule    : Booking
Overall Limit        =  5,000.00
Exposure             = 14,878.12
Available            = -9,878.12

All payments were made by credit card.

An OM Debug output was captured when booking this particular order, and it can be seen that the
'l_include_risk_flag = Y' even though the Credit Check Rule used 'Booking' does not have the box checked for 'Include Payments at Risk':

Assign Default Values: Credit rules
Credit rule setup values
l_open_ar_days =
l_uninvoiced_orders_flag = Y
l_orders_on_hold_flag = Y
l_include_tax_flag = Y
l_shipping_horizon = 31-DEC-12
l_include_risk_flag = Y
l_quick_cr_check_flag = N
l_freight_charges_flag = Y
l_open_ar_balance_flag = Y
l_incl_external_exposure_flag = N
l_include_returns_flag = N
and credit exposure seems to be including payments at risk:
Begin OM Exposure calculation
select cust_uninvoiced_orders
l_usage_total_exposure = 14878.12
l_cum_total_from_ar = 0
l_total_from_ar =
l_total_from_br = 0
l_cum_payments_at_risk = 14878.12
l_payments_at_risk = 14878.12

Your expectation is that Orders should not go on Credit Check Hold when the outstanding receivables balance is zero and 'Include Payments at Risk' is not checked on the relevant Rule.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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