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

Last updated on SEPTEMBER 21, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables Brazil - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

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:


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

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