My Oracle Support Banner

EGL9.2:Journal Post Performance Issue (Doc ID 2832018.1)

Last updated on JUNE 25, 2023

Applies to:

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


Journal Post is running about 20 hours having slowness in the sql below:

SELECT a.ledger, a.account, a.altacct, a.book_code, a.currency_cd, a.foreign_currency, SUM(a.foreign_amount), a.open_item_key, TO_CHAR(MAX(a.journal_date),'YYYY-MM-DD'), SUM(a.monetary_amount)
FROM ps_open_item_gl a, ps_open_item_tao4 t
WHERE a.business_unit = t.business_unit AND a.ledger = t.ledger AND a.open_item_key = t.open_item_key AND a.open_item_status = 'O' AND a.foreign_currency = t.foreign_currency AND t.process_instance = 9541907
GROUP BY a.ledger, a.account, a.altacct, a.book_code, a.currency_cd, a.foreign_currency, a.open_item_key

Steps to Replicate:
1. Navigate to Main Menu >> General Ledger >> Journals >> Process Journals >> Post Journals and run Journal Post process - GL_JP
2. This is the very slow SQL - due to not-cleaning the size of OPEN_ITEM_TAO:


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

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