Optimizing Performance for PeopleSoft Cost Management Transactions

Perform this procedure in addition to the performance optimization procedure described in the section, "Optimizing Performance for All Source Transactions."

To optimize budget processor performance for PeopleSoft Cost Management transactions:

1. Access Application Designer and remove the DISTINCT operator from the view text for CM_KK_HDR2VW.

2. Add these indexes:

   Table	Index	Index Fields
   PS_CM_ACCTG_GRP_D	PSCCM_ACCTG_GRP_D	CM_SOURCE_RECORD, TRANSACTION_GROUP
   PS_CM_ACCTG_LINE	PSBCM_ACCTG_LINE	TRANSACTION_GROUP, BUSINESS_UNIT, DT_TIMESTAMP, INV_ITEM_ID, SEQ_NBR, ACCOUNTING_DT, DISTRIB_TYPE, BUDGET_HDR_STATUS, BUDGET_DT, KK_AMOUNT_TYPE, KK_TRAN_OVER_DTTM, KK_TRAN_OVER_FLAG, KK_TRAN_OVER_OPRID
   PS_CM_ACCTG_LINE	PSACM_ACCTG_LINE	BUSINESS_UNIT, INV_ITEM_ID, DT_TIMESTAMP, SEQ_NBR, BUSINESS_UNIT_GL, LEDGER, LEDGER_GROUP, TRANSACTION_GROUP

3. Compute statistics for the table PS_CM_ACCTG_LINE.