My Oracle Support Banner

The Basel Batch Run Execution It's Taking Long Time. (Doc ID 3036502.1)

Last updated on JULY 29, 2024

Applies to:

Oracle Financial Services Basel Regulatory Capital Basic - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

On: 8.1.2 Version, OFS_BASEL

The performance issues in our main BASEL run execution.

When executing the batch it's taking more time and the please find the below PR2 task.log.

LOG FILE

-----------------------
Filename = PR2 Task.log
See the following error:

[21-06-24 10:40:36,407 GMT AM] [INFO ] [BACKEND] [GenericRDBMSRuleEngine] [executeRule] FINAL QUERY ::: MERGE INTO FSI_CAP_BANKING_EXPOSURES TT USING ( SELECT FSI_CAP_BANKING_EXPOSURES.N_ACCT_SKEY,FSI_CAP_BANKING_EXPOSURES.N_GAAP_SKEY,FSI_CAP_BANKING_EXPOSURES.N_RUN_SKEY,FSI_CAP_BANKING_EXPOSURES.N_CAP_APPROACH_TYPE_
[22-06-24 05:59:07,432 GMT AM] [DEBUG] [BACKEND] [GenericRDBMSRuleEngine] [executeRule] FINAL QUERY with execution time :::

[22-06-24 05:59:07,439 GMT AM] [DEBUG] [BACKEND] [GenericRDBMSRuleEngine] [executeRule] Query -> MERGE INTO FSI_CAP_BANKING_EXPOSURES TT USING ( SELECT FSI_CAP_BANKING_EXPOSURES.N_ACCT_SKEY,FSI_CAP_BANKING_EXPOSURES.N_GAAP_SKEY,FSI_CAP_BANKING_EXPOSURES.N_RUN_SKEY,FSI_CAP_BANKING_EXPOSURES.N_CAP_APPROACH_TYPE_
Time taken for query execution -> 69511016 milliseconds.
[22-06-24 05:59:07,441 GMT AM] [INFO ] [BACKEND] [GenericRDBMSRuleEngine] [executeRule] PostScript ::: null
[22-06-24 05:59:07,442 GMT AM] [INFO ] [BACKEND] [GenericRDBMSRuleEngine] [executeRule]
[22-06-24 05:59:07,453 GMT AM] [INFO ] [BACKEND] [GenericRDBMSRuleEngine] [executeRuleQuery] Number of rows affected ::: 237
[22-06-24 05:59:07,453 GMT AM] [INFO ] [BACKEND] [GenericRDBMSRuleEngine] [executeRuleQuery] --------------------------------------------------------------------------
[22-06-24 05:59:07,454 GMT AM] [INFO ] [BACKEND] [GenericRDBMSRuleEngine] [executeRuleQuery] ---End of Rule Execution Operations :Sat Jun 22 10:59:07 PKT 2024-----
[22-06-24 05:59:07,455 GMT AM] [INFO ] [BACKEND] [GenericRDBMSRuleEngine] [executeRuleQuery] --------------------------------------------------------------------------

Changes

 No 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


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