Showing wrong table options for selection in Report - Support and Troubleshooting

Showing wrong table options for selection in Report Description  Issue Description This Article will help to analyse and resolve the wrong table options shown in Creation of Report

When creating a report with Source Type : Table , the table field gives list of recent choices that are selected for other reports if any.These selection preferences comes from "User Preferences" for that report.

Steps to Reproduce Navigate to Reports -> Create New

Give the name for the report, Source Type: Table and Table: u_test (Create table: u_test before this step)

Run and save the report

Now try to create another report with same field selections and it shows recent choices as "u_test" table.

Now delete the table: u_test from tables (sys_db_object).

Go to create a report and see the recent choice still shows the table name: u_test Solution This is an intermittent issue and does not occur all the times. To resolve the issue, Navigate to User Administration -> User Preferences , search with name starts with reporting_recent_tables and delete the table from the list.