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