Technology Stack - EBS (MOSC)

MOSC Banner

Is it possible to access data in Oracle EBS Secure views from Business Objects reporting system

edited Aug 20, 2021 11:55AM in Technology Stack - EBS (MOSC)

We run Oracle EBS 12.2.9 on Oracle RDBMS 19.0. We're trying to access data in EBS "secure" views (e.g. PO_HEADERS_V) from SAP Business Objects. As expected, no data is visible since the MOAC context is not set up (would need to be done via mo_global.set_policy_context function call). On the other hand, Business Objects does not support executing a function prior to running report. Is there a workaround to access data in the secure views externally without setting the policy context? Or is it possible to bypass MOAC restriction all together?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center