Credit Check Processor and OE_CREDIT_CHECK_RPT
ALL:
Whenever an order is booked, the flow_status_code immediately goes to "Awaiting Shipping."
When the Credit Check processor runs, it calls a private API, oe_credit_check_rpt. In this package body, there is a query that contains the following where clause:
AND OL.flow_status_code = ''BOOKED''
Since Orders always have a flow_status_code of 'AWAITING SHIPPING' when booked, this condition will always fail, therefore the Credit Check Processor will NEVER place an order on hold.
What's the purpose of this where clause?
If I want orders to be put on credit check failure hold, then this where condition needs to be removed.