// fusionrest agent · sales and service (cx)

Subscription Products

subscriptionProducts Based on latest (2026.09)

Create, change, delete and look up Subscription Products, with product rollup, associated asset and bill lines. Actions include amend and calculate credit amount.

/crmRestApi/resources/11.13.18.05/subscriptionProducts
Operations
GET (list)GET (one)POST (create)PATCH (update)DELETE33 actions
Record key
SubscriptionProductPuid
Required on create
AccountingRuleIdBillToAccountIdBillToSiteUseIdBillingFrequencyCurrencyDefinitionOrganizationIdInventoryItemIdInvoicingRuleIdLineNumberStartDateSubscriptionIdSubscriptionProductPuidTransactionTypeName
At a glance
291 fields1 finders40 children1 file/large text fields
I want to…List the latest 25Count recordsGet one recordCreate oneUpdate one

Try it

Response fields ·
Filters (q)

Only attributes Oracle marks as searchable are offered.

Finder
Include children (expand)
Paging and options
limit
Endpoint and headers
GET /crmRestApi/resources/11.13.18.05/subscriptionProducts?fields=AccountingRuleId,AccountingRuleName,ActionCode,AlignBillingDay,AlignBillingFrom&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AccountingRuleId": 0,
      "AccountingRuleName": "<string>",
      "ActionCode": "<string>",
      "AlignBillingDay": 0,
      "AlignBillingFrom": "2026-01-31"
    }
  ],
  "count": 25,
  "hasMore": true,
  "limit": 25,
  "offset": 0
}

Shapes and placeholders, not real data. Replace https://<your-pod> and the login with your own: this site never sees them. Based on Oracle's latest (2026.09) REST specification.

Fields 291

