SalesOrdersForOrderHub
The Sales Orders for Order Hub resource gets, creates, and updates sales orders in Oracle Order Management Cloud. A sales order captures order header details, such as customer, items ordered, and pricing. Here are the differences in REST API compared to the Order Import web service: - To extend the processing logic to set the default values and to validate and transform the order during order creation and submission through REST API, create an order management extension. The Sales Orders for Order Hub resource doesn't support the pre-transformation, product transformation, and post-transformation rules. - The Sales Orders for Order Hub resource also doesn't support automatic creation of customer, address, or contact information while creating an order. The resource also doesn't handle any cross-referencing of the primary and reference data. Common error handling: - 404 Not Found: Ensure that the correct parameter is used in the URL; for example, for linesUniqID, use the hash-generated key. Additionally, this error can occur if the user that is used while invoking the GET and Updating the order doesn't have business unit data security granted. - 500 Internal Server Error: Ensure that the EFF deployment is completed successfully or there are no errors encountered while deploying the flexfield. - 504 Gateway Timeout: The Order request may still be processed after the gateway time out; however, ensure that there are no validation failures that the order runs into while processing. You may need to run GET action to validate that the order is created.
Columns
Name | Type | Description |
HeaderId [KEY] | Long | HeaderId of SalesOrdersForOrderHub |
OrderNumber | String | OrderNumber of SalesOrdersForOrderHub |
SourceTransactionNumber | String | SourceTransactionNumber of SalesOrdersForOrderHub |
SourceTransactionSystem | String | SourceTransactionSystem of SalesOrdersForOrderHub |
SourceTransactionId | String | SourceTransactionId of SalesOrdersForOrderHub |
BusinessUnitId | Long | BusinessUnitId of SalesOrdersForOrderHub |
BusinessUnitName | String | BusinessUnitName of SalesOrdersForOrderHub |
TransactionOn | Datetime | TransactionOn of SalesOrdersForOrderHub |
BuyingPartyId | Long | BuyingPartyId of SalesOrdersForOrderHub |
BuyingPartyName | String | BuyingPartyName of SalesOrdersForOrderHub |
BuyingPartyNumber | String | BuyingPartyNumber of SalesOrdersForOrderHub |
BuyingPartyPersonFirstName | String | BuyingPartyPersonFirstName of SalesOrdersForOrderHub |
BuyingPartyPersonLastName | String | BuyingPartyPersonLastName of SalesOrdersForOrderHub |
BuyingPartyPersonMiddleName | String | BuyingPartyPersonMiddleName of SalesOrdersForOrderHub |
BuyingPartyPersonNameSuffix | String | BuyingPartyPersonNameSuffix of SalesOrdersForOrderHub |
BuyingPartyPersonTitle | String | BuyingPartyPersonTitle of SalesOrdersForOrderHub |
BuyingPartyContactId | Long | BuyingPartyContactId of SalesOrdersForOrderHub |
BuyingPartyContactName | String | BuyingPartyContactName of SalesOrdersForOrderHub |
BuyingPartyContactNumber | String | BuyingPartyContactNumber of SalesOrdersForOrderHub |
BuyingPartyContactFirstName | String | BuyingPartyContactFirstName of SalesOrdersForOrderHub |
BuyingPartyContactLastName | String | BuyingPartyContactLastName of SalesOrdersForOrderHub |
BuyingPartyContactMiddleName | String | BuyingPartyContactMiddleName of SalesOrdersForOrderHub |
BuyingPartyContactNameSuffix | String | BuyingPartyContactNameSuffix of SalesOrdersForOrderHub |
BuyingPartyContactTitle | String | BuyingPartyContactTitle of SalesOrdersForOrderHub |
PreferredSoldToContactPointId | Long | PreferredSoldToContactPointId of SalesOrdersForOrderHub |
CustomerPONumber | String | CustomerPONumber of SalesOrdersForOrderHub |
TransactionTypeCode | String | TransactionTypeCode of SalesOrdersForOrderHub |
TransactionType | String | TransactionType of SalesOrdersForOrderHub |
SubstituteAllowedFlag | Bool | SubstituteAllowedFlag of SalesOrdersForOrderHub |
PackingInstructions | String | PackingInstructions of SalesOrdersForOrderHub |
ShippingInstructions | String | ShippingInstructions of SalesOrdersForOrderHub |
ShipsetFlag | Bool | ShipsetFlag of SalesOrdersForOrderHub |
PartialShipAllowedFlag | Bool | PartialShipAllowedFlag of SalesOrdersForOrderHub |
RequestedShipDate | Datetime | RequestedShipDate of SalesOrdersForOrderHub |
RequestedArrivalDate | Datetime | RequestedArrivalDate of SalesOrdersForOrderHub |
LatestAcceptableShipDate | Datetime | LatestAcceptableShipDate of SalesOrdersForOrderHub |
LatestAcceptableArrivalDate | Datetime | LatestAcceptableArrivalDate of SalesOrdersForOrderHub |
EarliestAcceptableShipDate | Datetime | EarliestAcceptableShipDate of SalesOrdersForOrderHub |
ShipmentPriorityCode | String | ShipmentPriorityCode of SalesOrdersForOrderHub |
ShipmentPriority | String | ShipmentPriority of SalesOrdersForOrderHub |
ShippingCarrierId | Long | ShippingCarrierId of SalesOrdersForOrderHub |
ShippingCarrier | String | ShippingCarrier of SalesOrdersForOrderHub |
ShippingServiceLevelCode | String | ShippingServiceLevelCode of SalesOrdersForOrderHub |
ShippingServiceLevel | String | ShippingServiceLevel of SalesOrdersForOrderHub |
ShippingModeCode | String | ShippingModeCode of SalesOrdersForOrderHub |
ShippingMode | String | ShippingMode of SalesOrdersForOrderHub |
FOBPointCode | String | FOBPointCode of SalesOrdersForOrderHub |
FOBPoint | String | FOBPoint of SalesOrdersForOrderHub |
DemandClassCode | String | DemandClassCode of SalesOrdersForOrderHub |
DemandClass | String | DemandClass of SalesOrdersForOrderHub |
FreightTermsCode | String | FreightTermsCode of SalesOrdersForOrderHub |
FreightTerms | String | FreightTerms of SalesOrdersForOrderHub |
RequestedFulfillmentOrganizationId | Long | RequestedFulfillmentOrganizationId of SalesOrdersForOrderHub |
RequestedFulfillmentOrganizationCode | String | RequestedFulfillmentOrganizationCode of SalesOrdersForOrderHub |
RequestedFulfillmentOrganizationName | String | RequestedFulfillmentOrganizationName of SalesOrdersForOrderHub |
SupplierId | Long | SupplierId of SalesOrdersForOrderHub |
SupplierName | String | SupplierName of SalesOrdersForOrderHub |
SupplierSiteId | Long | SupplierSiteId of SalesOrdersForOrderHub |
PaymentTermsCode | Long | PaymentTermsCode of SalesOrdersForOrderHub |
PaymentTerms | String | PaymentTerms of SalesOrdersForOrderHub |
SalespersonId | Long | SalespersonId of SalesOrdersForOrderHub |
Salesperson | String | Salesperson of SalesOrdersForOrderHub |
PricedOn | Datetime | PricedOn of SalesOrdersForOrderHub |
TransactionalCurrencyCode | String | TransactionalCurrencyCode of SalesOrdersForOrderHub |
TransactionalCurrencyName | String | TransactionalCurrencyName of SalesOrdersForOrderHub |
AppliedCurrencyCode | String | AppliedCurrencyCode of SalesOrdersForOrderHub |
CurrencyConversionDate | Datetime | CurrencyConversionDate of SalesOrdersForOrderHub |
CurrencyConversionRate | Decimal | CurrencyConversionRate of SalesOrdersForOrderHub |
CurrencyConversionType | String | CurrencyConversionType of SalesOrdersForOrderHub |
PricingSegmentCode | String | PricingSegmentCode of SalesOrdersForOrderHub |
PricingSegment | String | PricingSegment of SalesOrdersForOrderHub |
PricingStrategyId | Long | PricingStrategyId of SalesOrdersForOrderHub |
PricingStrategyName | String | PricingStrategyName of SalesOrdersForOrderHub |
AllowCurrencyOverrideFlag | Bool | AllowCurrencyOverrideFlag of SalesOrdersForOrderHub |
SegmentExplanationMessageName | String | SegmentExplanationMessageName of SalesOrdersForOrderHub |
PricingSegmentExplanation | String | PricingSegmentExplanation of SalesOrdersForOrderHub |
StrategyExplanationMessageName | String | StrategyExplanationMessageName of SalesOrdersForOrderHub |
PricingStrategyExplanation | String | PricingStrategyExplanation of SalesOrdersForOrderHub |
SalesChannelCode | String | SalesChannelCode of SalesOrdersForOrderHub |
SalesChannel | String | SalesChannel of SalesOrdersForOrderHub |
Comments | String | Comments of SalesOrdersForOrderHub |
StatusCode | String | StatusCode of SalesOrdersForOrderHub |
Status | String | Status of SalesOrdersForOrderHub |
OnHoldFlag | Bool | OnHoldFlag of SalesOrdersForOrderHub |
CanceledFlag | Bool | CanceledFlag of SalesOrdersForOrderHub |
CancelReasonCode | String | CancelReasonCode of SalesOrdersForOrderHub |
CancelReason | String | CancelReason of SalesOrdersForOrderHub |
RequestedCancelDate | Datetime | RequestedCancelDate of SalesOrdersForOrderHub |
RequestingBusinessUnitId | Long | RequestingBusinessUnitId of SalesOrdersForOrderHub |
RequestingBusinessUnitName | String | RequestingBusinessUnitName of SalesOrdersForOrderHub |
RequestingLegalEntityId | Long | RequestingLegalEntityId of SalesOrdersForOrderHub |
RequestingLegalEntity | String | RequestingLegalEntity of SalesOrdersForOrderHub |
FreezePriceFlag | Bool | FreezePriceFlag of SalesOrdersForOrderHub |
FreezeShippingChargeFlag | Bool | FreezeShippingChargeFlag of SalesOrdersForOrderHub |
FreezeTaxFlag | Bool | FreezeTaxFlag of SalesOrdersForOrderHub |
SubmittedFlag | Bool | SubmittedFlag of SalesOrdersForOrderHub |
SubmittedBy | String | SubmittedBy of SalesOrdersForOrderHub |
SubmittedDate | Datetime | SubmittedDate of SalesOrdersForOrderHub |
TransactionDocumentTypeCode | String | TransactionDocumentTypeCode of SalesOrdersForOrderHub |
PreCreditCheckedFlag | Bool | PreCreditCheckedFlag of SalesOrdersForOrderHub |
RevisionSourceSystem | String | RevisionSourceSystem of SalesOrdersForOrderHub |
SourceTransactionRevisionNumber | Long | SourceTransactionRevisionNumber of SalesOrdersForOrderHub |
TradeComplianceResultCode | String | TradeComplianceResultCode of SalesOrdersForOrderHub |
TradeComplianceResult | String | TradeComplianceResult of SalesOrdersForOrderHub |
LastUpdatedBy | String | LastUpdatedBy of SalesOrdersForOrderHub |
LastUpdateDate | Datetime | LastUpdateDate of SalesOrdersForOrderHub |
CreatedBy | String | CreatedBy of SalesOrdersForOrderHub |
CreationDate | Datetime | CreationDate of SalesOrdersForOrderHub |
OpenFlag | Bool | OpenFlag of SalesOrdersForOrderHub |
OrigSystemDocumentReference | String | OrigSystemDocumentReference of SalesOrdersForOrderHub |
OrderKey | String | OrderKey of SalesOrdersForOrderHub |
AppliedCurrencyName | String | AppliedCurrencyName of SalesOrdersForOrderHub |
SupplierSiteName | String | SupplierSiteName of SalesOrdersForOrderHub |
MessageText | String | MessageText of SalesOrdersForOrderHub |
AgreementHeaderId | Long | AgreementHeaderId of SalesOrdersForOrderHub |
AgreementNumber | String | AgreementNumber of SalesOrdersForOrderHub |
AgreementVersionNumber | Long | AgreementVersionNumber of SalesOrdersForOrderHub |
Finder | String | Finder of SalesOrdersForOrderHub |
FromDate | Date | FromDate of SalesOrdersForOrderHub |
ToDate | Date | ToDate of SalesOrdersForOrderHub |