Latch Free On Result Cache Blocks In FCUBS App
(Doc ID 2620324.1)
Last updated on JUNE 21, 2021
Applies to:
Oracle FLEXCUBE Universal Banking - Version 12.4.0.0.0 and laterInformation 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 |