Create Accounting Is Not Picking Up Any Receipts When The Program Is Being Run
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.
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