Create Accounting Is Not Picking Up Any Receipts When The Program Is Being Run
(Doc ID 2084622.1)
Last updated on MARCH 27, 2017
Applies to:Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
When the user tries to Create Accounting for Receipt reversals, the Accounting program errors with:
An internal error has occurred in the program
xla_ae_lines_pkg.AccountingReversal. ORA-00979: not a GROUP BY expression.
The issue occurs after the customer received xlajelns.pkb 120.197.12010000.65 via 21605640.
The reason for the issue is bug 21605640 introduced the following code change:
ELSE -1 * dense_rank() over (
partition by aeh.entity_id, aeh.ledger_id
aeh.parent_ae_line_num Bug #21605640
by ael.ae_header_Id )
However aeh.entity_id, aeh.ledger_id are not in the GROUP BY list.
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
|1. Bug Summary|
|2. Fixed Files|
|3. Recommended Patches|
|4. Solution Steps|
|Still Have Questions?|