// fusionrest agent · sales and service (cx)

Subscription Balance Registers

subscriptionBalanceRegisters Based on latest (2026.09)

Create, change, delete and look up Subscription Balance Registers, with subscription balance profile balance codes, subscription balance register grouping rules and profile charges. Actions include activate.

/crmRestApi/resources/11.13.18.05/subscriptionBalanceRegisters
Operations
GET (list)GET (one)POST (create)PATCH (update)DELETE1 action
Record key
BalanceRegisterNumber
Required on create
BalanceRegisterNumber
At a glance
31 fields1 finders26 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/subscriptionBalanceRegisters?fields=ActivateRegisterFlag,AllowanceEffectivityType,AmendNewPartialPeriodOption,AmendTerminatedPartialPeriodOption,BalanceProfileName&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "ActivateRegisterFlag": false,
      "AllowanceEffectivityType": "ORA_OSS_BAL_REGISTER_PERIOD",
      "AmendNewPartialPeriodOption": "<string, max 30>",
      "AmendTerminatedPartialPeriodOption": "<string, max 30>",
      "BalanceProfileName": "<string, max 120>"
    }
  ],
  "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 31

AttributeTypeUse
ActivateRegisterFlagyes/no · max 80 · default falseOptional on createUpdatable
AllowanceEffectivityTypetext · max 30 · default ORA_OSS_BAL_REGISTER_PERIODRead-onlySearchable
AmendNewPartialPeriodOptiontext · max 30Read-onlySearchable
AmendTerminatedPartialPeriodOptiontext · max 30Read-onlySearchable
BalanceProfileNametext · max 120Optional on createSearchable
BalanceProfileNumbertext · max 120Optional on createSearchable
BalanceRegisterIdnumberOptional on createSearchable
BalanceRegisterNumbertext · max 120Required on createSearchable
BalanceRegisterStatustext · max 30Optional on createUpdatableSearchable
BillOnDaynumberRead-onlySearchable
BillPeriodAlignDatedateOptional on createUpdatableSearchable
BillingDateCodetext · max 30Read-onlySearchable
BillingFrequencytext · max 30Read-onlySearchable
BillingOffsetDaysnumberRead-onlySearchable
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
EstimateDateCodetext · max 30Read-onlySearchable
FirstPartialPeriodOptiontext · max 30Read-onlySearchable
InterfaceOffsetDaysnumberRead-onlySearchable
InvoicingRuleIdnumberRead-onlySearchable
LastPartialPeriodOptiontext · max 30Read-onlySearchable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdateLogintext · max 32Read-onlySearchable
LastUpdatedBytext · max 64Read-onlySearchable
ManualTrueupFlagyes/no · max 1 · default falseRead-onlySearchable
ObjectVersionNumbernumberOptional on createUpdatableSearchable
PeriodAlignDateTypetext · max 30 · default ORA_OSS_BAL_REG_AND_BILL_LINESRead-onlySearchable
RegisterUpdateFlagyes/no · max 1Optional on createUpdatableSearchable
TerminatedPartialPeriodOptiontext · max 30Read-onlySearchable
TrueupOffsettext · max 30Read-onlySearchable
TrueupOverrideFlagyes/no · max 1 · default falseRead-onlySearchable

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 26

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

Actions 1

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