淡

看个简单的例子客户信用限额非全局信用控制非全局信用控制比较简单，我们看一下全局信用控制设置：实现结果：全局&非全局对比

一，导入外部风险FUNCTION import_credit_exposure(p_org_id IN NUMBER, p_customer_id IN NUMBER, p_bill_to_site_uses_

DECLARE l_msg_count NUMBER; l_msg_data VARCHAR2(2000); l_return_status VARCHAR2(30); l_cc_hold_comment VARCHAR2(30); l_result_out VARCHAR2(30); g_user_id

DECLARE l_msg_count NUMBER; l_msg_data VARCHAR2(2000); l_return_status VARCHAR2(30); l_cc_hold_comment VARCHAR2(30); l_result_out VARCHAR2(30); i

In this Document Goal SolutionAPPLIES TO:Oracle Order Management - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]Information in this document app

Credit checking feature of Oracle OM provides the ability to check that the customer has sufficient credit available with the organization at the point of order booking ,picking, packing and shipping.

This post will more focus on Technical part of credit check Functionality. You can check the functional part of credir check functionality here. TABLESThese are the main tables used for hold