My Oracle Support Banner

11i: RXARPFTR :Financial Tax Register Report Is Empty: No Data Found Taxdebug :ORA-6502 (Doc ID 358957.1)

Last updated on MARCH 14, 2022

Applies to:

Oracle Receivables - Version 11.5.10.2 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

The Financial Tax Register returns 'No data found' for a specific gl date range although there are transactions to be reported.

The report returns values when it is submitted with a smaller date range.

In the Tax_debug log, error ORA-6502 is found.

In order to get Tax debug :
1. Enable TAX-debug by setting the following profile options :
              FND: Debug Log Enabled -> Yes
              FND: Debug Log Level  -> Statement
2. Please run below query and get the value for max value of log_sequence:
                              select MAX(LOG_SEQUENCE) from fnd_log_messages;
3. Submit the report for the gle-dates not retunrning data.
4. After the request finished, please run next select to get the TAX Debug  information :
                 select module, message_text
                 from   fnd_log_messages
                 where  module = 'TAX'
                 and log_sequence >= &log_seq retrieved in step 2;

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
References

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