My Oracle Support Banner

R12: AP: Create Accounting (XLAACCUP) Error - XLA_00200_AAD_C_XXXXXX_PKG.AcctDerRule_XX. ORA-01403: No Data Found (Doc ID 2931268.1)

Last updated on FEBRUARY 28, 2023

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.


Running the create accounting process ends in error.  When reviewing the log file of the Accounting process shows the following error:


Error - XLA_00200_AAD_C_XXXXXX_PKG.AcctDerRule_##. ORA-01403: No Data Found.

Where the ## is the Account Derivation Rule (ADR) number of the configured Application Accounting Definition (AAD)


Steps to reproduce:

  1. Run the create accounting concurrent process (navigate in Payables to Other > Requests > Run)
  2. The create accounting process will end in error
  3. The accounting process will end in error
  4. Review the log file of the accounting process


Need to get the FND Debug log file in order to find

Please upload the following to get the FND log file from the Accounting process:

1.  Set the following profile options at your user level

FND: Diagnostics to Yes.
FND: Debug Log Enabled to Yes
FND: Debug Log Level to Statement
FND: Debug Log Mode to Asynchronous with Cross-Tier Sequencing
FND: Debug Log Module to %

2.  Run the Create Accounting concurrent program.

3.  Run the following to get the log for the Accounting concurrent request.

undefine v_request_id
set pagesize 9999
set linesize 9999
set trimspool on
set trimout on
spool dbug_log_file.log

Select A.module
, A.message_text
, A.callstack,
, A.errorstack
from fnd_log_messages A
,fnd_log_transaction_context b
Where a.transaction_context_id = b.transaction_context_id
And b.transaction_id in (&accounting_request_id)
order by a.log_sequence;

4. Upload the FND file in an Excel spreadsheet

5.  Stop low level debugging

FND: Debug Log Enabled to No





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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