Getting Warning Message To Set Autoclose(false) While Pricing Upload Using Price Assignment Service. (Doc ID 2808372.1)

Last updated on SEPTEMBER 28, 2021

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.8.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.8.0.0.0 version, BT - Batch

ACTUAL BEHAVIOR
---------------------
Getting Warning Message to set autoclose(false) while Pricing Upload using Price Assignment Service.

Customer is using Price Upload through FRT.Performance of the same is very poor.

On investigating the log it is found that multiple warning messages for autoclose of prepared statement as mentioned below:

WARN (com.splwg.base.support.sql.PreparedStatementImpl) The statement select price_parm_cd, price_parm_val from ci_priceasgn_parm where price_asgn_id = '3670007924' was already used- should be marked as autoclose(false) to be optimially reused
INFO (com.splwg.base.support.sql.PreparedStatementImpl) Executing SQL: select price_parm_cd, price_parm_val from ci_priceasgn_parm where price_asgn_id = '3670007924'

STEPS TO REPRODUCE

-----------------------------

1.Go to price list screen

2.Add a price item with parameters to that price list.

3.Again add same price item with different parameter values to that price list.

4.Check the logs

EXPECTED BEHAVIOR
------------------------

Warning messages for autoclose of prepared statement should not be thrown.