Hi Ram,

You can download a CSV directly from the interactive report using the following syntax:

f?p=&APP_ID.:10:&SESSION.:CSV:NO:RP:P10_EMPID:&P3_EMPLOYEE_ID.

In the above example, it will call the report, which is on page number 10, by passing the CSV parameter after the session variable. Also, passing the report parameters employee id. You can omit this if not required. For the full tutorial, check this link Download CSV from Interactive Report using URL.

Another way is you can write a database procedure to extract the data into a CSV file.

Check this link Download CSV using PL/SQL procedure.

You can do two things in this case.

1. On the submit button, create a dynamic action to refresh only that classic report region instead of loading the whole page. Because when your page loads, it will clear that item.
2. Check the menu option, from where you are calling the page having the classic report. Say the page number is 2, which is calling the page number 3, which is having the report. Now go to page 2 and open that link property. There you will find the clear cache option. Then delete the clear state process you created, because now it is not needed.

Let me know if it still not works.

Hi Babu,

You can handle this using the data block based on the From Clause. Check this link Create Data Block Based On From Clause Query In Oracle Forms.

The from clause blocks are based on the SQL query and in SQL query you can use the Lead or Lag analytical function to solve your purpose. Here is an example:

Select cycle_id, start_date, end_date, exp_min, exp_sec, exp_time, (Lag (exp_time, 1, null) over (order by cycle_id, your_order_by) - exp_time) exp_time_diff from your_table;

Here the Lab expression value is the previous row exp_time and exp_time is the current row value.

First, you can test your query only in Oracle. You will get the desired result.