Discoverer 11g Querying Against An E-Business Suite 12 Multi-Org VPD Protected View With ORG_ID Returns No Data
(Doc ID 732826.1)
Last updated on AUGUST 18, 2021
Applies to:Oracle Discoverer - Version 10.1.2.2 to 184.108.40.206.0 [Release 10.1.2 to 11g]
Information in this document applies to any platform.
*** Checked for relevance on 04-Dec-2014 ***
- Using E-Business Suite r12 and Discoverer 11g (220.127.116.11.0 terminal release)
++ This document does not apply to E-Business Suite 11i as it does not use VPD policies for securing data and the discoinit function does not exist in the fnd_product_initialization_pkg package.
++ Steps provided in this document are not supported with EBS 12.2.x.
- Multi-Organization Access Control (MOAC) is not setup for the Organization ID (org_id) for any of the E-Business Suite functional areas.
- The MO: Organization Unit profile is set.
- The MO: Security Profile is not set.
When creating a custom Discoverer workbook or using SQL*Plus (or equivalent) against a custom view or a standard pre-seeded view (e.g. - oe_orders_headers_v) that is protected with a Virtual Private Data Base (VPD) context policy based on org_id, no data is returned.
When using SQL*Plus (or equivalent), no data is returned when run via a similar way that Discoverer runs. For example, following: <Note 279736.1> 'How To Run SQL From An Applications Mode Discoverer Workbook In SQL*PLUS'.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document