My Oracle Support Banner

FCUBS | STTB_REQ_MASTER - EXT_ASYNCCALL WE CANNOT USE BLOCK_SIZE MORE THAN 1000 (Doc ID 3008554.1)

Last updated on MARCH 26, 2024

Applies to:

Oracle FLEXCUBE Universal Banking - Version 14.6.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 14.6.0.5.0 version, Implementation Support
Patch set : 14.6.0.5.0 Maintenance line

ACTUAL BEHAVIOR
-----------------------------
FCUBS | STTB_REQ_MASTER - EXT_ASYNCCALL WE CANNOT USE BLOCK_SIZE MORE THAN  thousand

Not able to process Replication if the Block Size maintained more than  thousand. If the block size is more than  thousand then system will throw the error since oracle itself have limitation  for the in clause variables in SQL query.

EXPECTED BEHAVIOR
--------------------------------
We want to process twenty five thousand  to fifty thousand records at a time.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Maintain the Block Size more than  thousand in STTM_JOB_PARAM table for the Job EXT_ASYNCCALL
2) Create the Utilizations more than  thousand
3) Start EXT_ASYNCCALL job.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot process Replication if the Block Size maintained more than  thousand.

Changes

Changed the SQL query based on NEW_PROCESS_STATUS column. While picked the Message id updating as New_PROCESS_STATUS as G so that we can pick only the related entries while pickup pending entries.

Cause

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
Symptoms
Changes
Cause
Solution
References


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