My Oracle Support Banner

ECA: Performance Problem When Searching Using Contract Number in the Page as Incurred Acctg Lines - Customer Contracts > Review Revenue > As Incurred Acctg Lines (Doc ID 2599782.1)

Last updated on DECEMBER 23, 2019

Applies to:

PeopleSoft Enterprise FIN Contracts - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Performance issues are observed when Contract Number as the search critieria in Page Navigation - Customer Contracts > Review Revenue > As Incurred Acctg Lines

The following SQL is causing performance problem


The UPPER function for changing the contract number case in the above SQL is causing poor performance.

Replication Steps:

1. Navigate to Customer Contracts > Review Revenue > As Incurred Acctg Lines
2. Enter values for search criteria for GL BU, Ledger, PC BU and Contract and search



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
References


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