My Oracle Support Banner

PQSCGRTN - Screen Takes Longer Time To Process A Record. (Doc ID 3075166.1)

Last updated on MARCH 05, 2025

Applies to:

Oracle Banking Payments - Version 14.7.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 14.7.0.0.0 version, Implementation Support

ACTUAL BEHAVIOR
---------------
PQSCGRTN - Screen takes longer time to process a record.

Please note that the screen takes longer time to process say avg 8-10 seconds to navigate to another record to process. Also in this screen, the bulk retry is also not supported hence cant select multiple records as well from this screen.
Enclosed logs and AWR

[20250212 08:37:17 542]SummaryQueryOracleDAO.replaceRegExpMetaChar-->fieldValue = DD_CLG
[20250212 08:37:17 542]SummaryQueryOracleDAO.replaceRegExpMetaChar-->fieldValue = 2024-10-30
[20250212 08:37:21 423]SummaryQueryOracleDAO.buildSummaryQuery-->No Of Records: 135
[20250212 08:37:21 423]SummaryQueryOracleDAO.buildSummaryQuery-->Fetch Size: 15

[20250212 08:37:21 425]SummaryQueryOracleDAO.select-->Executing sumamry query
[20250212 08:37:26 559]SummaryQueryOracleDAO.getSummaryPrimaryKeys-->strTableName = BLK_CG_RETURN_QUEUE

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


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