Performance Issue With Expenditure Inquiry All for Supplier Name in Form PAXTRAPE and View PA_EXPEND_ITEMS_ADJUST2_V (Doc ID 2101075.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Costing - Version 12.1.3 to 12.2.5 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

There is a performance concern when a user performs a query by Supplier Name using Expenditure Inquiry PAXTRAPE form.
This Supplier Name search takes 10+ minutes, where previously the same search took 5 seconds.

Navigation:
Expenditure Inquiry --> All --> Supplier Tab --> Supplier Name = xxxxx --> Find

Changes

After applying Patch 20203366:12.1.0 Oracle E-Business Suite Release 12.1.3+ Recommended Patch Collection 3 [RPC3]

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms