After Deletion of Custom AADs the Validate Application Accounting Definitions Is Failing For FA_STANDARD_ACCOUNTING: 95617 (Doc ID 2431046.1)

Last updated on MAY 24, 2023

Applies to:

Symptoms

After deletion of some custom AADs (Application Accounting Definitions),

Run Validate Application Accounting Definitions show Standard Accounting in Invalid Status and error:

                  Error Category: Application Accounting Definition
    Error Number       Error Text                                                                 Error Type
    ----------------   ------------------------------------------------------------    -------------------
    95617              The validation process has encountered an internal error.    Error
                         Please enable the FND: Log Enabled profile option,revalidate
                         the application accounting definition, and review the log
                         for more information.

Further Debug Logging per <Note 562763.1> How to Debug When Validate Application Accounting Definitions Fails?  shows:

Package name = FA_XLA_EXTRACT_DEPRN_PKG
767 | PL/SQL: Statement ignored
767 | PLS-00201: identifier 'LOAD_LINE_DATA' must be declared


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  Delete Customer AAD via Application Forms and save
   (M) Setup>Financials>Subledger Accounting>Accounting Methods Builder>Methods and Definitions>Application Accounting Definitions
   Search for Owner = User
   Definition Code = CUSTOM ONE CREATED
   Use Deletion tool bar button to delete and save.

2.  Requery Form for Custom, no records returned
  (M) Setup>Financials>Subledger Accounting>Accounting Methods Builder>Methods and Definitions>Application Accounting Definitions
  Search for Owner = User
  Definition Code = CUSTOM ONE CREATED
  No longer available in LOV for Definition Code

Changes

Cause

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