My Oracle Support Banner

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

Last updated on APRIL 19, 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 ***

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.