Duplicating Smart View Queries You can duplicate Oracle Smart View for Office queries. To duplicate Smart View queries: From the Task Area, select Reporting, and then Manage Queries. The Manage Queries screen is displayed, showing all existing queries for all applications for which the user is provisioned as an Admin or Power user. Click the Duplicate Query button . The Create Duplicate Smart View Query dialog box is displayed. Enter a name for the new query, and then click OK. The new query is saved and added to the list on the Manage Queries screen.