INV Organization Access – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Inventory · all Inventory reports
Overview
Inventory organization access for all responsibilities, either through hr security profile or individual org_access assignment.
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
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
WIP Move Transactions 11i, INV Item Upload 11i, FND Responsibility Access, CAC Inventory Organization Summary, CAC Invoice Price Variance, PO Cancelled Purchase Orders, EAM Work Orders 11i, EAM PM Schedule Upload 11i, FND Responsibilities
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | INV Organization Access 18-Jan-2018 222609.xlsx |
| Blitz Report™ XML Import | INV_Organization_Access.xml |
| SQL Source | INV Organization Access.sql |
| Full Report 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
© Enginatics GmbH