Best Practice to Customize Credit Limit in Oracle EBS Order Management

Hi Guru,

Background

I am now implementing Oracle Distribution R12.1 and receiving requirement from my client to perform credit check upon booking of Sales Order.

My client requires Oracle EBS to check customer credit limit based on 2 conditions

a. Check credit limit based on open AR.

    Example : If customer has open AR above the amount defined in Customer Master, system will put the order on hold

b. Check credit limit based on payment term for each customer

    Example : If customer Sales Order has credit term of 10 D. If the sales order is not paid after 10D system will put on hold to next sales order. Credit term of customer can be multiple in each sales order.