Inventory Management
In the Inventory Management data model, the provider 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 provider.
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.