R12: PA: Index On Table PA_COST_DISTRIBUTION_LINES_ALL On PA_PERIOD_NAME And EXPENDITURE_ITEM_ID

(Doc ID 2389416.1)

Last updated on APRIL 20, 2018

Applies to:

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

Goal

Performance issues are encountered in a custom process to retrieve PA related details. For that, the driving table is PA_COST_DISTRIBUTION_LINES_ALL and column is PA_PERIOD_NAME and column EXPENDITURE_ITEM_ID is also required for joins/fetching details from other related tables.

There is not any index on column PA_PERIOD_NAME of the table. Please confirm if a custom composite index may be created on column PA_PERIOD_NAME and EXPENDITURE_ITEM_ID?

Script example:

CREATE INDEX XXPA_COST_DISTRIB_LINES_N2 ON PA_COST_DISTRIBUTION_LINES_ALL ( PA_PERIOD_NAME, EXPENDITURE_ITEM_ID );
 

Solution

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