My Oracle Support Banner

EGL9.2: When Separate Dr/Cr is Enabled, Ledger Load Abend at GL_LED_LOAD.DOPROC.Step04 With Error "Column 'PS_LED_LOAD_WK1001.DATE_CODE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause." (Doc ID 1627886.1)

Last updated on JULY 15, 2021

Applies to:

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

Symptoms

On : 9.2  version, Ledger Load

When attempting to run the ledger load process,  the below error is received for a BU/Ledger, which has 'Separate Debit and Credit' enabled.

ERROR
-----------------------
Error presented in AET trace:

-- 05.19.43 .....(GL_LED_LOAD.DOPROC.Step04) (SQL)
INSERT INTO PS_LED_LOAD_WK2001 (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) SELECT 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, SUM(POSTED_TOTAL_AMT), SUM(POSTED_TOTAL_DR), SUM( POSTED_TOTAL_CR), SUM(POSTED_BASE_AMT), SUM(POSTED_TRAN_AMT), SUM( POSTED_TRAN_DR), SUM( POSTED_TRAN_CR), BASE_CURRENCY, '2013.11.27 05:18:31.000', PROCESS_INSTANCE
FROM PS_LED_LOAD_WK1001 WHERE PROCESS_INSTANCE=15610 AND BUSINESS_UNIT = 'PM001' GROUP 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 ,  CURRENCY_CD,  
STATISTICS_CODE,  FISCAL_YEAR,  ACCOUNTING_PERIOD,  BASE_CURRENCY,  PROCESS_INSTANCE
/
-- Row(s) affected: 0
-- 05.19.47 Process 15610 ABENDED at Step GL_LED_LOAD.DOPROC.Step04 (Action SQL) -- RC = 8601
ROLLBACK
/
-- 05.19.48 SQL Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Column 'PS_LED_LOAD_WK1001.DATE_CODE' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
[Microsoft][SQL Server Native Client 11.0][SQL S

 

WHAT IS WORKING
----------------------------------------
Issue is only replicated on MS SQL platform.
Process works fine on Oracle Database at same build.

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

 1. Select below setting on (Set Up Financials/Supply Chain > Business Unit Related > General Ledger > Ledger For A Unit)
    - Allow Ledger Load Updates
    - Enable Separate Debit and Credit.
 2. Set up Chartfield Mapping Set for ledger load on page General Ledger > Consolidate Financial Data > Load Ledgers > Chartfield Mapping Set
 3. Run GL_LED_LOAD AE on page General Ledger > Consolidate Financial Data > Load Ledgers > Request Ledger Load


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!


In this Document
Symptoms
Changes
Cause
Solution
References


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