11i: RXARPFTR :Financial Tax Register Report Is Empty: No Data Found Taxdebug :ORA-6502
Last updated on AUGUST 24, 2016
Applies to:Oracle Receivables - Version: 18.104.22.168 to 22.214.171.124 - Release: 11.5 to 11.5
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
where module = 'TAX'
and log_sequence >= &log_seq retrieved in step 2;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms