Thanks for the response Maynard, but I would really appreciate the response from Oracle regarding execution of the APPS.MO_GLOBAL package.
Tell more more about how the users will execute queries? Or ar eyou talking about reporting?
I've found a couple of good articles that may help you decide the path you want to take.
This one compares Active Data Guard to Goldengate and may make your decision easier https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9527725800346175998
This one compares Active Data Guard to Oracle Data Guard https://blogs.oracle.com/stevenchan/comparing-oracle-data-guard-vs-active-data-guard-for-ebs-environments
This one is general reference https://www.oracle.com/technetwork/database/availability/dataguardgoldengate-096557.html
Mary Grace and I looked at all 3 articles earlier. The process she has posted about, and thank goodness she caught it, is used from a cognos reporting application and uses the APPS.MO_GLOBAL to simulate an EBS application user in order to utilize our custom ITAR data protection policies. Our concern is it might cause an issue with updating the session information on the copy. If you don't think that would be a problem, Golden Gate could be our best solution. If you'd like more detail we can certainly work on providing it.
Both have restrictions if you are going read only. I'd rather not make a recommendation given my limited knowledge on both products, but if you are concerned about APPS.MO_GLOBAL then Golden Gate has some features that might make things easier to implement. Can't you do a trial period ?