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

Last updated on MARCH 28, 2025

Applies to:

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

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