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:

Symptoms

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

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

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.