Performance Issue in Upcoming Payments Inquiry Transaction due to High Query Cost in Underlying Query of FCC_VW_INSTRUCTION_ALL
(Doc ID 2709070.1)
Last updated on MAY 12, 2022
Applies to:
Oracle Banking Digital Experience - Version 18.1.0.0.0 to 18.1.0.0.0 [Release 18]Information in this document applies to any platform.
Symptoms
ACTUAL BEHAVIOR
---------------
When trying to view records for upcoming Payments to cancel the same, the records are not being fetched
and there is a performance lag observed.
EXPECTED BEHAVIOR
-----------------------
When trying to view the records for upcoming Payments, the records should be fetched in acceptable time limits
and there should be no performance lag observed.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login as a Retail User from OBDX (Oracle Banking Digital Experience) Application
2. Go to Upcoming Payments and search for the upcoming payments
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see their upcoming payments.
Changes
The issue is caused if user has a significant number of Standing Instructions.
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 |