R12: PAXCARVW - Split Asset Line Performance

(Doc ID 2362982.1)

Last updated on FEBRUARY 19, 2018

Applies to:

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

Symptoms

PAXCARVW, Performance issue

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_NUMBER=:1) order by project_number



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