Increasing OTM DB Pool size

 

Login to OTM using DBA.Admin

Search for Primary_JTS in Data sources

 

Edit the Pool section of the Source

 

 

You can change the Maximum Capacity as required. 

Note ** : Before changing this value, make sure you have enough capacity and processes limits on Oracle DB

Tool to update and add Rate Factors

At one of client implementation, users had a large number of updates to rate factors every week and have a large number of rate factor sources

Here’s a a simple way to update rate factors.   Comment in this post if you need a copy of this ..