My Oracle Support Banner

EGL 9.2: Year-End Close GL_YC ABENDED at Step GL_JP_POST.hRetCode.ERROR With SQL Error 1654 (Doc ID 2409250.1)

Last updated on JUNE 08, 2018

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to run YE Close, the following error occurs.

ERROR
-----------------------


..................(GL_JP_POST.ProcLedg.Upsert) (SQL)
MERGE /*+ LEADING (T) */ INTO PS_LEDGER L USING ( SELECT * FROM
PS_JP_PST1_TAO6 WHERE PROCESS_INSTANCE = 16320988 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 = 'XXXXX' 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 =
T.AFFILIATE_INTRA2 AND L.CHARTFIELD1 = T.CHARTFIELD1 AND L.CHARTFIELD2 =
T.CHARTFIELD2 AND L.CHARTFIELD3 = T.CHARTFIELD3 AND L.PROJECT_ID =
T.PROJECT_ID AND L.BOOK_CODE = T.BOOK_CODE AND L.GL_ADJUST_TYPE =
T.GL_ADJUST_TYPE AND L.DATE_CODE = T.DATE_CODE AND L.CURRENCY_CD =
T.CURRENCY_CD AND L.STATISTICS_CODE = T.STATISTICS_CODE AND L.FISCAL_YEAR =
T.FISCAL_YEAR AND L.ACCOUNTING_PERIOD = T.ACCOUNTING_PERIOD AND
T.PROCESS_INSTANCE = 16320988) WHEN MATCHED THEN UPDATE SET PROCESS_INSTANCE
= 16320988 , DTTM_STAMP_SEC = CAST(SYSTIMESTAMP AS TIMESTAMP) ,
POSTED_TOTAL_AMT = L.POSTED_TOTAL_AMT + T.POSTED_TOTAL_AMT , POSTED_BASE_AMT
= L.POSTED_BASE_AMT + T.POSTED_BASE_AMT , POSTED_TRAN_AMT = L.POSTED_TRAN_AMT
+ T.POSTED_TRAN_AMT , POSTED_TOTAL_DR =L.POSTED_TOTAL_DR + T.POSTED_TOTAL_DR,
POSTED_TOTAL_CR = L.POSTED_TOTAL_CR + T.POSTED_TOTAL_CR ,POSTED_TRAN_DR =
L.POSTED_TRAN_DR + T.POSTED_TRAN_DR, POSTED_TRAN_CR = L.POSTED_TRAN_CR +
T.POSTED_TRAN_CR WHERE PROCESS_INSTANCE = 16320988 WHEN NOT MATCHED THEN
INSERT (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, POSTED_TOTAL_AMT,
POSTED_TOTAL_DR, POSTED_TOTAL_CR, POSTED_BASE_AMT, POSTED_TRAN_AMT,
POSTED_TRAN_DR, POSTED_TRAN_CR, BASE_CURRENCY, DTTM_STAMP_SEC,
PROCESS_INSTANCE) VALUES (T.BUSINESS_UNIT, T.LEDGER, T.ACCOUNT, T.ALTACCT,
T.DEPTID, T.OPERATING_UNIT, T.PRODUCT, T.FUND_CODE, T.CLASS_FLD,
T.PROGRAM_CODE, T.BUDGET_REF, T.AFFILIATE, T.AFFILIATE_INTRA1,
T.AFFILIATE_INTRA2, T.CHARTFIELD1, T.CHARTFIELD2, T.CHARTFIELD3,
T.PROJECT_ID, T.BOOK_CODE, T.GL_ADJUST_TYPE, T.DATE_CODE, T.CURRENCY_CD,
T.STATISTICS_CODE, T.FISCAL_YEAR, T.ACCOUNTING_PERIOD, T.POSTED_TOTAL_AMT,
T.POSTED_TOTAL_DR, T.POSTED_TOTAL_CR, T.POSTED_BASE_AMT, T.POSTED_TRAN_AMT,
T.POSTED_TRAN_DR, T.POSTED_TRAN_CR, T.BASE_CURRENCY, T.DTTM_STAMP_SEC,
T.PROCESS_INSTANCE) WHERE T.PROCESS_INSTANCE = 16320988
/
-- Row(s) affected: 0
--  SQL Error 1654 occurred at GL_JP_POST.ProcLedg.Upsert (ignoring)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Request GL_YC for multiple Business Units


Changes

 

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.