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 MAY 15, 2018

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 11.2.0.1.0
FORM:XLAABADR.FMB - Account Derivation Rules
FORM:XLAABDLT.FMB - Journal Line Types

Symptoms

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.

Changes

Upgraded to RDBMS version 11.2.0.1.0

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.