Blueprints → Analyze Oracle EBS Inventory Management

About the Oracle EBS Inventory Management Blueprint

The Oracle E-Business Suite (EBS) Inventory Management module improves inventory visibility, reduces inventory levels and manages facility operations efficiently. Track all of your material in each line of business and stage of the inventory lifecycle in a single, unified system. The Incorta Direct Data Platform™ Blueprint for the Inventory Management module provides prebuilt schemas, dashboards, and insights to help you easily monitor and analyze your organization’s inventory in order to better manage inventory and its costs, increase product turnover by reducing inventory levels, and properly deploy inventory to the correct location.

Here are some of the questions answered by the Oracle EBS Inventory Management Blueprint:

  • What are my inventory turns?
  • How is the inventory mix meeting demand?
  • Which item shortages are driving backorders?
  • How is inventory value trending over time?
  • What are the average days of supply per item and per category?
  • What are the slow-moving items?

You can further customize and add on to the insights in the Incorta Inventory Management blueprint to support your specific business needs.

Note

The Oracle EBS Inventory Management blueprint is available in the On-Premises and Cloud Versions of Incorta.

Inventory Management Blueprint Components

Here are the Incorta prebuilt Inventory Management Blueprint physical schemas, business schemas, dashboard folders, dashboards, and insights:

Physical Schemas

  • EBS_INV
  • EBS common schemas:

    • EBS_ITEM_COMMON
    • EBS_CAL_COMMON
    • EBS_FND_COMMON
    • EBS_HR_COMMON
    • EBS_FIN_COMMON
    • EBS_PARTY_COMMON

Business Schemas

  • InventoryItem: Provides an overview of inventory on-hand from a current and historical perspective, including daily, weekly, and monthly trends
  • InventoryMetrics: Provides various inventory metrics, including days of supply and days on-hand
  • ItemList: Provides a view of the item master, including organization, buyer, and supplier information
  • MaterialTransactions: Provides visibility to inventory material transactions, including purchase order, buyer, and supplier details

Dashboard Folder

  • Inventory

Dashboards and Insights

Inventory Dashboard
Insight Description
Inventory QTY by Site This stacked column insight shows the quantity of inventory items by organization code and sub-inventory group
Inventory On Hand Summary This aggregated table insight shows the total quantity, warehouse location, dollars on-hand, and number of items by organization code
Inventory Detail This aggregated table insight shows the inventory details, including: item organization, organization code, item, item description, subinventory group, subinventory, item locator, quantity on-hand, and dollars on-hand
Example Inventory Dashboard
Inventory and Open PO Overview Dashboard
Insight Description
OH By Org (Top 20) This column insight shows the on-hand (OH) inventory value for the top 20 organizations
Org Summary This aggregated table insight shows the inventory on-hand quantity, total purchase order (PO) quantity, on-hand value, and open PO value for each organization
In Transit Summary This aggregated table insight shows the inventory in transit quantity and value for each organization
OH By Category/ Seg1/Seg2 (Top 20) This stacked bar insight shows the inventory on-hand value by category segments one and two for the top twenty segments
Item Details This aggregated table insight shows the inventory item details, including: item, item description, organization name, category, on-hand quantity, on-hand value, open PO quantity, and open PO value
Example Inventory & Open PO Overview Dashboard
Inventory On Hand Dashboard
Insight Description
Onhand Value This KPI insight shows the on-hand value of all inventory items
Onhand Quantity This KPI insight shows the on-hand quantity of all inventory items
Onhand Quantity by Subinventory This donut insight shows the on-hand inventory quantity by sub-inventory as a percent of total on-hand quantity
Onhand Inventory by Organization This packed bubble insight shows the on-hand inventory value by organization as a percent of total on-hand inventory value
Transaction Details This aggregated table insight shows the organization code, sub-inventory group, item, lot number, on-hand creation date, and transaction quantity
Top Inventory Items This packed bubble insight shows the on-hand inventory value by item for the top fifteen items
Item Details This aggregated table insight shows the inventory item details, including: item, item description, primary unit of measure (UOM), on-hand quantity, item cost, on-hand value, primary transaction quantity, and primary on-hand value
MinMax Qty by Item Type This pivot table insight shows the super market max quantity by item type, primary UOM, item code, and item status code
Example Inventory On Hand Dashboard
Inventory On Hand Quantity Snapshot Dashboard
Insight Description
On Hand Quantity Snapshot by Week This stacked column insight shows the on-hand inventory transaction quantity by organization for each week
On Hand Quantity Snapshot Details This aggregated table insight shows the on-hand inventory quantity snapshot details, including: snapshot date, item, organization name, and transaction quantity
Example Inventory On Hand Quantity Snapshot Dashboard
Item Costing Details Dashboard
Insight Description
Item Costing Details This listing table insight shows the item costing details, including: item, item description, transaction type, transaction date, transaction quantity, prior cost, and new cost
Example Item Costing Details Dashboard
Item Master Dashboard
Insight Description
Item Master Organization Details This listing table insight shows the item master organization details, including: organization, item, and item description
Approved Suppliers for Items This aggregated table insight shows the approved suppliers for items, including: organization, item, supplier, supplier site, and number of suppliers
Example Item Master Dashboard
Material Transactions Dashboard
Insight Description
Item Movement Summary This donut insight shows the transaction quantity by transaction type as a percent of total transaction quantity
PO Items Receipts Summary This column insight shows the transaction quantity by inventory item
Transaction Details This aggregated table insight shows the transaction details, including: inventory organization, owning organization, item, item description, transaction date, transaction UOM, transaction quantity, primary UOM, primary quantity, supplier name, buyer full name, extension cost, inventory locator, transaction type, transaction source type, reason, subinventory code, and vendor lot number
Example Material Transactions Dashboard

Inventory Blueprint Data Model

Additional Information

On Hand Quantities Snapshot

A scheduled job runs a daily load of the MTL_ONHAND_QUANTITIES_SN in the EBS_INV physical schema. As defined in the table’s data source, a SQL query returns a snapshot of the source table. You can modify the snapshot loading date, and thereby change the frequency. To modify the SQL statement in the data source, follow these steps:

  • In the Navigation bar, select Schema.
  • In the Schema Manager, select EBS_INV.
  • In the Schema Designer, select the MTL_ONHAND_QUANTITIES_SN table.
  • In the Table Editor, in the Summary section, select the EBS SQL data source.
  • In the Data Source dialog, in the Query field, modify the SQL statement with the Edit Query dialog as required.
  • Select Save.
  • In the Action bar, select Done.

© Incorta, Inc. All Rights Reserved.