Inventory Management
In the Inventory Management data model, the add-in models data such as return lots, receiving parameters, and physical inventories as an easy-to-use SQL database. Live connectivity to these objects means that any changes to your Oracle Fusion Cloud SCM account are immediately reflected in the add-in.
Views
The Views section, which lists read-only SQL tables, contains samples of what you might have access to in your Oracle Fusion Cloud SCM account.
Common views include:
| View | Description |
| InventoryOnhandBalances | Provides a summary of on-hand quantities at various levels, such as organization, subinventory, and locator. |
| InventoryReservations | Tracks reservation details for items, including location, supply documents, and demand in primary and secondary units. |
| InventoryTransactionTypes | Defines and manages transaction types by combining source types and actions, supporting robust classification and analysis. |
| InventoryCompletedTransactions | Enables warehouse managers to review and analyze successfully processed inventory transactions for reporting and auditing. |
| InventoryItemLots | Manages lot numbers for items within organizations, facilitating inventory control and traceability. |
| InventoryItemSerialNumbers | Handles the serial numbers for items in an organization, ensuring precise tracking and control. |
| TransferOrders | Handles the creation and management of inventory transfer orders, streamlining inventory redistribution. |
| ReceivingReceiptRequests | Handles receipt requests and advance shipment notices, supporting integration with Oracle Fusion applications. |
| ShipmentLines | Handles details for shipment lines, including search and retrieval based on attributes like order type, status, and reservations. |
| SupplyRequests | Manages incoming supply requests from external or Oracle applications, initiating supply creation to fulfill specific demands. |
| PurchaseOrdersForReceiving | Handles management of purchase orders available for receiving, streamlining the receiving process. |
| InboundShipments | Manages inbound shipment data, including headers, lines, lots, serials, and packing units with flexfield support. |
| CycleCountDefinitions | Manages the definition and configuration of cycle counts for inventory management. |
| PickSlipDetails | Manages transaction details related to pick slips, including item quantities, locators, and inventory control information like lot and serial numbers. |
| InventoryMovementRequests | Manages various types of movement requests, such as requisitions, replenishments, and pick waves. |
| InterfacedPickTransactions | Facilitates data exchange for pick transactions with warehouse and logistics systems after pick confirmation. |
| InventoryStagedTransactions | Handles the staging of inventory transactions, allowing operations such as creation, updates, and execution of transactions in online, background, or concurrent modes. |
| ShipmentTransactionRequests | Manages shipment transaction requests, allowing search and updates based on various shipment and transaction attributes. |
| InventoryConsumptionAdvices | Provides details about consumption advice for suppliers or legal entities, supporting inventory reconciliation. |
| TransferOrderLinesForReceiving | Manages details of transfer order lines eligible for receiving, providing insight into inventory flow. |
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including cancelling or submitting scheduled processes, and generating shipment requests.