EGL: Performance Issue with FS_JGEN_JRNL.uDrill.uDrill While Processing PC Rows
(Doc ID 824643.1)
Last updated on DECEMBER 12, 2019
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.
*** updated for relevance 19-APR-2019 ***
Journal Generator (FS_JGEN) process takes 2 days to successfully process PC (Project Costing) fee rows. A review of the application engine trace shows that the process hangs at the step FS_JGEN_JRNL.uDrill.uDrill:
UPDATE PS_CA_ACCTG_LN_PC 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 = 9224992
AND GL_DISTRIB_STATUS = 'J' AND BUSINESS_UNIT_PC=:6 AND PROJECT_ID=:7 AND
ACTIVITY_ID=:8 AND CURRENCY_CD=:9 AND FOREIGN_CURRENCY=:10 AND ACCOUNT=:11
AND DEPTID=:12 AND OPERATING_UNIT=:13 AND FUND_CODE=:14 AND AFFILIATE=:15 AND
AFFILIATE_INTRA1=:16 AND AFFILIATE_INTRA2=:17 AND CHARTFIELD1=:18 AND
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document