EGL9.2: GL_YC Abends At Step GL_YC_CAL_RE.Process.iLedTmp With "ORA-00979: Not A GROUP BY Expression (Doc ID 2230878.1)

Last updated on JULY 31, 2017

Applies to:

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

Symptoms


ISSUE
----------

GL_YC runs to no success with the following error

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

ORA-00979: not a GROUP BY expression Failed SQL stmt: INSERT INTO PS_CLO_LED_TAO4 (PROCESS_INSTANCE, BUSINESS_UNIT, LEDGER, ACCOUNT, ALTA CCT, DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFF ILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, PROJECT_ID, BOOK_CODE, BAL_S HEET_IND, GL_ADJUST_TYPE, DATE_CODE, BUDGET_PERIOD, SCENARIO, CURRENCY_CD, BASE_CURRENCY, STATISTICS _CODE, FISCAL_YEAR, ACCOUNTING_PERIOD, DTTM_STAMP_SEC, POSTED_TOTAL_AMT, POSTED_TOTAL_DR, POSTED_TOT AL_CR, POSTED_BASE_AMT, POSTED_TRAN_AMT, POSTED_TRAN_DR, POSTED_TRAN_CR, CLOS_PROC_FLG, CF_GROUP_NBR ) SELECT 1598168, A.BUSINESS_UNIT, A.LEDGER, A.ACCOUNT, ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ',
 ABENDED at Step GL_YC_CAL_RE.Process.iLedTmp (SQL) -- RC = 979






 

Changes

 

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