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. |