R12: Create Accounting Program Failed With xla_accounting_pkg.ValidateAAD. ORA-0000 Error Message

(Doc ID 1227207.1)

APPLIES TO:

Oracle Assets - Version 12.0.0 and later
Information in this document applies to any platform.
XLAACCUP - Create Accounting Program

SYMPTOMS

When attempting to run Create Accounting - Assets, the Accounting Program request (XLAACCUP) ends with the following error in the log file:-

ERROR
-----------------------
An internal error occurred. Please inform your system administrator or support representative that:
An internal error has occurred in the program xla_accounting_pkg.ValidateAAD.

ORA-0000: normal, successful completion.
.
The application accounting definition Assets Standard Accounting* owned by Oracle is not validated. Please validate the application accounting definition or update the application accounting definitions contained in the subledger accounting method Standard Accrual*.
---------

*The names may vary from these standard names where a customer is using a different Subledger Accounting Method / Application Accounting Definition.

CAUSE

The Application Accounting Definition for Assets is invalid.

SOLUTION

1. Validate the AADs via the concurrent request XLAABACR Validate Application Accounting Definitions for module = Assets.

Note xlaapeng.pkb requires that all AADs on the application be valid, even if they aren't used.  

2. Confirm all Asset AADs are validate (view output in #1)

3.  Re-run Create Accounting - Assets.