You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ORA-00962: too many group-by / order-by expressions error

in HCM Data Loader (HDL)

Summary:

Getting error of ORA-00962: too many group-by / order-by expressions


Content (please ensure you mask any confidential information):

Hi All,

Greetings!

We have received error during HDL load for Element Entry with error message as-

An error occurred. To review details of the error run the HCM Data Loader Error Analysis Report diagnostic test. Message details: ORA-00962: too many group-by / order-by expressions https://docs.oracle.com/error-help/db/ora-00962/

The diagnostic test is not clearly giving any details about the error root cause-

java.sql.SQLSyntaxErrorException: ORA-00962: too many group-by / order-by expressions https://docs.oracle.com/error-help/db/ora-00962/ at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:715) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:615) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1372) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:969) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:237) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:524) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:298) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:1255) at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1413) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1287) at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1844) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1620) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3973) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4160) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1117) at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:144) at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1569) at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:1065) at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:9280) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1552) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1333) at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1849) at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1729) at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1709) at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:9150) at oracle.apps.hcm.common.core.HcmDeHelper.reComputeEffRowCurrencies(HcmDeHelper.java:186) at oracle.apps.hcm.common.core.HcmDeHelper.findRowByType(HcmDeHelper.java:149) at oracle.apps.hcm.common.core.HcmDeHelper.getLastEffectiveRow(HcmDeHelper.java:493) at oracle.apps.hcm.common.core.HcmDeHelper.getValidationDates(HcmDeHelper.java:1632) at oracle.apps.hcm.common.core.HcmEntityImpl.setDtValidationDates(HcmEntityImpl.java:5464) at oracle.apps.hcm.common.core.HcmEntityImpl.deLogicalRemoveWithDetails(HcmEntityImpl.java:1319) at oracle.apps.hcm.common.core.HcmEntityImpl.remove(HcmEntityImpl.java:1281) at oracle.apps.hcm.security.common.publicModel.HcmSecurityEntityImpl.remove(HcmSecurityEntityImpl.java:373) at oracle.apps.hcm.common.pay.PayEntityImpl.remove(PayEntityImpl.java:1276) at oracle.apps.hcm.payrolls.elements.entries.protectedModel.entity.ElementEntryDEOImpl.remove(ElementEntryDEOImpl.java:272) at oracle.apps.hcm.common.core.HcmViewRowUtils.doImmediateOnThisEntityIndex(HcmViewRowUtils.java:2223) at oracle.apps.hcm.common.core.HcmViewRowUtils.doImmediateDEOpeartion(HcmViewRowUtils.java:1950) at oracle.apps.hcm.common.core.HcmViewRowUtils.endDate(HcmViewRowUtils.java:1413) at oracle.apps.hcm.common.core.HcmViewRowImpl.endDate(HcmViewRowImpl.java:1114) at oracle.apps.hcm.common.core.HcmViewRowImpl.handlePhysicalEndDate(HcmViewRowImpl.java:1432) at oracle.apps.hcm.common.core.HcmViewObjectImpl.handlePhysicalEndDate(HcmViewObjectImpl.java:3878) at oracle.apps.hcm.common.core.HcmViewObjectImpl.handleLogicalDateChange(HcmViewObjectImpl.java:2938) at oracle.apps.hcm.common.core.HcmViewObjectImpl.handleLogicalUpdate(HcmViewObjectImpl.java:2335) at oracle.apps.hcm.common.core.HcmViewObjectImpl.handleLogicalRow(HcmViewObjectImpl.java:1811) at oracle.apps.hcm.common.core.HcmApplicationModuleImpl.processLogica

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!