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:

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

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