EGL: Performance Issue with FS_JGEN_JRNL.uDrill.uDrill While Processing PC Rows (Doc ID 824643.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

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

Symptoms

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
CHARTFIELD2=:19

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