My Oracle Support Banner

R12: Intra Company Accounts Are Not Used Even When Setup Correctly and the Accounting Class Balance Is Used instead (Doc ID 1461962.1)

Last updated on FEBRUARY 14, 2019

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.


You setup intra company accounts. Invoices are entered with different balancing segment values. Create Accounting does not use the Intra Company accounts setup for the Ledger / Legal Entity. Instead the Entered Currency Balancing Account is used.

The issue only happens if you are on rdbms version or higher.

Debug shows:

fun.plsql.fun_bal_pkg.journal_balancing.unexpected_error_others 5 -979 : ORA-00979: not a GROUP BY expression





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

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