EAR9.1: Brazilian Localization - Ledger Activity Aux (BRLARRAZ) is Running in Error.
(Doc ID 2052923.1)
Last updated on APRIL 07, 2019
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:
- 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
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 |
Cause |
Solution |
References |