My Oracle Support Banner

Performance Issue - Rate Schedules (Doc ID 2415317.1)

Last updated on FEBRUARY 17, 2019

Applies to:

Oracle Project Costing - Version 12.2.6 and later
Information in this document applies to any platform.


On : 12.2.6 version, Costing Setup

Performance Issue - Rate Schedules

Upgraded to 12.2.6 and trying to update Resource Class Rate Schedule using a global responsibility. Query performance within the Rate Schedule seems to extraordinarily slow. For example, when the rate schedule is loaded and the user does a View > Record > Last. Takes the form about 10 minutes to pull in 140 records.

Query up a Rate Schedule
#IS Null Query of the Data
View > Record > is timed into 2 section. How long it took to pull the first 100 records, then how long it took to pull the remaining records.
At the bottom of the Test Instance column, their is also a timed result for a File > Export.

This is all on the Setup > Costing > Expenditures > Rate Schedules form.


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

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