EAR9.1: Brazilian Localization - Ledger Activity Aux (BRLARRAZ) is Running in Error. (Doc ID 2052923.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

On : 9.1 version, General

When attempting to Run the Ledger Activity Aux (BRLARRAZ)
the following error occurs.

ERROR
-----------------------
(SQR 5528) ORACLE OCIStmtExecute error 979 in cursor 17:
  ORA-00979: not a GROUP BY expression
SQL: SELECT BAL3.ACCOUNT, BAL3.ALTACCT, PRODUCT, BAL3.OPERATING_UNIT,
  BAL3.DEPTID, BAL3.PROJECT_ID, SUM(BAL3.POSTED_TOTAL_AMT) FROM
  PS_AR_BALANCE_BRL BAL3 WHERE BAL3.BUSINESS_UNIT = :1 AND BAL3.LEDGER
  = :2 AND BAL3.CURRENCY_CD = :3 AND BAL3.FISCAL_YEAR
  = :4 AND BAL3.ACCOUNTING_PERIOD = :5 AND BAL3.ACCOUNT < '1123000002'
  AND BAL3.ACCOUNT > ' ' GROUP BY BAL3.ACCOUNT, BAL3.ALTACCT,
  BAL3.OPERATING_UNIT, BAL3.DEPTID, BAL3.PROJECT_ID ORDER BY
  BAL3.ACCOUNT, BAL3.ALTACCT, BAL3.OPERATING_UNIT, BAL3.DEPTID,
  BAL3.PROJECT_ID

Error on line 1019:
  (SQR 3722) Could not set up cursor.

SQR for PeopleSoft: Program Aborting.


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

• Go to Statutory Reports > Accounts Receivable > Ledger Activity Aux and run the Razão de Clientes - AR (BRLARRAZ)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the BRLARRAZ report.

Cause

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