Skip to the content.

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

Enginatics

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:

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:

Technical Architecture

The report queries the security definition tables used by the ORG_ACCESS_VIEW mechanism.

Key Tables and Views

Core Logic

  1. Mapping Retrieval: Selects all records from ORG_ACCESS.
  2. Resolution: Joins IDs to names for Responsibilities and Organizations.
  3. Validation: Checks if the responsibility is still active.

Business Impact


© Enginatics GmbH