My Oracle Support Banner

Subledger Accounting Issue: Journal Line Types Form Errors for New JLT- APP-XLA-95103: An internal error occurred. XLA_CONDITIONS_PKG.ACCT_CONDITION_IS_INVALID ORA-00979: No a GROUP BY Expression (Doc ID 1504692.1)

Last updated on FEBRUARY 12, 2019

Applies to:

Oracle Receivables - Version 12.1.1 and later
Oracle Subledger Accounting - Version 12.1.1 and later
Information in this document applies to any platform.
confirmed to occur on RDBMS version
FORM:XLAABADR.FMB - Account Derivation Rules
FORM:XLAABDLT.FMB - Journal Line Types


Attempting to save a new Journal Line Types on the Journal Line Types form (XLAABDLT.FMB) and receive the following error:

APP-XLA-95103: An internal error occurred. Please inform your system administrator or support representative that:

An internal error has occurred in the program xla_conditions_pkg.acct_condition_is_invalid.
ORA-00979: no a GROUP BY expression.

Steps to Reproduce:
Responsibility: Receivables Manager
Navigation: Setup > Accounting > Accounting Methods Builder > Journal Entry Setups > Journal Line Types
Copy or create a new journal line type
Save the new JLT, error occurs.

This error also occurs on the Account Derivation Rules form (XLAABADR.FMB)

Steps to Reproduce:
Responsibility: Receivables Manager
Navigation: Setup> Financials> Subledger Accounting> Accounting Methods Builder> Journal Entry Setups> Accounting Derivation Rules
Copy or create a account derivation rule
Save the new account derivation rule, error occurs.


Upgraded to RDBMS version


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. 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.