EGL: Performance with Journal Generator at Section FS_JGEN_JRNL.pCurr.gCurr.SQL for Expense Accounting Entries (Doc ID 1910477.1)

Last updated on MAY 13, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Journal Generator runs for over 9 hours for Expense accounting entries


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Main Menu > General Ledger > Journals > Subsystem Journals > Generate Journals
2. Generate Journals for Expense accounting entries
3. Process runs for over 9 hours and hangs at following section

FS_JGEN_JRNL.pCurr.gCurr.SQL

INSERT INTO PS_JGEN_CURR_TAO4 (PROCESS_INSTANCE, FOREIGN_CURRENCY)
 SELECT DISTINCT 935432, FOREIGN_CURRENCY
   FROM PS_EX_ACCTG_LINE
  WHERE     (APPL_JRNL_ID = 'EXPAYMENT' OR APPL_JRNL_ID = ' ')
        AND BUSINESS_UNIT_GL = 'US001'
        AND BUSINESS_UNIT = 'US001'
        AND (LEDGER_GROUP = ' ' OR LEDGER_GROUP = 'ACTUALS')
        AND GL_DISTRIB_STATUS = 'N'
        AND ACCOUNTING_DT >= TO_DATE ('2010-01-01', 'YYYY-MM-DD')
        AND ACCOUNTING_DT <= TO_DATE ('2014-06-30', 'YYYY-MM-DD')


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