HFM applications taking too many connections and releasing the connections once the user log off.
This is actually a bug and there is a patch set available to fix.
To implement the solution, please execute the following steps:
1. Download and review the readme Oracle Patch 23527466 .
2. Apply the patch in a test environment.
3. Retest the issue.
4. Migrate the solution as appropriate to other environments.