My Oracle Support Banner

TFS 68736: ACHOFFCU: Statement Generation Is Taking A Lot Of Time During Eod. (Doc ID 2569494.1)

Last updated on AUGUST 11, 2019

Applies to:

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

Symptoms

On : 12.4.0.0.0 version, Production Support-SET

ACTUAL BEHAVIOR
---------------
Statement generation is taking a lot of time during EOD
 

EXPECTED BEHAVIOR
-----------------------
Tuning of statements generation should not be delayed

STEPS
-----------------------
All of them have branch condition in the WHERE clause, apart from those two in ACPKS_STMT:


(1) line 15563:

 SELECT RELATED_ACCOUNT
  INTO L_CL_ACC
  FROM CAVWS_ENTRIES
  WHERE TRN_REF_NO = PACENT.TRN_REF_NO
  AND AC_NO = PACENT.AC_NO;


(2) line 23594:

SELECT *
  INTO L_ACVWS_ALL_AC_ENTRIES
  FROM CAVWS_ENTRIES
  WHERE TRN_REF_NO = PREFNO
  AND EVENT_SR_NO = PESN
  AND AC_NO = PACENT.AC_NO;


Condition is missing: AND AC_BRANCH = PACENT.AC_BRANCH

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users are facing performance problem during EOD

Changes

 

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.