My Oracle Support Banner

Latch Free On Result Cache Blocks In FCUBS App (Doc ID 2620324.1)

Last updated on FEBRUARY 28, 2020

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, Implementation Support

ACTUAL BEHAVIOR
---------------
Latch free on result cache blocks in FCUBS app

EXPECTED BEHAVIOR
-----------------------
Lache implementation should be correct in queries

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

We have identified some queries that have lots of cached entries and minimal usage.
Please review if the result cache implementation is correct for the those queries.

1) "FCUBSINT"."CSPKS_FUNCTION_CACHE"::11."FN_GET_BIC_DIRECTORY_REC_FRC"#33b3f05f1eab5c5b #551
2) "FCUBSINT"."SWPKS_UTILS"::11."FN_GET_SW_TERMID_MAP_REC_FRC"#237ef748d40a702c #2752
3) "FCUBSINT"."CSPKS_FUNCTION_CACHE"::11."FN_CACHE_CCY_RATES_FRC"#c77afa7656a3d91f #1292
4) "FCUBSINT"."SMPKS"::11."FN_GET_CONTROLS

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
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.