Optimizing Budget Processor Performance

To optimize budget processor performance for all applications that you have enabled to feed source transactions into budget processor:

1. Recompute statistics for these tables when the row count of these tables exceeds 3,000 rows. If the row count is less than 3,000, then delete statistics from the tables.

   1. PS_LEDGER_KK

   2. PS_KK_SOURCE_LN

2. Recompute statistics for the PS_KK_SOURCE_HDR table when the row count exceeds 10,000 rows.

   If the row count is less than 10,000 rows then delete statistics from the table.

3. Recompute statistics on the Product KK_SOURCE_HDR table if the row count exceeds 10,000 rows. . The table name can be found on the Source Transaction page in the KK Source Header Record field as depicted below.

   This example illustrates the fields and controls on the Source Transactions - Definition page.

   

   Note: If the row count is less than 10,000 rows, you can delete statistics from the table.

4. Delete statistics from PS_BP_CF_TAO.

5. Delete statistics from PS_BP_XCF_TAO, and PS_BP_XCF2_TAO.

6. Analyze SYS scheme tables (all system tables) to improve parsing time.

7. Add these indexes:

   Table	Index	Index Fields
   PS_GL_ACCOUNT_TBL	PSFGL_ACCOUNT_TBL	SETID, STATISTICS_ACCOUNT, EFF_STATUS, ACCOUNT_TYPE, ACCOUNT, EFFDT
   PSRECFIELD	PSGPSRECFIELD	RECNAME, SUBRECORD, FIELDNAME, FIELDNUM, CURCTLFIELDNAME, USEEDIT
   PSTREELEVEL	PSBTREELEVEL	SETID, TREE_NAME, TREE_LEVEL, EFFDT, TREE_LEVEL_NUM
   PSTREENODE	PSGTREENODE	(1) TREE_NODE, SETID, TREE_NAME, EFFDT, TREE_NODE_NUM (2) SETID, TREE_NAME, EFFDT, TREE_NODE_NUM, TREE_NODE_NUM_END
   PSTREELEAF	PSCTREELEAF	SETID, TREE_NAME, EFFDT, RANGE_FROM, RANGE_TO, TREE_NODE_NUM

8. Update statistics on these tables: PSTREELEVEL, PSTREENODE, PSTREELEAF.

See also PeopleTools: PeopleSoft Application Designer

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.

In addition to the optimization procedure described in the section, "Optimizing Performance for All Source Transactions," add this index to support parallel running of the upgrade process for Purchasing:

In addition to the optimization procedure described in the section, "Optimizing Performance for All Source Transactions," add this index to support parallel run of the upgrade process for VOUCHER data conversion:

Follow this procedure to optimize budget processor performance for General Ledger transactions. Perform this procedure in addition to the performance optimization procedure described in the section, "Optimizing Performance for All Source Transactions."

Create this index: