AGIS: Validate Transaction Account Definitions Fails With ORA-24344: success with compilation error (Doc ID 1484547.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle General Ledger - Version 12.0.4 and later
Information in this document applies to any platform.
AGIS, TAD, Transaction Account Definition

Symptoms

After applying the <Patch 10332659> for AGIS,
the following errors occur:

ERROR
1.Please inform your system administrator or support representative that: The procedure XLA_00435_TAD_C_0000000001_PKG.trans_account_def_online could not be invoked because of the following database error: ORA-04063: package body "APPS.XLA_00435_TAD_C_0000000001_PKG" has errors ORA-06508: PL/SQL: could not find program unit being called: "APPS.XLA_00435_TAD_C_0000000001_PKG".
2.Please inform your system administrator or support representative that: The Transaction Account Builder batch processing failed. The transaction account builder interface has been cleared Please check the messages above for further information. The error occurred in the function fun_xla_tab_pkg.run.

STEPS
1. go to the Intercompany Super User responsibility

2. navigate to Transaction > Outbound
3. create a new Outbound batch in AGIS .
4. create distribution. Press "Add line".

Tried to run the concurrent program "Transaction Account Builder - Validate Transaction Account Definitions", but the request failed with the following message in the logfile:

"The stored package XLA_00435_TAD_C_0000000001_PKG was generated, but its status is invalid. The error returned by the package compilation was: ORA-24344: success with compilation error.
The transaction account definition XXXX cannot be validated. Your system administrator or support representative should take the following actions:
Enable the Subledger Accounting debug trace, validate the transaction account definition again and check the log for further information."

Changes

 Applied <Patch 10332659>

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