Power BI Connector for Oracle Fusion Cloud SCM

Build 24.0.9060

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

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