ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175