EGL: How Can the Performance For Journal Generation of Payroll Entries at Step FS_JGEN_JRNL.uDrill be Improved? (Doc ID 635984.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.4 and later
Information in this document applies to any platform.
SPECIFIC TO: Enterprise, Financials, General Ledger

This document was previously published as Customer Connection Solution 200951903




Symptoms


The Journal Generator processing for the HR_ACCTG_LINE entries was taking over 10 hours to run. 

After reviewing the app engine trace it was determine that 90% of the processing time was taking place when executing the following statement:

-- 17.37.22 .......................(FS_JGEN_JRNL.uDrill.uDrill) (SQL)
UPDATE PS_HR_ACCTG_LINE SET JOURNAL_ID = :1, JOURNAL_DATE =
TO_DATE(:2,'YYYY-MM-DD'), FISCAL_YEAR = :3, ACCOUNTING_PERIOD = :4,
GL_DISTRIB_STATUS = 'D', JOURNAL_LINE = :5 WHERE PROCESS_INSTANCE = :6
AND
GL_DISTRIB_STATUS = 'J'  AND ACCOUNT=:7 AND DEPTID=:8 AND FUND_CODE=:9
AND
PROGRAM_CODE=:10 AND PROJECT_ID=:11 AND FOREIGN_CURRENCY=:12 AND
CURRENCY_CD=:13

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