// fusionrest agent · sales and service (cx)

Subscription Balance Profiles

subscriptionBalanceProfiles Based on latest (2026.09)

Create, change, delete and look up Subscription Balance Profiles, with group criteria, group criteria balance predicates and profile balance codes. Actions include activate and de activate.

/crmRestApi/resources/11.13.18.05/subscriptionBalanceProfiles
Operations
GET (list)GET (one)POST (create)PATCH (update)DELETE2 actions
Record key
BalanceProfileNumber
Required on create
BalanceProfileNameBalanceProfileNumber
At a glance
43 fields2 finders6 children
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/subscriptionBalanceProfiles?fields=AllowanceEffectivityType,AmendNewPartialPeriodOption,AmendTerminatedPartialPeriodOption,ApplyChargeAdjustmentRatingFlag,BalanceProfileId&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AllowanceEffectivityType": "ORA_OSS_BAL_REGISTER_PERIOD",
      "AmendNewPartialPeriodOption": "<string, max 30>",
      "AmendTerminatedPartialPeriodOption": "<string, max 30>",
      "ApplyChargeAdjustmentRatingFlag": true,
      "BalanceProfileId": 0
    }
  ],
  "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 43

AttributeTypeUse
AllowanceEffectivityTypetext · max 30 · default ORA_OSS_BAL_REGISTER_PERIODOptional on createUpdatableSearchable
AmendNewPartialPeriodOptiontext · max 30Optional on createUpdatableSearchable
AmendTerminatedPartialPeriodOptiontext · max 30Optional on createUpdatableSearchable
ApplyChargeAdjustmentRatingFlagyes/no · max 1 · default trueOptional on createUpdatableSearchable
BalanceProfileIdnumberOptional on createSearchable
BalanceProfileNametext · max 120Required on createUpdatableSearchable
BalanceProfileNumbertext · max 120Required on createSearchable
BalanceProfileStatustext · max 30 · default ORA_OSS_DRAFTOptional on createUpdatableSearchable
BillOnDaynumberOptional on createUpdatableSearchable
BillPeriodAlignDatedateOptional on createUpdatableSearchable
BillingDatetext · max 80Optional on createUpdatableSearchable
BillingDateCodetext · max 30Optional on createUpdatableSearchable
BillingFrequencytext · max 30Optional on createUpdatableSearchable
BillingFrequencyUnitOfMeasuretext · max 25Optional on createUpdatableSearchable
BillingOffsetDaysnumberOptional on createUpdatableSearchable
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
EstimateDateCodetext · max 30Optional on createUpdatableSearchable
EstimateOffsetDaysnumberOptional on createUpdatableSearchable
EventTypetext · max 30Optional on createUpdatableSearchable
EventTypeIdnumberOptional on createUpdatableSearchable
FirstPartialPeriodOptiontext · max 30Optional on createUpdatableSearchable
FixedDaysInMonthnumber · default 31Optional on createUpdatableSearchable
InterfaceOffsetDaysnumberOptional on createUpdatableSearchable
InvoicingRuleIdnumberOptional on createUpdatableSearchable
InvoicingRuleNametext · max 30Optional on createUpdatableSearchable
InvoicingRuleNameForResttext · max 30Optional on createUpdatableSearchable
LastPartialPeriodOptiontext · max 30Optional on createUpdatableSearchable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdateLogintext · max 32Read-onlySearchable
LastUpdatedBytext · max 64Read-onlySearchable
ManualTrueupFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
ObjectVersionNumbernumberOptional on createUpdatableSearchable
PartialPeriodMonthTypetext · max 30 · default ORA_FIXEDOptional on createUpdatableSearchable
PeriodAlignDateTypetext · max 30 · default ORA_OSS_BAL_REG_AND_BILL_LINESOptional on createUpdatableSearchable
RatePlanFlagyes/no · max 1Optional on createSearchable
RegisterUpdateFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
SummarizedOffsetDaysnumberOptional on createUpdatableSearchable
SummarizedRatingDateCodetext · max 30Optional on createUpdatableSearchable
TerminatedPartialPeriodOptiontext · max 30Optional on createUpdatableSearchable
TrueupOffsetCodetext · max 30Optional on createUpdatableSearchable
TrueupOffsetDaysnumberOptional on createUpdatableSearchable
TrueupOverrideFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable

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 2

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 6

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

Actions 2

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