Last updated on SEPTEMBER 14, 2016
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
Customer reported that from time to time they're facing performance problems with GL_JEDIT or GL_JEDIT_0 processess.
In such case the process logs the warining messages like:
WARNING: NO DEDICATED INSTANCES AVAILABLE FOR JL_JPROC_TAO - USING BASE TABLE.
that there are no dedicated instances available and uses standard set of temp tables.
Then the process stops on setp GL_JPROC.DD020.LOCKJRNL on the following sql statement:
SET jrnl_hdr_status = 'N',
process_instance = 1792883,
journal_locked = 'Y',
jrnl_balance_stat = 'V',
control_total_stat = 'V',
jrnl_edit_err_stat = 'V',
susp_recon_status = '0',
jrnl_process_reqst = 'N',
budget_hdr_status = 'V'
WHERE journal_locked <> 'Y'
AND unpost_seq = 0
AND business_unit_iu = 'NL033'
AND journal_date >= TO_DATE ('2011-10-10', 'YYYY-MM-DD')
AND journal_date <= TO_DATE ('2099-12-31', 'YYYY-MM-DD')
AND jrnl_hdr_status IN ('N', 'E')
AND NOT EXISTS (
FROM ps_jl_jproc_tao hiu
WHERE hiu.business_unit_iu = ps_jrnl_header.business_unit_iu
AND hiu.business_unit <> ps_jrnl_header.business_unit
AND hiu.journal_id = ps_jrnl_header.journal_id
AND hiu.journal_date = ps_jrnl_header.journal_date)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms