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.

Symptoms

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_header_id
--,
aeh.parent_ae_line_num Bug #21605640
order
by ael.ae_header_Id )
--

However aeh.entity_id, aeh.ledger_id are not in the GROUP BY list.



Cause

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