EGL: How Can the Performance For Journal Generation of Payroll Entries at Step FS_JGEN_JRNL.uDrill be Improved?
Last updated on SEPTEMBER 27, 2017
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
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
GL_DISTRIB_STATUS = 'J' AND ACCOUNT=:7 AND DEPTID=:8 AND FUND_CODE=:9
PROGRAM_CODE=:10 AND PROJECT_ID=:11 AND FOREIGN_CURRENCY=:12 AND
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