EGL: Performance with Journal Generator at Section FS_JGEN_JRNL.pCurr.gCurr.SQL for Expense Accounting Entries
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.
Journal Generator runs for over 9 hours for Expense accounting entries
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
INSERT INTO PS_JGEN_CURR_TAO4 (PROCESS_INSTANCE, FOREIGN_CURRENCY)
SELECT DISTINCT 935432, FOREIGN_CURRENCY
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')
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