Has anyone noticed a performance issue with GL_JP App Engine?
We have upgraded to PeopleSoft 9.2/PeopleTools 8.55. We are noticing that the GL_JP App Engine is running slower than the 9.1 COBOL process while processing a comparable amount of data. It is mostly happening when we first open the new period (we call it month open process). Just wondering if anyone else has seen this. We also upgraded to Oracle 12C.
When we do the Oracle AWR reports, the SQL that keeps showing up as taking up the most time is this:
MERGE /*+ LEADING (T) */ INTO PS_LEDGER L USING ( SELECT * FROM PS_JP_PST1_TAO4 ORDER BY BUSINESS_UNIT, LEDGER, ACCOUNT, ALTACCT, DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, PROJECT_ID, BOOK_CODE, GL_ADJUST_TYPE, DATE_CODE, CURRENCY_CD, STATISTICS_CODE, FISCAL_YEAR, ACCOUNTING_PERIOD) T ON (L.BUSINESS_UNIT = 'xx' AND L.BUSINESS_UNIT = T.BUSINESS_UNIT AND L.LEDGER = T.LEDGER AND L.ACCOUNT = T.ACCOUNT AND L.ALTACCT = T.ALTACCT AND L.DEPTID = T.DEPTID AND L.OPERATING_UNIT = T.OPERATING_UNIT AND L.PRODUCT = T.PRODUCT AND L.FUND_CODE = T.FUND_CODE AND L.CLASS_FLD = T.CLASS_FLD AND L.PROGRAM_CODE = T.PROGRAM_CODE AND L.BUDGET_REF = T.BUDGET_REF AND L.AFFILIATE = T.AFFILIATE AND L.AFFILIATE_INTRA1 = T.AFFILIATE_INTRA1 AND L.AFFILIATE_INTRA2