Blueprints → Analyze Oracle EBS Inventory Management
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.
The Oracle EBS Inventory Management blueprint is available in the On-Premises and Cloud Versions of Incorta.
Here are the Incorta prebuilt Inventory Management Blueprint physical schemas, business schemas, dashboard folders, dashboards, and insights:
EBS common 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
- Inventory Dashboard
- Inventory and Open PO Overview Dashboard
- Inventory On Hand Dashboard
- Inventory On Hand Quantity Snapshot Dashboard
- Item Costing Details Dashboard
- Item Master Dashboard
- Material Transactions Dashboard
|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|
|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|
|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|
|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|
|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|
|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|
|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|
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
- In the Schema Designer, select the
- In the Table Editor, in the Summary section, select the
EBSSQL 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.