In our situation we only need a unique ID for the sake of the FID requirement by Map. To generate such a unique ID we chose the following approach:
- the view is wrapped by a select statement which includes rownum:
create or replace view my_view as select rownum fid, t.* from ( ... view definition ... ) t;
As we need to show the data of the view only occasionally performance is not a major concern here.
Map 2013, SP2