Unable to Execute Parallel Calls from the AsFileReceived Web Service (Doc ID 3038415.1)

Last updated on AUGUST 02, 2024

Applies to:

Symptoms

On : 11.2.0.19 version, Web Services

ACTUAL BEHAVIOR
---------------
Attempting to run parallel threads for the AsFileReceived Web Service using the following parameters from the PAS.properties file:


#----------------------------------------------------------------------
# AsFile Asynchronous Task Executor ThreadPool Properties
#----------------------------------------------------------------------
async.AsFileTaskExecutor.corePoolSize=10
async.AsFileTaskExecutor.maxPoolSize=50
async.AsFileTaskExecutor.queueCapacity=100
#----------------------------------------------------------------------

However not observing any improvements in response times from OIPA.



EXPECTED BEHAVIOR
-----------------------
The business should be able to make parallel AsFileReceived Calls to decrease the response times when external system makes call for OIPA illustration.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1 The File Received Web Service (ILS) which runs on Quote Mode. This ILS AsFile is responsible for running a Transaction ILSQuote with all the GIC entries in AsActivityMultiValueField.
2. The ILSQuote Transaction is having the CopyBook-ILSFixedFunds which in turn calls Function-TC_AnnuityPaymentArrays.
3. The Function-TC_AnnuityPaymentArrays Function is responsible for calling Function-TC_MortalityBasisArrays which has the query attached as .txt file.
4. Each GIC is mapped to unique vintages, so 700 GICs in request xml is mapped to 700 vintages.
5. The 700 vintages are converted into xml block and put into the query such that the XMLblock max string length is 4000 i.e Each iteration will be responsible for creating xml block with 4000 string length, GICs not included in this block will be taken care of in the next iteration.

Changes

Cause

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