EGL9.2: Performance Issue in 3rd Party Integration Edit Process (GL_FAIJEDIT) When Processing Huge Volume of Data for External Journals Coming From Oracle Fusion Accounting Hub. (Doc ID 2120582.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Functionality

ACTUAL BEHAVIOR
---------------
3rd Party Integration Edit process (GL_FAIJEDIT) is taking long time to process huge volume of data for external journals coming from Oracle Fusion Accounting hub.

EXPECTED BEHAVIOR
-----------------------
3rd Party Integration Edit process (GL_FAIJEDIT) should run within acceptable time frame.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Load large volume of external data in to FAH_ACCTG_HDR and FAH_ACCTG_LN.
  2. Navigate to General Ledger > External System Integration > 3rd Party Integration Edit and run the 3rd Party Integration Edit process (GL_FAIJEDIT).

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