InventoryStagedReservations
The Inventory Staged Reservations resource enables applications to get, create, update, and delete an inventory reservation interface record in Oracle Fusion Cloud Inventory Management and process reservation interface records.
Columns
| Name | Type | Description |
| ReservationInterfaceId | String | Value that identifies a unique reservation record. |
| ReservationBatchId | String | Value that identifies a reservation batch. |
| ReservationActionCode | String | Value that identifies the reservation action that needs to be performed. Valis values are 1, 2, 3, and 4. 1 indicates Create, 2 indicates Update, 3 indicates Delete, and 4 indicates Transfer. |
| ProcessMode | String | Mode in which interface record has to be processed. It has values : Online,Concurrent,Background. Value that identifies the mode of the processing the inventory attribute transaction request lines. It has values : Online,Concurrent,Background. Valid values include 1, 2, and 3. 1 indicates online, 2 indicates concurrent, and 3 indicates background. 1 indicates that the records are inserted in the Inventory Reservations interface with the transaction mode as 1. This invokes Manage Reservations Interface scheduled process to process the records in the reservation interface. 2 indicates that the records are inserted in the Inventory Reservations interface with transaction mode as 2. This invokes Manage Reservations Interface to process the records in the reservation interface. 3 indicates that the records are inserted in the Inventory Reservations interface with transaction mode as 3. User needs to invoke the Manage Reservations Interface scheduled process manually to process the records in the reservation interface. |
| ProcessModeCode | String | Value that identifies the process mode to be used to process the interface records. Valid values are 1, 2, and 3. 1 indicates online mode of processing, 2 indicates concurrent mode, and 3 indicates background mode. |
| RequirementDate | Date | Indicates the requirement date for the reservation. |
| ItemNumber | String | Identifies the inventory item number. |
| InventoryItemId | String | Value that uniquely identifies the inventory item. |
| OrganizationName | String | Identifies organization name in which reservation function is performed |
| OrganizationCode | String | Organization for which the reservation is created. |
| OrganizationId | String | Value that uniquely identifies the organization for which the reservation is created. |
| DemandSourceTypeName | String | Identifies the type of demand. Valid values are Sales Order, Account, Account Alias, Transfer Order, and User defined. |
| DemandSourceTypeId | String | Value that identifies the type of demand. Valid values are 2, 3, 6, 8,and 13. 2 indicates Sales Order, 3 indicates Account, 6 indicates Account Alias, 8 indicates Transfer Order and 13 indicates User defined. |
| DemandSourceName | String | Identifies the user defined demand. |
| DemandSourceHeaderNumber | String | Identifies the header number for source of demand. |
| DemandSourceHeaderId | String | Value that identifies the header number for source of demand. |
| DemandSourceLineNumber | String | Identifies the line number for demand source. |
| DemandSourceLineId | String | Value that identifies the line number for demand source. |
| SourceFulfillmentLineId | String | Value that identifies the source fulfillment line for sales order demand. |
| ReservationQuantity | String | Identifies the quantity to be reserved in reservation UOM code. |
| ReservationUnitOfMeasure | String | Identifies the unit of measure for the reservation record. |
| ReservationUOMCode | String | Abbreviation that identifies the unit of measure that the user chooses when placing the reservation. |
| PrimaryReservationQuantity | String | Reserved quantity expressed in the primary unit of measure of the item. |
| PrimaryUnitOfMeasure | String | Primary unit of measure of the item. |
| PrimaryUOMCode | String | Abbreviation that identifies the primary unit of measure. |
| SecondaryReservationQuantity | String | Reservation quantity expressed in the secondary unit of measure. |
| SecondaryUnitOfMeasure | String | Secondary unit of measure of the item. |
| SecondaryUOMCode | String | Abbreviation that identifies the secondary unit of measure. |
| SupplySourceTypeName | String | Type of the supply document. A list of accepted values is defined in the lookup type INV_RESERVATION_SUPPLY_SRC_TYP. Values include Purchase Order, On Hand, Requisition, Transfer Order Return, Work Order, or Transfer Order. |
| SupplySourceTypeId | String | Value that uniquely identifies the type of the supply document. |
| SupplySourceHeaderNumber | String | Identifies the supply document. |
| SupplySourceHeaderId | String | Value that identifies the supply document. |
| SupplySourceLineNumber | String | Line number in the supply document. |
| SupplySourceLineId | String | Value that identifies the line number in the supply document. |
| Revision | String | Revision of the item. Applies when the warehouse enables the item for revision control. |
| SubinventoryCode | String | Name of the subinventory that the warehouse uses to make the reservation. |
| Locator | String | Abbreviation that identifies the subinventory that the warehouse uses to reserve inventory for the item. It is typically a physical area in the subinventory, such as a row, aisle, bin, or shelf, that stores the item. |
| LocatorId | String | Value that uniquely identifies the locator for the reservation. |
| LotNumber | String | Number that identifies an item or group of items. Applies when the warehouse places the item under lot control. |
| SupplyProjectNumber | String | Number that identifies the project for the supply document. |
| SupplyProjectId | String | Value that uniquely identifies the project for the supply document. |
| SupplyTaskNumber | String | Number that identifies the task corresponding to a project for the supply document. |
| SupplyTaskId | String | Value that uniquely identifies the task corresponding to a project for the supply document. |
| ToOrganizationName | String | Identifies the organization name to which the reservation is updated or transferred. |
| ToOrganizationId | String | Value that identifies the organization name to which the reservation is updated or transferred. |
| ToDemandSourceTypeName | String | Identifies the destination demand source type name to update or transfer the reservation. Valid values are Sales Order, Account, Account Alias, Transfer Order, and User defined. |
| ToDemandSourceTypeId | String | Identifies the destination demand source type name to update or transfer the reservation. Valid values are 2, 3, 6, 8,and 13. 2 indicates Sales Order, 3 indicates Account, 6 indicates Account Alias, 8 indicates Transfer Order and 13 indicates User defined. |
| ToDemandSourceName | String | Identifies the header number for source of demand to update or transfer the reservation. |
| ToDemandSourceHeaderNumber | String | Identifies the header number for destination source of demand to update or transfer the reservation. |
| ToDemandSourceHeaderId | String | Value that identifies the header number for destination source of demand to update or transfer the reservation. |
| ToDemandSourceLineNumber | String | Identifies the line number corresponding to a header number for destination source of demand to update or transfer the reservation. |
| ToDemandSourceLineId | String | Value that identifies the line number corresponding to a header number for destination source of demand to update or transfer the reservation. |
| ToSupplySourceTypeName | String | Identifies the destination supply source name to update or transfer the reservation. |
| ToSupplySourceTypeId | String | Value that identifies the destination supply source nameto update or transfer the reservation. |
| ToSupplySourceHeaderNumber | String | Identifies the header number for a destination supply source to update or transfer the reservation. |
| ToSupplySourceHeaderId | String | Value that identifies the header number for a destination supply source to update or transfer the reservation. |
| ToSupplySourceLineNumber | String | Identifies the line number corresponding to a header number for a destination supply source to update or transfer the reservation. |
| ToSupplySourceLineId | String | Value that identifies the line number corresponding to a header number for a destination supply source to update or transfer the reservation. |
| ToRevision | String | Identifies the destination revision for a revision controlled reserved item. |
| ToSubinventoryCode | String | Identifies the destination subinventory to update or transfer the reservation. |
| ToLocator | String | Identifies the destination locator to update or transfer the reservation. |
| ToLocatorId | String | Value that identifies the destination locator to update or transfer the reservation. |
| ToLotNumber | String | Identifies the lot number to update or transfer the reservation. |
| ToSupplyProjectNumber | String | Name of the destination supply project to update or transfer the reservation. |
| ToSupplyProjectId | String | Number that identifis the destination supply project to update or transfer the reservation. |
| ToSupplyTaskNumber | String | Identifies the destination task used to update and transfer the reservation. |
| ToSupplyTaskId | String | Value that identifies the destination task used to update and transfer the reservation. |
| LockCode | String | Value that identifies if the record is locked to prevent the record from being picked by another reservation interface process. Valid values are 1 and 2. 1 indicates that the record is locked and 2 indicates that the record is available for a lock to be placed on it. The default value is 2. |
| RowStatusCode | String | Indicates the status of the request. Valid values are 1 and 3. 1 indicates Active, and 3 indicates Error. |
| ErrorCode | String | Error code returned by the reservations interface manager. |
| ErrorExplanationCode | String | Provides the error explanation code for the record in the error. |
| ErrorExplanation | String | Indicates the error message code for the record in the error. |