R12: PA: Index On Table PA_COST_DISTRIBUTION_LINES_ALL On PA_PERIOD_NAME And EXPENDITURE_ITEM_ID
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.
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?
CREATE INDEX XXPA_COST_DISTRIB_LINES_N2 ON PA_COST_DISTRIBUTION_LINES_ALL ( PA_PERIOD_NAME, EXPENDITURE_ITEM_ID );
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