Oracle Inventory Cloud – Essential Tables Reference

 

Key Database Tables in Oracle SCM Inventory Cloud

This blog provides a list of the key database tables from Oracle SCM Inventory Cloud module. These tables form the backbone of transactional and master data in Oracle Cloud Inventory and are essential for reporting, troubleshooting, integrations, and custom development.

 

Sr. No.	Module	Table Name	Description
1	Product Data Hub	EGP_SYSTEM_ITEMS_B	Stores the Item Number and other attributes of the item
2	Inventory	INV_MATERIAL_TXNS	Stores the record of every material transaction or cost update performed in Inventory
3	Inventory	INV_MATERIAL_TXNS_TEMP	Stores the open pick quantity
4	Inventory	INV_TRANSACTIONS_INTERFACE	Stores the interface transactions performed in Inventory
5	Inventory	INV_RESERVATIONS	Stores the Item Reservation details
6	Inventory	INV_ONHAND_QUANTITIES_DETAIL	Stores the quantity on hand information by control level and location
7	Inventory	INV_ORG_PARAMETERS	This table stores the inventory organization parameters defined in Oracle Inventory.
8	Inventory	INV_SECONDARY_INVENTORIES	This table stores the subinventory details in each inventory organization defined in Oracle Inventory.
9	Inventory	INV_SECONDARY_LOCATORS	This table  stores all locators within a subinventory for a specific item.
10	Inventory	INV_ITEM_LOCATIONS	This table stores the definition table for stock locators.
11	Inventory	INV_LOT_NUMBERS	This table stores the definition and expiration date of all lot numbers in inventory.
12	Inventory	INV_SERIAL_NUMBERS	This table stores the definition of all serial numbers in inventory.
13	Inventory	INV_SUPPLY	This table stores the incoming supply information for an organization.
14	Inventory	INV_TXN_REQUEST_HEADERS	This table stores the movement request (move order) headers.
15	Inventory	INV_TXN_REQUEST_LINES	This table stores the movement request (move order) lines.
16	Inventory	INV_TRANSFER_ORDER_HEADERS	This is the Transfer Order header table.
17	Inventory	INV_TRANSFER_ORDER_LINES	This is the Transfer Order lines table.
18	Inventory	INV_TRANSFER_ORDER_DISTRIBS	This is the Transfer Order line distributions table.
19	Inventory	INV_TRANSACTION_REASONS_B	This is the base table for inventory transaction reasons. It stores the list of all transaction reasons across organizations.
20	Inventory	INV_TRANSACTION_TYPES_B	This table contains the seeded and user defined transaction types.

 

·       Demand Quantity details are not captured in any of the Inventory Tables.

·       However, you can review the reservation quantity as well as the Demand Source in the INV_RESERVATIONS table.