EAR9.1: Brazilian Localization - Ledger Activity Aux (BRLARRAZ) is Running in Error.
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.
On : 9.1 version, General
When attempting to Run the Ledger Activity Aux (BRLARRAZ)
the following error occurs.
(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,
Error on line 1019:
(SQR 3722) Could not set up cursor.
SQR for PeopleSoft: Program Aborting.
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)
The issue has the following business impact:
Due to this issue, users cannot run the BRLARRAZ report.
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