sameer

• Jan 14th, 2006

 

yes it is normal pactice to use views and tables for reporting purposes.

u hav to just give the name of view in place of table.

Denzy

 Profile Answers by Denzy Questions by Denzy

• Feb 13th, 2006

 

Yes we can use a view.

If the table on which the view is based is updated, we can call a procedure in the Before report trigger of the report to update the view and then retreive the data from the view.

After the report is run we can alwayz delete the data in view by writting delete in the after report trigger of the report.

Manikandan.M

• Sep 11th, 2007

 

Yes we can use the view if you use multiorg view example (oe_order_headers) then we need to set the operating unit for that view so we need to execute the following package before report trigger
fnd_client_info.set_org_context(org_id);