EEX 9.1: EX_TRAN_PRCS Bad Performance At EX_LIBRARY.CF_INS.CF_INS_2 And EX_LIBRARY.CF_INS.CF_INS_3 Application Engine Program Steps (Doc ID 1912088.1)

Last updated on JULY 14, 2017

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

ISSUE:

The Expenses Processing Application Engine Program (EX_TRAN_PRCS) is experiencing drastic performance degradation when handling large volume of transaction data in the below 2 listed Steps:

  - EX_LIBRARY.CF_INS.CF_INS_2 (SQL Select Statement)
  - EX_LIBRARY.CF_INS.CF_INS_3 (SQL Select Statement)

On a normal business day, such program will complete within 3 minutes time frame. However, in the days the volume of data is specially high, the night batch program will take over 2 hours. This is affecting the remainder of processes that also need to be completed during the night batch job.

The Expenses Processing Run Control ID is having selected the following options: Stage Payments, Post Liabilities, and Post Payments. It is important to note that the affected 2 Steps involve Inter Unit Accounting Processing.

REPLICATION STEPS:

  - Log into the FSCM Online Application as User ID VP1
  - Navigate to: Travel and Expenses > Process Expenses > Expense Processing
  - Create a brand new Run Control ID, and select the below options:
       - Stage Payments
       - Post Liabilities
       - Post Payments
       - All Business Units = Y
  - Launch the program, and confirm that performance is degrading in the mentioned AE Steps

BUSINESS IMPACT:

The Expenses Processing Application Engine Program (EX_TRAN_PRCS) is launched on a nightly batch within a defined JOB in the system. As it takes over 2 hours to complete, the rest of the programs that are scheduled in the Job Definition are executed much later, and sometimes they are not yet completed at the beginning of the next business day.

EXPECTED BEHAVIOR:

Although sometimes the system may have a higher volume of transaction data to process, the time frame for completion of the Expenses Processing Application Engine Program (EX_TRAN_PRCS) should be acceptable, not with such performance degradation.
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms