Configuring Temporary Tables for Batch Processing

When you run batch 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 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 need to 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 each process uses.

Specify how many temporary table instances to dedicate for each of the following batch processes that can run in parallel in General Ledger:

  • Allocations (FS_ALLC)

  • Combo Edit Build (FS_CEBD)

  • ChartField Combination Editing (FS_CEDT_PROC)

  • Journal Generator (FS_JGEN)

  • ADB Calculation (GL_ADB_CALCX)

  • Post Daily Balance (GL_ADB_POST)

  • Journal Edit (GL_JEDIT)

  • Journal Copy (GL_JRNL_COPY)

  • Flat File Journal Import (GL_JRNL_IMP)

  • Flat File Ledger Import (GL_LED_IMP)

  • Standard Journal Entry (GL_SJE)

  • Cash Flow Statement (FR_CALCULATE)

  • Commitment Control Budget Processor (FS_BP)

  • Commitment Control Notification (KK_NTFY_WF)

  • Closing (GLPCLOSE, GL_YC, or both)

  • Consolidations (GLPOCONS)

  • Equitization (GLPQEQTZ)

  • Journal Post (GL_JP)

  • Multicurrency Processing (FSPCCURR, FS_MC, or both)

  • Open Item Reconciliation (GL_OI_RECON)

  • Summary Ledger (GL_SUML_PROC)

Note: The processes that are listed here are the main general ledger processes (Application Engine (AE) or COBOL). General Ledger also has some AE or SQR processes that are mainly for loading data to do government reporting ( FACTS I, FACTS II, SFxxx). Because these are more like a report than a process, they are not included in this list.

The PeopleTools documentation discusses the usage of temporary tables in detail and describes how to specify the number of instances.

If you run any of the General Ledger AE or COBOL processes, also configure the temporary tables for those processes. The PeopleSoft PeopleTools documentation discusses how to do this in detail.

See PeopleTools Documentation: PeopleSoft Application Engine