AttributeTypeUse
AccountingRuleIdnumberRequired on createUpdatableSearchable
AccountingRuleNametextOptional on createUpdatable
ActionCodetextOptional on createUpdatable
AlignBillingDaynumberOptional on createUpdatable
AlignBillingFromdateOptional on createUpdatable
AllowanceGrantFlagtextOptional on createUpdatableSearchable
AllowancePoolingGrouptext · max 30Optional on createUpdatable
AmendCreditMethodtext · max 30Optional on createUpdatable
AmendCreditMethodNametextOptional on createUpdatable
AmendDescriptiontext · max 2000Optional on createUpdatable
AmendEffectiveDatedateOptional on createUpdatableSearchable
AmendReasontext · max 30Optional on createUpdatable
AmendReasonNametextOptional on createUpdatable
AmendSourceProductPuidtext · max 255Optional on createUpdatableSearchable
ApplyAdjustUsageFlagyes/no · max 1Optional on createUpdatableSearchable
AsyncFlagyes/noRead-only
AutoExtendFlagyes/noOptional on createUpdatable
BalanceFirstPartialPeriodOptiontext · max 30Optional on createUpdatable
BalanceLastPartialPeriodOptiontext · max 30Optional on createUpdatable
BalanceManagementErrortext · max 2000Optional on createUpdatableSearchable
BalanceProfileNametextOptional on createUpdatableSearchable
BalanceRegisterIdnumberOptional on createUpdatableSearchable
BalanceRegisterNumbertext · max 255Read-onlySearchable
BalanceTerminatedPartialPeriodOptiontext · max 30Optional on createUpdatable
BatchTagtext · max 30Optional on createUpdatableSearchable
BillFirstPartialPeriodOptiontext · max 30Optional on createUpdatableSearchable
BillFirstPartialPeriodThresholdnumberOptional on createUpdatableSearchable
BillFirstPartialPeriodThresholdTypetext · max 30Optional on createUpdatableSearchable
BillGenerationMethodCodetext · max 30Optional on createUpdatableSearchable
BillLastPartialPeriodOptiontext · max 30Optional on createUpdatableSearchable
BillLastPartialPeriodThresholdnumberOptional on createUpdatableSearchable
BillLastPartialPeriodThresholdTypetext · max 30Optional on createUpdatableSearchable
BillOnDaynumberOptional on createUpdatable
BillSetNametext · max 80Optional on createUpdatableSearchable
BillToAccountDescriptiontextOptional on createUpdatable
BillToAccountIdnumberRequired on createUpdatableSearchable
BillToAccountNumbertext · max 30Optional on createUpdatableSearchable
BillToAddresstextOptional on createUpdatable
BillToContactIdnumberOptional on createUpdatableSearchable
BillToContactNametextOptional on createUpdatable
BillToContactNumbertextOptional on createUpdatable
BillToPartyIdnumberOptional on createUpdatableSearchable
BillToPartyNametext · max 360Read-only
BillToPartyNumbertext · max 30Read-onlySearchable
BillToSitetextOptional on createUpdatable
BillToSiteNametext · max 255Optional on createUpdatableSearchable
BillToSiteNumbertextOptional on createUpdatable
BillToSiteUseIdnumberRequired on createUpdatableSearchable
BillingDateCodetext · max 30Optional on createUpdatable
BillingDateNametextOptional on createUpdatable
BillingFrequencytext · max 30Required on createUpdatable
BillingFrequencyNametextOptional on createUpdatable
BillingOffsetDaysnumberOptional on createUpdatable
CalculateEstimatedTaxFlagyes/noOptional on createUpdatable
CalculatedCreditAmountnumberOptional on createUpdatableSearchable
CancelDescriptiontext · max 2000Optional on createUpdatableSearchable
CancelReasontext · max 30Optional on createUpdatable
CanceledAmountnumberOptional on createUpdatable
CanceledDatedateOptional on createUpdatable
ChargeRulesFlagtextOptional on createUpdatableSearchable
CheckActiveExpiredAssetsExiststextOptional on createUpdatable
CheckHoldAssetsExiststextOptional on createUpdatable
ChurnPredictionTrendnumberOptional on createUpdatableSearchable
ChurnProbabilitynumberOptional on createUpdatableSearchable
CloseCreditMethodtext · max 30Optional on createUpdatable
CloseDescriptiontext · max 2000Optional on createUpdatableSearchable
CloseReasontext · max 30Optional on createUpdatable
ClosedAmountnumberOptional on createUpdatable
ClosedDatedateOptional on createUpdatableSearchable
CommitmentFlagtextOptional on createUpdatableSearchable
CorpCurrencyCodetext · max 15Optional on createUpdatable
CoverageNametextOptional on createUpdatableSearchable
CoverageScheduleIdnumberOptional on createUpdatableSearchable
CoveredItemSoldAssetGrpIdnumberOptional on createUpdatableSearchable
CreatedBytext · max 64Read-only
CreationDatedate-timeRead-only
CreditTypetext · max 30Optional on createUpdatable
CreditedAmountnumberOptional on createUpdatable
CurcyConvRateTypetext · max 30Optional on createUpdatable
Currencytext · max 15Required on create
CustomerPONumbertext · max 50Optional on createUpdatableSearchable
CustomerTrxTypeSequenceIdnumberOptional on createUpdatableSearchable
DefaultRevenueActiontext · max 30Optional on createUpdatable
DefinitionOrganizationIdnumberRequired on createSearchable
DeriveBalanceRegisterFlagyes/noOptional on createUpdatable
DescriptiontextOptional on createUpdatable
DisplaySequencenumberOptional on createUpdatable
DocumentTypeIdnumber · default 10Optional on createSearchable
DropAllowanceFlagtext · max 1Optional on createUpdatableSearchable
DropOneTimeChargeFlagyes/no · max 1Optional on createUpdatable
DurationnumberOptional on createUpdatable
EarlyTerminationFeenumberOptional on createUpdatable
EarlyTerminationPenaltytext · max 30Optional on createUpdatable
EarlyTerminationPenaltyNametextOptional on createUpdatableSearchable
EnableAdvBipTemplateFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
EnablePriceEscalationsFlagyes/no · max 1Optional on createUpdatableSearchable
EnablePricingTermsFlagyes/no · max 1Optional on createUpdatableSearchable
EnableProrateByDayyes/no · max 1Optional on createUpdatable
EnableUpfrontBillingFlagyes/no · max 1Optional on createUpdatable
EndDatedateOptional on createUpdatableSearchable
EntitlementPlanDescriptiontextOptional on createUpdatableSearchable
EntitlementPlanIdnumberOptional on createUpdatableSearchable
EntitlementPlanNametextOptional on createUpdatable
EntitlementPlanNumbertextOptional on createUpdatableSearchable
EntitlementTypetext · max 30Optional on createUpdatableSearchable
EstimateFlagtextOptional on createUpdatableSearchable
EstimatedTaxnumberOptional on createUpdatable
ExemptCertificateNumbertext · max 80Optional on createUpdatable
ExemptReasontext · max 30Optional on createUpdatable
ExternalAssetKeytext · max 120Optional on createUpdatableSearchable
ExternalParentAssetKeytext · max 120Optional on createUpdatableSearchable
ExternalPriceListIdtext · max 120Optional on createUpdatableSearchable
ExternalRootAssetKeytext · max 120Optional on createUpdatableSearchable
GenBillSchReqdFlagyes/no · max 1Optional on createUpdatableSearchable
GenerateBillFullPeriodFlagyes/no · max 1Optional on createUpdatable
GenerateBillingScheduletext · max 80Optional on createUpdatable
GracePeriodnumberOptional on createUpdatable
GroupingRuleNumberUsedtext · max 120Optional on createSearchable
InflightFlagyes/no · max 1Optional on createUpdatableSearchable
InterfaceOffsetDaysnumberOptional on createUpdatableSearchable
InventoryItemIdnumberRequired on createUpdatableSearchable
InvoiceBipReportCodetext · max 30Optional on createUpdatableSearchable
InvoiceTexttext · max 4000Optional on createUpdatable
InvoicedAmountnumberOptional on createUpdatable
InvoicingRuleIdnumberRequired on createUpdatableSearchable
InvoicingRuleNametextOptional on createUpdatable
IsProductCreatedFromAmendFlagyes/noOptional on createUpdatableSearchable
ItemUnitOfMeasuretext · max 15Optional on createUpdatable
ItemUnitOfMeasureMeaningtextOptional on createUpdatable
LastLifecycleUpdateDatedate-timeOptional on createUpdatableSearchable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdateLogintext · max 32Read-only
LastUpdatedBytext · max 64Read-only
LegacyRetrospectiveFlagtext · max 1Optional on createUpdatableSearchable
LineNumbertext · max 300Required on createSearchable
MilestoneBasedChargeFlagyes/noOptional on createUpdatableSearchable
MonthlyRecurringRevenuenumberOptional on createUpdatable
NegotiatedRatePlanFlagyes/no · max 1Read-onlySearchable
NextBillStartDatedateOptional on createUpdatable
NextPricingDatedateOptional on createUpdatable
OnetimeAmountnumberRead-onlySearchable
OrderFulfillLineIdnumberOptional on createUpdatableSearchable
OrderFulfillLineNumbernumberOptional on createUpdatableSearchable
OriginalSubscriptionProductPuidtext · max 240Read-onlySearchable
OutputTaxClassificationtext · max 50Optional on createUpdatable
OverrideCreditAmountnumberOptional on createUpdatableSearchable
PONumbertext · max 50Optional on createUpdatable
PaymentMethodtext · max 30Optional on createUpdatable
PaymentMethodNametextOptional on createUpdatable
PaymentTermsIdnumberOptional on createUpdatableSearchable
PaymentTermsNametextOptional on createUpdatable
PenaltyChargeNametextOptional on createUpdatableSearchable
PenaltyValuenumberOptional on createUpdatable
PendingActivationFlagyes/no · max 1Optional on createUpdatable
PeriodtextOptional on createUpdatable
PmProgramIdnumberRead-onlySearchable
PrePaymentNumbernumberOptional on createUpdatable
PriceAdjustmentBasistext · max 30Optional on createUpdatable
PriceAdjustmentPercentnumberOptional on createUpdatable
PriceAdjustmentTypetext · max 30Optional on createUpdatable
PriceAsOfdateOptional on createUpdatable
PriceListIdnumberOptional on createUpdatableSearchable
PriceListNametext · max 120Optional on createUpdatable
PriceTransactionOndateOptional on createUpdatable
PricingErrortext · max 2000Optional on createUpdatable
PricingSystemtextOptional on createUpdatable
PricingTermsAdjustmentPCTnumberOptional on createUpdatable
PricingTermsDurationnumberOptional on createUpdatable
PricingTermsPeriodtext · max 15Optional on createUpdatable
PricingTermsPricingMethodtext · max 30Optional on createUpdatableSearchable
PricingTermsStartDatedateOptional on createUpdatable
PrimaryPartyIdnumberRead-onlySearchable
PrimaryPartyNametext · max 255Read-onlySearchable
ProductChangeReasontext · max 300Optional on createUpdatable
ProductChangeScheduletext · max 30Optional on createUpdatable
ProductChangeScheduleFromdateOptional on createUpdatable
ProductChangeSequenceNumbernumberRead-onlySearchable
ProductFiscClassificationtext · max 30Optional on createUpdatable
ProductNametext · max 300Optional on createUpdatableSearchable
ProgramCodetext · max 30Read-only
ProgramNametext · max 120Read-only
ProgramOrganizationIdnumberRead-only
QuantitynumberOptional on createUpdatable
QuoteIdnumberOptional on createUpdatableSearchable
QuoteLineIdnumberOptional on createUpdatableSearchable
RatePlanDocumenttextOptional on createUpdatable
RatePlanDocumentIdnumberOptional on createUpdatableSearchable
RatePlanIdnumberOptional on createUpdatableSearchable
RatePlanNametextOptional on createUpdatable
RatePlanNumbertextOptional on createUpdatable
RatePlanTemplateIdnumberRead-only
RatePlanTemplateNumbertextRead-only
RatePlanYntextOptional on createUpdatable
RecurringAmountnumberRead-onlySearchable
RelatedInventoryItemIdnumberOptional on createUpdatable
RelatedProductDescriptiontextOptional on createUpdatable
RelatedProductNametext · max 300Optional on createUpdatable
RelationShipExistFlagtextOptional on createUpdatableSearchable
RenewPerpetuallyFlagyes/no · max 1Optional on createUpdatableSearchable
RenewSourceProductPuidtext · max 255Optional on createUpdatableSearchable
RenewalDurationnumberOptional on createUpdatable
RenewalDurationPeriodtext · max 30Optional on createUpdatableSearchable
RenewalDurationPeriodNametextOptional on createUpdatable
RenewalPaymentMethodtext · max 30Optional on createUpdatable
RenewalPaymentMethodNametextOptional on createUpdatable
RenewalPoNumbertext · max 50Optional on createUpdatable
RenewalPriceListIdnumberOptional on createUpdatable
RenewalPriceListNametext · max 255Optional on createUpdatableSearchable
RenewalRatePlanIdnumberOptional on createUpdatable
RenewalRatePlanNumbertextOptional on createUpdatable
RenewalSequenceNumbernumberRead-onlySearchable
RenewalTypetext · max 30Optional on createUpdatable
RenewalWireNumbertext · max 30Optional on createUpdatable
RenewedDatedateOptional on createUpdatableSearchable
RepriceFlagyes/noOptional on createUpdatable
RequestedAlignBillingDatedateOptional on createUpdatableSearchable
RequestedEntitlementPlanIdnumberOptional on createUpdatableSearchable
RequestedEntitlementPlanNumbertextOptional on createUpdatable
RequestedPriceListIdnumberOptional on createUpdatable
RequestedProgramIdnumberRead-onlySearchable
RequestedRatePlanIdnumberOptional on createUpdatable
RequestedRatePlanNumbertextOptional on createUpdatable
ResumeDatedateOptional on createUpdatable
ResumeDurationnumberOptional on createUpdatable
ResumePeriodtextOptional on createUpdatable
RetainSubsOnRenewFlagyes/no · max 1Optional on createUpdatableSearchable
RevenueOptiontext · max 30Optional on createUpdatableSearchable
RevenueOptionClosetext · max 30Read-onlySearchable
SalesOrderIdnumberOptional on createUpdatableSearchable
SalesOrderLineIdnumberOptional on createUpdatableSearchable
SalesOrderLineNumbertext · max 100Optional on createUpdatableSearchable
SalesOrderNumbertext · max 200Optional on createUpdatableSearchable
SalesProductTypetext · max 30Optional on createUpdatableSearchable
SelfReferenceSoldAssetGrpIdnumberOptional on createUpdatableSearchable
ShipToAccountDescriptiontextOptional on createUpdatable
ShipToAccountIdnumberOptional on createUpdatableSearchable
ShipToAccountNumbertextOptional on createUpdatable
ShipToContactIdnumberOptional on createUpdatableSearchable
ShipToContactNametextOptional on createUpdatable
ShipToContactNumbertextOptional on createUpdatable
ShipToContactPartyIdnumberRead-only
ShipToPartyIdnumberOptional on createUpdatableSearchable
ShipToPartyNametextOptional on createUpdatable
ShipToPartyNumbertext · max 30Read-onlySearchable
ShipToPartySiteIdnumberOptional on createUpdatableSearchable
ShipToPartySiteNametextOptional on createUpdatable
ShipToPartySiteNumbertextOptional on createUpdatable
SourceKeytext · max 120Optional on createUpdatable
SourceLineKeytext · max 120Optional on createUpdatable
SourceLineNumbertext · max 120Optional on createUpdatable
SourceNumbertext · max 120Optional on createUpdatable
SourceSystemtext · max 30Optional on createUpdatableSearchable
StartDatedateRequired on createUpdatableSearchable
Statustext · max 30 · default DRAFTOptional on createUpdatableSearchable
StatusMeaningtext · max 80Read-onlySearchable
SubscriptionIdnumberRequired on createUpdatableSearchable
SubscriptionNumbertext · max 120 · default Subscriptions.SubscriptionNumberOptional on createUpdatableSearchable
SubscriptionProductIdnumberOptional on createUpdatableSearchable
SubscriptionProductPuidtext · max 120Required on createSearchable
SummarizedBillingFlagyes/no · max 1Optional on createSearchable
SummarizedRatingFlagyes/noOptional on createUpdatableSearchable
SuspendCreditMethodtext · max 30Optional on createUpdatable
SuspendReasontext · max 30Optional on createUpdatable
SuspendedDatedateOptional on createUpdatableSearchable
TaxClassificationMeaningtextRead-only
TaxErrortext · max 2000Optional on createUpdatable
TaxExemptionHandlingtext · max 30Optional on createUpdatable
TaxExemptionHandlingNametextOptional on createUpdatable
TcvWithTotalUsageChargenumberRead-onlySearchable
TotalContractValuenumberOptional on createUpdatableSearchable
TotalUsageChargenumberRead-onlySearchable
TransactionTypeNametext · max 30Required on createUpdatable
UOMConversionsEnabledFlagyes/noOptional on createUpdatable
UnifiedEntitlementFlagyes/no · max 1Read-onlySearchable
UnitPricenumberOptional on createUpdatable
UpdateFlagyes/noOptional on createUpdatableSearchable
UpfrontBillingPeriodtext · max 30Optional on createUpdatableSearchable
UpfrontBillingPeriodNametextOptional on createUpdatable
UpfrontBillingTriggertext · max 30Optional on createUpdatableSearchable
UpfrontBillingTriggerNametextOptional on createUpdatable
UsageEventAllowanceInvTemplatetext · max 200Optional on createUpdatableSearchable
UsageEventCommitmentInvTemplatetext · max 200Optional on createUpdatableSearchable
UsageEventEstimateInvTemplatetext · max 200Optional on createUpdatableSearchable
UsageEventRegularInvTemplatetext · max 200Optional on createUpdatableSearchable
UsageInvoiceLayoutTemplatetext · max 200Optional on createUpdatable
UsageInvoicedAmountnumberRead-onlySearchable
ValidationStatustext · max 1Read-onlySearchable
VolumeRatingFlagyes/noOptional on createUpdatableSearchable
WareHouseNametextOptional on createUpdatable
WarehouseIdnumberOptional on createUpdatableSearchable
WireNumbertext · max 30Optional on createUpdatable

Names, types, labels and flags from Oracle's REST specification (latest (2026.09)). Flexfield and custom attributes vary by pod: check /describe for yours.

Finders 1

Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.

Check a payload

Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.

Children 40

Child resources sit under one record: /crmRestApi/resources/11.13.18.05/subscriptionProducts/{SubscriptionProductPuid}/child/<name>. Add them to a GET with expand.

Actions 33

Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.

Use in AI Agent Studio

More in For Builders.

Pitfalls