My Oracle Support Banner

Reversed Receipt Error: An internal error has occurred in the program xla_ae_lines_pkg.AccountingReversal (Doc ID 746801.1)

Last updated on MARCH 07, 2023

Applies to:

Oracle Receivables - Version 12.0.5 and later
Information in this document applies to any platform.
This problem can occur on any platform.


On 12.0.5
When attempting to run create accounting for a reversed receipt
the following error occurs.

An internal error occurred. Please inform your system administrator or support representative that:
An internal error has occurred in the program xla_ae_lines_pkg.AccountingReversal. ORA-00979: not
a GROUP BY expression.

The issue can be reproduced at will with the following steps:
1. Create a receipt. Reverse it.
2. Create online accounting, can not create.
3. Run "create accounting" program, finished with error


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.