SupplyRequests
Manages incoming supply requests from external or Oracle applications, initiating supply creation to fulfill specific demands.
Columns
| Name | Type | SupportedFinders | 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 | FindBySupplyRequestReferenceNumber, PrimaryKey, bySupplyOrderReferenceNumber | 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 | FindBySupplyDestination | Destination organization code associated with the supply request. |
| BindDocumentNumber | String | FindBySupplyExecutionDocumentNumber | Document number linked to the supply request. |
| BindItemNumber | String | FindBySupplyRequestItemNumber | Item number for the requested supply. |
| BindNeedByDate | Datetime | FindByRequestedDeliveryDateTo, findByRequestedDeliveryDateFrom | Date by which the supply is required. |
| BindSupplyOrderNumber | String | FindBySupplyOrderNumber | Supply order number linked to the request. |
| BindSupplyOrderReferenceNumber | String | FindBySupplyRequestReferenceNumber | Reference number assigned to the supply order. |
| BindSupplyOrderSource | String | FindBySupplyRequestSource | Source application that initiated the supply order. |
| BindSupplyRequestDate | Datetime | FindBySupplyRequestDateFrom, findBySupplyRequestDateTo | Timestamp when the supply request was originally submitted. |
| BindSupplyStatus | String | FindBySupplyStatus | Current supply request status at the time of processing. |
| BindSupplyType | String | FindBySupplyType | Type of supply request (for example, transfer order, purchase order, work order). |
| Finder | String | Utility field used for retrieving specific supply request records. |