SupplyRequests
Manages incoming supply requests from external or Oracle applications, initiating supply creation to fulfill specific demands.
Columns
Name | Type | Description |
InterfaceBatchNumber | String | Unique batch number that groups multiple supply requests sent to Oracle Supply Chain Orchestration Cloud for processing. |
InterfaceSourceCode | String | Identifier for the application requesting supply. Possible values: DOO (Order Management), YPS (Planning), INV (Inventory), or EXT (External system). Defaults to EXT if unspecified. |
SupplyRequestStatus | String | Current status of the supply request, indicating success or failure. Valid values: SUCCESS (processed successfully), ERROR (processing failed). |
SupplyOrderReferenceId | Long | Unique identifier assigned to the supply request within Oracle Supply Chain Orchestration Cloud. |
SupplyOrderReferenceNumber [KEY] | String | Reference number for the supply request in Oracle Supply Chain Orchestration Cloud. |
SupplyOrderSource | String | Application that originated the supply request, such as Order Management or an external system. |
SupplyRequestDate | Datetime | Timestamp indicating when the supply request was created. |
SupplyOrderStatus | String | Current status of the supply order, reflecting its progress in Oracle Supply Chain Orchestration Cloud. |
SupplyOrderNumber | String | Order number assigned to the supply order for tracking. |
TrustedSource | Int | Indicates whether the requesting application is a verified Oracle Cloud source. Values: 1 (trusted Oracle application), 0 (external or unverified source). |
ProcessRequestFlag | Bool | Determines automatic supply request processing. Values: Y (automatic creation of a supply order), N (manual processing required). Defaults to N. |
TransferCostAmount | Decimal | Monetary value of the transfer cost applied to a transfer order line. |
TransferCostCurrencyCode | String | Currency code for the transfer cost amount. |
TransferCostTypeName | String | Category of shipping cost. Manage values via the 'Manage Shipping Cost Types' task in Oracle Cloud. |
AllowPartialRequestFlag | Bool | Determines if partial supply request processing is allowed. Values: Y (valid lines processed, errors reported separately), N (entire request fails if any errors exist). Defaults to N. |
BindDestOrganizationCode | String | Destination organization code associated with the supply request. |
BindDocumentNumber | String | Document number linked to the supply request. |
BindItemNumber | String | Item number for the requested supply. |
BindNeedByDate | Datetime | Date by which the supply is required. |
BindSupplyOrderNumber | String | Supply order number linked to the request. |
BindSupplyOrderReferenceNumber | String | Reference number assigned to the supply order. |
BindSupplyOrderSource | String | Source application that initiated the supply order. |
BindSupplyRequestDate | Datetime | Timestamp when the supply request was originally submitted. |
BindSupplyStatus | String | Current supply request status at the time of processing. |
BindSupplyType | String | Type of supply request (for example, transfer order, purchase order, work order). |
Finder | String | Utility field used for retrieving specific supply request records. |