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 JANUARY 23, 2017

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

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