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 DECEMBER 16, 2024
Applies to:
Oracle Payables - Version 12.0.0 and laterInformation in this document applies to any platform.
Symptoms
Running the create accounting process ends in error. When reviewing the log file of the Accounting process shows the following error:
Where the ## is the Account Derivation Rule (ADR) number of the configured Application Accounting Definition (AAD)
Steps to reproduce:
- Run the create accounting concurrent process (navigate in Payables to Other > Requests > Run)
- The create accounting process will end in error
- The accounting process will end in error
- 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
4. Upload the FND file in an Excel spreadsheet
5. Stop low level debugging
FND: Debug Log Enabled to No
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |