SSIS Components for Oracle Fusion Cloud SCM

Build 23.0.8839

SupplyRequests

SupplyRequests

Columns

Name Type Description
InterfaceBatchNumber String Number that identifies the batch of supply requests that are sent to Oracle Supply Chain Orchestration Cloud to create supplies. The batch consists of one or more supply requests.
InterfaceSourceCode String Code that uniquely identifies the supply requesting applications. Values include DOO, YPS, INV, or EXT. The default value is set to EXT if no value is sent in the request.
SupplyRequestStatus String Status of the supply request that indicates whether the supply request has been processed successfully or has resulted in an error. Valid values include SUCCESS, ERROR.
SupplyOrderReferenceId Long Value that uniquely identifies the supply request sent to Oracle Supply Chain Orchestration Cloud.
SupplyOrderReferenceNumber [KEY] String Number that identifies the supply request sent to Oracle Supply Chain Orchestration Cloud.
SupplyOrderSource String Source application that requested the supply to Oracle Supply Chain Orchestration Cloud.
SupplyRequestDate Datetime Date when the supply was requested.
SupplyOrderStatus String SupplyOrderStatus of SupplyRequests
SupplyOrderNumber String SupplyOrderNumber of SupplyRequests
TrustedSource Int Value that indicates whether the supply-requesting application is a trusted source of Oracle Cloud applications. Contains one of the following values. 1: indicates a trusted source. 0: default value when a non-Oracle Cloud application sends the supply request.
ProcessRequestFlag Bool Contains one of the following values: Y or N. If Y, then the supply request is processed automatically and a supply order is created in Oracle Supply Chain Orchestration Cloud. If N, then the supply request needs to be manually processed by running the Process Supply Chain Orchestration Interface scheduled process. The default value is N.
TransferCostAmount Double Amount for the transfer cost on a transfer order line.
TransferCostCurrencyCode String Code that identifies the currency for the transfer cost amount.
TransferCostTypeName String Name of the shipping cost type. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Shipping Cost Types task.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
BindDestOrganizationCode String bindDestOrganizationCode
BindDocumentNumber String bindDocumentNumber
BindItemNumber String bindItemNumber
BindNeedByDate Datetime bindNeedByDate
BindSupplyOrderNumber String bindSupplyOrderNumber
BindSupplyOrderReferenceNumber String bindSupplyOrderReferenceNumber
BindSupplyOrderSource String bindSupplyOrderSource
BindSupplyRequestDate Datetime bindSupplyRequestDate
BindSupplyStatus String bindSupplyStatus
BindSupplyType String bindSupplyType
Finder String finder

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839