I have 1 scenario, kindly suggest how to do that in oracle. How to increase credit limit for particular customer. for eg: customer has 10,000 credit limit. he is booking order for 10,500 including tax. during shipping it will create hold. Now I want to increase credit limit to 10,500 for temporarily ie, for that single order. Then from next order onwards it should have credit limit 10,000. How to achieve this automatically.