PAXCARVW: Performance Issue When Querying Capital Projects Based on Project Status After Upgrading to 19c Database (Doc ID 3074730.1)

Last updated on MARCH 04, 2025

Applies to:

Symptoms

After an upgrade of the Database to version 19c, performance issue occurs in the Capital Projects form when querying projects based on project status.
It's taking around 2 minutes to get the data. Prior to the upgrade, it takes around 10 seconds to return the same set of data.

Trace file shows the most costly query below:

SELECT PROJECT_NUMBER,PROJECT_NAME,EXPENSED,CIP_COST,CAPITALIZED_COST,
TOTAL_COSTS,CAPITALIZABLE_COST,PROJECT_ID,PROJECT_ORGANIZATION,
PROJECT_STATUS_CODE,PROJECT_TYPE,INTERFACE_COMPLETE_ASSET_FLAG,
INTERFACE_ASSET_COST_CODE,ASSET_ALLOCATION_METHOD,CAPITAL_EVENT_PROCESSING,
CAPITAL_COST_TYPE_CODE,BURDEN_AMT_DISPLAY_METHOD,TOTAL_BURDEN_FLAG,ROW_ID,
LAST_UPDATE_DATE,CREATION_DATE,LAST_UPDATED_BY,CREATED_BY,LAST_UPDATE_LOGIN,
UPDATE_ALLOWED,VIEW_LABOR_COSTS_ALLOWED
FROM
PA_CAPITAL_PROJECTS_V WHERE (PROJECT_STATUS_CODE LIKE :1) order by
project_number

Steps
=====
1. Using a Projects responsibility
2. Navigate: Capitalization > Capital Projects
3. In the Find Capital Projects screen, search projects by Project Status, i.e. Status = Approved
4. Click Find

Changes

Upgrade database to 19c.

Cause

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