Financial Management - PSFT (MOSC)

MOSC Banner

Has anyone noticed a performance issue with GL_JP App Engine?

edited Nov 1, 2016 9:17AM in Financial Management - PSFT (MOSC) 4 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center