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, PeopleSoft PeopleTools enables you to dedicate specific instances of temporary tables for each process. When the 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.

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

• Expenses Transaction Processing Driver (EX_TRAN_PRCS).

  Two or more Application Engine programs called by the Expenses Transaction Processing Driver share these temporary tables. These temporary tables are defined for this Application Engine program to avoid creating extra instances of the table on the database.

  The Expenses Transaction Processing Driver process uses these temporary tables:

  • BU_OPT_EX_TAO

  • EX_ACCTG_TMP

  • EX_ACCTLN_TAO

  • EX_AD_RST_TAO

  • EX_ALLOC_TAO

  • EXP_BUBANK_TAO

  • EX_CA_UPD_TAO

  • EX_DSTACT_TAO

  • EX_EE_PMT_TAO

  • EX_ER_UPD_TAO

  • EX_SH_RST_TAO

  • EX_SHTADV_TAO

  • EX_SUMEMP_TAO

  • EXACCTI2_TAO

  • EXACCTIU_TAO

  • EXADVKEY_TAO

  • EXAIRTKT_TAO

  • EXBUSET2_TAO

  • EXBUSETID_TAO

  • EXEMPBNK_TAO

  • EXEMPLID_TAO

  • EXEMPPMT_TAO

  • EXEMPPMT2_TAO

  • EXSHTKEY_TAO

  • EXVNDPMT_TAO

  • IU_TRAN_TAO

  • VAT_IU_PR_TAO

• Stage Payments (EX_STAGE_PMT)

  The Stage Payments process uses these temporary tables:

  • EX_ADVLN_TAO

  • EX_ADVLSS_TAO

  • EX_STGSHT_TMP

• Post Liabilities (EX_POST_LIAB)

  The Post Liabilities process uses these temporary tables:

  • EX_ADV_TAO

  • EX_SHEET_TAO

  • EXVATACCT_TAO

  • EXVTACCTA_TMP

  • EXVTACCTB_TMP

  • VAT_IU_EX_TAO

• Post Payments (EX_POST_PMT)

  The Post Payments process uses these temporary tables:

  • EX_AD_DST_TAO

  • EX_AD_PST_TAO

  • EX_SH_DST_TAO

  • EX_SH_PST_TAO

  • EX_SHTALC_TAO

• Cancel Payments (EX_CANCL_PMT)

  The Cancel Payments process uses these temporary tables:

  • EX_BUBNK2_TAO

  • EXCAN1_TAO

  • EXCAN2_TAO

  • EXCAN4_TAO

  • EXCANADV_TAO

  • EXCANAUT2_TAO

  • EXCANAUTO_TAO

  • EXCANPMT_TAO

  • EXINTR_CR_TAO

  • EXINTR_DB_TAO

• Expenses Synchronization Payments (EX_SYNC_PMT)

  The PeopleSoft Expenses Synchronization Payments process uses the EX_SH_PMT_TAO temporary table.

• Travel Authorization Cancel, Reverse, and Rollover (EX_BCHK_AUTH)

  The Cancel, Reverse, and Rollover process uses the EX_TAUTH_TAO temporary table.

• DCAA Notifications (EX_DCAA_NTFY)

  The DCAA Notifications process uses the EX_DCAA_TAO temporary table.

• Travel Profile Export (TV_PROF_EXP)

  The Travel Profile Export process uses these temporary tables:

  • TV_EXP_TRVLR

  • TV_EXP_TVGRP

  • TV_EXPADD_TAO

  • TV_EXPCHG_TAO

  • TV_EXPDEL_TAO

• Travel Profile Import (TV_PROF_IMP)

  The Travel Profile Import process uses the TV_PRFIMP_TAO temporary table.

The PeopleSoft 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 PeopleSoft General Ledger COBOL processes, also configure the temporary tables for those processes. The PeopleSoft General Ledger discusses how to do this in detail.

See Also: PeopleTools: Application Engine