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.


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