EGL9.2 :GL_JP_PROC.HDRSEL.HDRSEL) (SQL) DOES NOT CHECK FOR JRNL_PROCESS_REQST causing performance issue post (Doc ID 2043172.1)

Last updated on AUGUST 12, 2015

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms


ISSUE

===========

The  insert statement  during GL_JP is inserting a large amount of historical data in the following tables PS_JHDR_SEL_TAO. Causing performance issue

Following is the SQL


INSERT INTO PS_JHDR_SEL_TAO14 (PROCESS_INSTANCE, BUSINESS_UNIT, JOURNAL_ID,
JOURNAL_DATE, UNPOST_SEQ, LEDGER_GROUP, JRNL_HDR_STATUS, JRNL_PROCESS_REQST,
REVERSAL_CD, REVERSAL_DATE, FISCAL_YEAR, ACCOUNTING_PERIOD) SELECT 2268734,
N.BUSINESS_UNIT, N.JOURNAL_ID, N.JOURNAL_DATE, N.UNPOST_SEQ, N.LEDGER_GROUP,
N.JRNL_HDR_STATUS, A.JRNL_PROCESS_REQST, N.REVERSAL_CD, N.REVERSAL_DATE,
N.FISCAL_YEAR, N.ACCOUNTING_PERIOD FROM PS_JRNL_HEADER A , PS_JRNL_HEADER N
WHERE N.BUSINESS_UNIT_IU=A.BUSINESS_UNIT AND
N.BUSINESS_UNIT<>N.BUSINESS_UNIT_IU AND N.JOURNAL_ID=A.JOURNAL_ID AND
N.JOURNAL_DATE=A.JOURNAL_DATE AND N.UNPOST_SEQ=A.UNPOST_SEQ


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms