My Oracle Support Banner

Batch Pricing Prog Opens Too Many Database Sessions, Brings Down Instance (Doc ID 2654632.1)

Last updated on APRIL 12, 2020

Applies to:

Oracle Shipping Execution - Version 12.2 and later
Oracle Order Management - Version 12.2 and later
Oracle Advanced Pricing - Version 12.2 and later
Information in this document applies to any platform.



Customer initially reported that the issue is happening with Batch
Pricing concurrent request i.e lot inactive sessions are not getting closed
which is increasing resulting into crashing of customer's instance.
Observed that here, Batch Pricing concurrent requests are getting completed without any issue.

The collaboration SR  with ATG team was logged and they isolated
the issue as being due to connection leaks in with below details:

    The stack trace shows connection leak in ,stack trace
    shows that RequestRates.verifyCaller is calling IntegrationUtil.init and in
    the init it create the connection , but it never closes it .


The issue can be reproduced at will with the following steps:
1. Run concurrent program "Batch Pricing" with no parameters or for long range




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.