| layout | default |
|---|---|
| title | INV Organization Access | Oracle EBS SQL Report |
| description | Inventory organization access for all responsibilities, either through hr security profile or individual orgaccess assignment. |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, INV, Organization, Access, mtl_parameters, org_access_view, org_access |
| permalink | /INV%20Organization%20Access/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Inventory organization access for all responsibilities, either through hr security profile or individual org_access assignment.
Organization Code, Application Name, Responsibility Name
mtl_parameters, org_access_view, org_access, fnd_responsibility_vl, fnd_application_vl
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
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.
| 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/ |
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.
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.
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.
The report queries the security definition tables used by the ORG_ACCESS_VIEW mechanism.
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.
- 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.
- 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.
- 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