R12 Views Set Display

We find many view tables showing empty or null records, as this is one of the advantage / performance increasing method that oracle has implemented in R12, but in 11i this feature is not made.

Showing off view tables will reduce the performance of the database , as these views are having records but does not show in the back-end. And this might get difficult for SCM / Finance Consultants to get the data.

To solve this simple pretty stuff , you have to run a small / simple procedure to activate the views. Just before you put your view table, execute the following line

" EXEC MO_GLOBAL.INIT('<TOP_NAME>') "  OR

" EXEC MO_GLOBAL.SET_CONTEXT_POLICY('S/M', ORG_ID) "

Where some of the TOP_NAME's are PO, ONT, AR, SQLAP. And S - Single / M - Multi Orgs.

Be advised , this method should not be followed while report development as this will affect most of your report's performance in short execution time will go up high.