My Oracle Support Banner

EGL8.9+: Journal Generator Performance Problem at FS_JGEN_JRNL.UDRILL.UDRILL (Doc ID 655385.1)

Last updated on FEBRUARY 05, 2019

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.9 to 9.2 [Release 8.9 to 9]
Information in this document applies to any platform.

Symptoms

Issue:
-------

While running Journal Generator process from AM and facing performance problems at FS_JGEN_JRNL.UDRILL.UDRILL. The status of the process in still showing as 'Processing'.

Following is the SQL at FS_JGEN_JRNL.UDRILL.UDRILL:

-- 18.30.29 .........................(FS_JGEN_JRNL.uDrill.uDrill) (SQL)
UPDATE PS_DIST_LN_JG_VW SET JOURNAL_ID = :1, JOURNAL_DATE = :2, FISCAL_YEAR = :3, ACCOUNTING_PERIOD = :4, GL_DISTRIB_STATUS = 'D', JOURNAL_LINE = :5 WHERE PROCESS_INSTANCE = 35841 AND GL_DISTRIB_STATUS = 'J'  AND FOREIGN_AMOUNT >=0 AND PROJECT_ID=:6 AND ACCOUNT=:7 AND ALTACCT=:8 AND DEPTID=:9 AND OPERATING_UNIT=:10 AND PRODUCT=:11 AND AFFILIATE=:12 AND LEDGER=:13 AND CURRENCY_CD=:14 AND FOREIGN_CURRENCY=:15


Application of bug  11342676 did not improve performance.



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.