SIAUTOPR Batch Is Consuming A Lot Of Time During Daily EOD
(Doc ID 2688580.1)
Last updated on OCTOBER 21, 2021
Applies to:
Oracle FLEXCUBE Universal Banking - Version 12.0.2 and laterInformation 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 |