Power BI Connector for Oracle Fusion Cloud SCM

Build 26.0.9770

SalesOrderActionRequestsmanualPriceAdjustments

Manages manual price adjustments applied through sales order action requests, including adjustment amounts, types, and reasons.

Columns

Name Type SupportedFinders Description
SalesOrderActionRequestsActionRequestId [KEY] Long Unique identifier for the action request.
AdjustmentAmount Decimal Amount of the manual price adjustment for a charge, which can be specified as either a fixed amount or a percentage.
AdjustmentElementBasis String Basis used by pricing to calculate the manual price adjustment, which can be either QP_NET_PRICE or QP_LIST_PRICE.
AdjustmentElementBasisName String Name of the basis used by pricing to calculate the manual price adjustment, which can be either Your Price or List Price.
AdjustmentType String Method that pricing uses to calculate the manual price adjustment for the item. A list of accepted values is defined in the lookup type ORA_QP_LINE_ADJ_TYPES.
AdjustmentTypeCode String Abbreviation that identifies the type of manual price adjustment. A list of accepted values is defined in the lookup type ORA_QP_LINE_ADJ_TYPES.
ChargeDefinition String Definition of the charge that pricing uses to apply a manual price adjustment.
ChargeDefinitionCode String Abbreviation that identifies the definition of the charge that pricing uses to apply a manual price adjustment.
Comments String Comments that describe the manual price adjustment.
PricePeriodicity String Price periodicity of the recurring charge where pricing applies the manual price adjustment.
PricePeriodicityCode String Abbreviation that identifies the price periodicity of the recurring charge, where pricing applies the manual price adjustment.
Reason String Reason for the manual price adjustment.
ReasonCode String Abbreviation that identifies the reason for the manual price adjustment.
SequenceNumber [KEY] Decimal Sequence that pricing uses to apply the manual price adjustment to other manual price adjustments.
SourceManualPriceAdjustmentId String Value that uniquely identifies the manual price adjustment. The source application assigns this value.
UsageUOMCode String Abbreviation that identifies the usage UOM of the usage charge, where pricing applies the manual price adjustment.
EffectivityTypeCode String Abbreviation that identifies the type of effectiveness to be used for the price adjustment. A list of accepted values is defined in the lookup type ORA_OSS_PRICE_ADJ_EFFECTIVITY. This abbreviation is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages feature.
EffectivityType String Type of effectiveness for the price adjustment, available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages feature.
EffectivePeriodFrom Decimal Number that identifies the period when the price adjustment starts. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features.
EffectivePeriodUntil Decimal Number that identifies the period when the price adjustment ends. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features.
EffectiveNumberOfPeriods Decimal Number of periods to use for the price adjustment. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features.
UsageUOM String Usage UOM of the usage charge where pricing applies, the manual price adjustment.
ActionRequestId Long PrimaryKey Value that uniquely identifies the action request associated with the manual price adjustment.
Finder String The name of the finder method used to search and filter manual price adjustment records.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770