My Oracle Support Banner

SIAUTOPR Batch Is Consuming A Lot Of Time During Daily EOD (Doc ID 2688580.1)

Last updated on JULY 08, 2020

Applies to:

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

Symptoms

On : 12.0.2 version, Production Support-SET

ACTUAL BEHAVIOR
---------------
SIAUTOPR batch is taking long time for completion

EXPECTED BEHAVIOR
-----------------------
SIAUTOPR batch should not take long time for completion


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, EOD timing gets increase.

Changes

 Indexes shared on table-SITB_CYCLE_DUE_EXEC & SITB_CONTRACT_MASTER, CFTB_CONTRACT_CHARGES, ISTB_CONTRACTIS

Purging of duplicate cftb_contract_charges done for SI module .

Modified the cursor to process the SI Autobook batch, based on pickedup ESN.

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


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