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.
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.
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
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