INV Organization Access – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Inventory organization access for all responsibilities, either through hr security profile or individual org_access assignment.
Report Parameters
Organization Code, Application Name, Responsibility Name
Oracle EBS Tables Used
mtl_parameters, org_access_view, org_access, fnd_responsibility_vl, fnd_application_vl
Report Categories
Related Reports
CAC Missing Receiving Accounting Transactions, CAC Missing Material Accounting Transactions, CAC Missing WIP Accounting Transactions, CAC Receiving Account Detail, CAC User-Defined and Rolled Up Costs, CAC Cost vs. Planning Item Controls, CAC Item Cost Summary, CAC OPM WIP Account Value, CAC Last Standard Item Cost
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | INV Organization Access 18-Jan-2018 222609.xlsx |
| Blitz Report™ XML Import | INV_Organization_Access.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/inv-organization-access/ |
INV Organization Access - Case Study & Technical Analysis
Executive Summary
The INV Organization Access report is a security audit tool. In Oracle EBS, access to inventory organizations is controlled by the “Organization Access” form (mapping Responsibilities to Orgs). This report lists which responsibilities have access to which organizations, ensuring that users are not granted excessive privileges.
Business Challenge
In multi-org environments (e.g., a company with 50 warehouses globally), managing security is complex. Risks include:
- Data Leakage: A user in the “US Warehouse” responsibility accidentally seeing “China Manufacturing” data.
- Transaction Errors: A user transacting in the wrong organization because they have access to too many.
- Audit Failures: Auditors require proof that access is restricted on a “Need to Know” basis.
Solution
The INV Organization Access report provides a clear matrix of Responsibility-to-Organization mappings. It validates the security setup defined in the ORG_ACCESS table.
Key Features:
- Security Matrix: Shows exactly which Orgs are visible to which Responsibilities.
- Application Context: Identifies the application (Inventory, Purchasing, BOM) associated with the responsibility.
- User Mapping: Can be extended to show which Users have those responsibilities.
Technical Architecture
The report queries the security definition tables used by the ORG_ACCESS_VIEW mechanism.
Key Tables and Views
ORG_ACCESS: The table storing the link betweenRESPONSIBILITY_IDandORGANIZATION_ID.FND_RESPONSIBILITY_VL: Responsibility definitions.HR_ALL_ORGANIZATION_UNITS: Organization definitions.ORG_ACCESS_VIEW: The standard view that enforces this security at runtime.
Core Logic
- Mapping Retrieval: Selects all records from
ORG_ACCESS. - Resolution: Joins IDs to names for Responsibilities and Organizations.
- Validation: Checks if the responsibility is still active.
Business Impact
- Security Compliance: Ensures adherence to Segregation of Duties (SoD) and data access policies.
- Error Prevention: Reduces the risk of accidental transactions in the wrong organization.
- Audit Readiness: Provides immediate evidence of access controls for IT audits.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics