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

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version: 11.5.10.2 to 11.5.10.3 - Release: 11.5 to 11.5

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;

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms