I've got an existing 11g R1 application that I've been tasked with upgrading to 12c. An existing view object is giving me trouble so I wanted to recreate it. The select statement retrieves data from a custom database function that is in use in production:
select * from table(cast(pkg_mcs_inv_summ_reports.inv_summ_search_listing(:userid,:sessionid,:custids,:facdepots,:lotstatus,:fromdt,:todt,:itemtypes,:internalUser,:isnonprot) as inv_summ_list_tbl))
For some reason when I create a new VO, on the "query" step the Mode dropdown is disabled. When I paste my query into the Select box and then click next the app connects to the database where this function resides, but no attribute mappings are recognized. It's all blank. I assume that "Expert" mode is required to use a query like this?