Inventory Availability Version 2
The details about quantity information in inventory, such as quantity on hand, quantity reserved against a demand, quantity available to transact, and available to reserve.
Life Cycle Status: Active
QName: {http://xmlns.oracle.com/apps/scm/inventory/materialAvailability/onhandQuantities/onhandQuantityServiceV2/}OnhandQuantityService
Service WSDL URL: https://servername/fscmService/OnhandQuantityServiceV2?WSDL
Logical Business Objects
-
SCM : Inventory Management : Onhand Quantity
Relationships
The following table describes how this service data object is related to other service data objects or business object services.
| Relationship Type | Object or Service |
|---|---|
|
Handles |
Operations
query
Operation to query the inventory on-hand and availability information
Life Cycle Status: Active
Request Payload
| Element Name | Type | Description |
|---|---|---|
|
organizationId |
long |
Organization identifier |
|
inventoryItemId |
long |
Inventory item identifier |
|
treeMode |
int |
Parameter to specify the mode in which the tree has to be created; 1 indicates Reservation mode, 2 indicates Transaction mode, 4 indicates Transfer to Regular mode and 5 indicates Transfer to Consigned mode. |
|
isRevisionControl |
boolean |
Parameter to specify if item revisions should be part of the tree |
|
isLotControl |
boolean |
Parameter to specify if item lots should be part of the tree |
|
gradeCode |
string |
Lot Grade Code |
|
assetSubOnly |
boolean |
Parameter to specify if only the asset subinventories should be while creating the tree |
|
demandSrcTypeId |
long |
Demand source type identifier |
|
demandSrcHdrId |
long |
Demand source header identifier |
|
demandSrcLineId |
long |
Demand source line identifier |
|
demandSrcName |
string |
Demand source name |
|
lotExpirationDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Lot expiration date |
|
onhandSource |
int |
"This parameter controls which subinventories and locators are used for building the tree. If it is 1, then only the ATPable subinventories and locators will be used. If it is 2, then only the nettable subinventores and locators are considered. If it is 3, the the subinventories and locators considered are not limited based on the nettable and ATPable flags" |
|
revision |
string |
Item revision |
|
lotNumber |
string |
Item lot number |
|
subinventoryCode |
string |
Subinventory code |
|
locatorId |
long |
Locator identifier |
|
tsfrSubCode |
string |
Transfer subinventory code |
|
tsfrLocId |
long |
Transfer locator identifier |
Response Payload
| Element Name | Type | Description |
|---|---|---|
|
result |
decimal |
Result of the operation that includes on-hand and availability information |
queryAllInventory
Operation to query the inventory on-hand and availability information for both consigned and non-consigned material
Life Cycle Status: Active
Request Payload
| Element Name | Type | Description |
|---|---|---|
|
organizationCode |
string |
Organization code identifier |
|
organizationId |
long |
Organization identifier |
|
itemName |
string |
Inventory item name identifier |
|
inventoryItemId |
long |
Inventory item identifier |
|
treeMode |
int |
Parameter to specify the mode in which the tree has to be created; 1 indicates Reservation mode, 2 indicates Transaction mode, 4 indicates Transfer to Regular mode and 5 indicates Transfer to Consigned mode. |
|
gradeCode |
string |
Lot Grade Code |
|
assetSubOnly |
boolean |
Parameter to specify if only the asset subinventories should be while creating the tree |
|
demandSrcTypeId |
long |
Demand source type identifier |
|
demandSrcHdrId |
long |
Demand source header identifier |
|
demandSrcLineId |
long |
Demand source line identifier |
|
demandSrcName |
string |
Demand source name |
|
excludeLotsAfterExpDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Lot expiration date |
|
subinventoryType |
int |
"This parameter controls which subinventories and locators are used for building the tree. If it is 1, then only the ATPable subinventories and locators will be used. If it is 2, then only the nettable subinventores and locators are considered. If it is 3, the the subinventories and locators considered are not limited based on the nettable and ATPable flags" |
|
revision |
string |
Item revision |
|
lotNumber |
string |
Item lot number |
|
subinventoryCode |
string |
Subinventory code |
|
locatorName |
string |
Locator name identifier |
|
locatorId |
long |
Locator identifier |
|
owningEntityCode |
string |
Owning Entity Code |
|
prcBUName |
string |
Procurement Business Unit Name |
|
vendorName |
string |
Vendor Name |
|
vendorNumber |
string |
Vendor Number |
|
consignmentAgreementNumber |
string |
Consignment Agreement Number |
|
owningEntityId |
long |
Owning Entity identifier |
Response Payload
| Element Name | Type | Description |
|---|---|---|
|
result |
Result of the operation that queries the inventory on-hand and availability information for both consigned and non-consigned material. |
Security
The following tables list the privileges required to perform the service operations, and the duty roles that each privilege is granted to.
Service Operations to Privileges Mapping
| Operation Name | Privilege Code | Privilege Name | Privilege Description |
|---|---|---|---|
|
All Operations |
INV_MANAGE_ONHAND_QUANTITY_WEB_SERVICE_PRIV |
Manage On-Hand Quantity Web Service |
Allows access to manage on-hand quantity web service. |
Privileges to Duty Roles Mapping
| Privilege Code | Granted to Duty Role Code | Granted to Duty Role Name | Granted To Duty Role Description |
|---|---|---|---|
|
INV_MANAGE_ONHAND_QUANTITY_WEB_SERVICE_PRIV |
ORA_INV_WAREHOUSE_TRANSACTION_MAINTENANCE_DUTY |
Warehouse Transaction Maintenance |
Perform inventory transactions such as subinventory transfers and miscellaneous receipts, process movement requests, and record cycle and physical inventory counts. |