My Oracle Support Banner

Payment Portal Zone C1-PAYPTL Query Needs Performance Tuning (Doc ID 2434527.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.6.0.1.0 to 2.6.0.1.0 [Release 2]
Information in this document applies to any platform.

Symptoms

On :ORMB 2.6.0.1.0 version, PY - Payment

Payment Portal Zone C1-PAYPTL Query Needs Performance Tuning

ACTUAL BEHAVIOR
---------------
While investigating the performance issues faced by the online application users production environment, the following query was identified as one of the bottlenecks by the system administrator.

Payment Portal Zone: C1-PAYPTL
This Zone is used in the Business Service ‘C1-FetchPayEventDetails’.


EXPECTED BEHAVIOR
-----------------------
Reported query has better performance.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. calling the Base Navigation option for the Payment Portal for a given Payment Event ID from a custom zone (Billed vs Paid).

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Performance issue.

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.