Configuring Temporary Tables for Batch and Online Processing

When you run Application Engine processes in parallel, you risk data contention and deadlocks on temporary tables. To avoid this, PeopleTools enables you to dedicate specific instances of temporary tables for each process. When a PeopleSoft Application Engine manages a dedicated temporary table instance, it controls the locking of the table before use and the unlocking of the table after use.

When you decide how many temporary table instances to dedicate for a process, consider the number of temporary tables that the process uses. More instances result in more copies of the temporary tables on the system. For example, if a process uses 25 temporary tables and you have 10 instances for a process, you will have 250 temporary tables on the system.

If you run processes in parallel and all of the dedicated temporary table instances are in use, the performance of the process decreases. You must find a balance that works for your organization.

Note: When you specify the number of instances, PeopleSoft Application Designer displays a list of the temporary tables for the process. Use the list to determine how many temporary tables that each process uses.

Specify how many temporary table instances to dedicate for each of these Application Engine processes in PeopleSoft Project Costing:

  • PC_AM (Asset Management Interface)

  • PC_AP_TO_PC (Payables to Project Costing)

  • PC_BUD_SUM (Refresh Budget Summary)

  • PC_BUDGET_IN (Budget Loader)

  • PC_COPY_AE (Transaction Copy)

  • PC_CPY_AELIB (Template Application Library)

  • PC_CRTMPL_AE (Create Project from Template)

  • PC_DEL_UTIL (Project Delete Utility)

  • PC_EX_TO_PC (Expenses to Project Costing)

  • PC_EXPRET_AM (Express Retirement)

  • PC_EXPRSS_AM (Express Capitalization)

  • PC_FC_CALC (Forecast Variance Calculation)

  • PC_FND_DIST (Funds Distribution)

  • PC_FUND_RES (Funds Finalization)

  • PC_IMTMPL_AE (Import from Template)

  • PC_IN_TO_PC (Inventory to Project Costing)

  • PC_INTFEDIT (Load Third-Party Transactions)

  • PC_KK_TO_PC (Commitment Control to Project Costing)

  • PC_MULTI_CUR (Multicurrency Conversion)

  • PC_PO_TO_PC (Purchasing to Project Costing)

  • PC_POADJUST (Purchasing Adjustment)

  • PC_PRICING (Pricing)

  • PC_PROFIT_AE (Project Profitability Calculation)

  • PC_REJECT_AM (Reject Pending Assets)

  • PC_RESADJUST (Transaction Adjustment)

  • PC_RETIRE_AM (Asset Management Asset Retirement)

  • PC_REVERS_AM (Reverse Distributed Assets)

  • PC_RPO (Report Summarization)

  • PC_SUM_RFSH2 (Refresh Project Transaction Summary Table)

  • PC_TO_KK (Project Costing to Commitment Control)

  • PC_SVTMPL_AE (Save as Template)

  • PC_SUM_RFSH (Refresh Summary Tables)

  • PC_VALN_CALC (Project Valuation Calculation)

  • PC_VAR_PRICE (Variance Pricing)

  • PC_WM_TO_PC (Maintenance Management Tools Usage)

  • PSA_ACCTGGL (Process Project Accounting)

  • PSA_SHARING (Sharing)

The PeopleTools documentation discusses the use of temporary tables in detail and discusses how to specify the number of instances. See the product documentation for PeopleTools: Application Engine

If you run any of the PeopleSoft General Ledger COBOL processes, configure the temporary tables for those processes as well.