// fusionrest agent · sales and service (cx) · list of values
Subscription Profiles
subscriptionProfiles Based on latest (2026.09)
Look up Subscription Profiles. Read-only.
/crmRestApi/resources/11.13.18.05/subscriptionProfiles
- Operations
- GET (list)GET (one)
- Record key
SubscriptionProfileId- Required on create
- no create on this resource
- At a glance
- 80 fields0 finders0 children
Try it
Response fields ·
Filters (q)
Only attributes Oracle marks as searchable are offered.
Paging and options
limit
GET /crmRestApi/resources/11.13.18.05/subscriptionProfiles?fields=AccountingRuleId,AccountingRuleName,BillFirstPartialPeriodOption,BillFirstPartialPeriodThreshold,BillFirstPartialPeriodThresholdType&limit=25&onlyData=true
Response shape (placeholders)
{
"items": [
{
"AccountingRuleId": 0,
"AccountingRuleName": "<string>",
"BillFirstPartialPeriodOption": "ORA_PRORATE",
"BillFirstPartialPeriodThreshold": 0,
"BillFirstPartialPeriodThresholdType": "<string, max 30>"
}
],
"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 80
| Attribute | Type | Use |
|---|---|---|
AccountingRuleId | number | Searchable |
AccountingRuleName | text | |
BillFirstPartialPeriodOption | text · max 30 · default ORA_PRORATE | Searchable |
BillFirstPartialPeriodThreshold | number | Searchable |
BillFirstPartialPeriodThresholdType | text · max 30 | Searchable |
BillGenerationMethodCode | text · max 30 | Searchable |
BillLastPartialPeriodOption | text · max 30 · default ORA_PRORATE | Searchable |
BillLastPartialPeriodThreshold | number | Searchable |
BillLastPartialPeriodThresholdType | text · max 30 | Searchable |
BillService | text · max 30 | Searchable |
BillingDateCode | text · max 30 | Searchable |
BillingFrequency | text · max 30 | Searchable |
BillingOffsetDays | number | Searchable |
BillingSystem | text · max 30 | Searchable |
CloseCreditMethod | text · max 30 | Searchable |
CoverageInvoiceList | text | Searchable |
CoverageInvoiceText | text · max 4000 · default [$Product Name]: [$Charge Name] [$Bill from Date]-[$Bill to Date] | Searchable |
CreateZeroCreditMemoFlag | yes/no · max 1 | Searchable |
CreatedBy | text · max 64 | Read-onlySearchable |
CreationDate | date-time | Read-onlySearchable |
CreditMemoOption | text · max 30 | Searchable |
CreditType | text · max 30 | Searchable |
CustomerAcceptance | text · max 30 | Searchable |
DefaultRevenueActionAmend | text · max 30 | Searchable |
DefaultRevenueActionRenew | text · max 30 | Searchable |
DynamicSuffixFlag | yes/no · max 1 | Searchable |
EnableAdvBipTemplateFlag | yes/no · max 1 · default false | Searchable |
EnableProrateByDayYn | text · max 1 | Searchable |
HeaderNumberPrefix | text · max 10 | Searchable |
HeaderNumberSuffix | text · max 10 | Searchable |
HeaderNumberingMethod | text · max 30 · default ORA_PUID | Searchable |
InterfaceOffsetDays | number | Searchable |
InternalApproval | text · max 30 | Searchable |
InvoiceAttachmentCategory | text · max 30 | Searchable |
InvoiceAttachmentEntityName | text · max 30 | Searchable |
InvoiceBipReportCode | text · max 30 | Searchable |
InvoicingRuleId | number | Searchable |
LastUpdateDate | date-time | Read-onlySearchable |
LastUpdateLogin | text · max 32 | Read-onlySearchable |
LastUpdatedBy | text · max 64 | Read-onlySearchable |
LayoutTemplate | text · max 200 | Searchable |
LineAutonumberEnabledYn | text · max 1 · default N | Searchable |
NegotiationLanguage | text · max 4 | Searchable |
NumberingDeterminantType | text · max 30 | Searchable |
ObjectVersionNumber | number | Read-onlySearchable |
Offset | number | Searchable |
PartialPeriodStart | text · max 30 | Searchable |
PartialPeriodType | text · max 30 | Searchable |
PaymentTermsId | number | Searchable |
PaymentTermsName | text | Searchable |
PenaltyChargeName | text · max 120 | Searchable |
PreviewBipReportCode | text · max 30 | Searchable |
PriceDuringBillingYn | text · max 1 · default N | Searchable |
PricingApplicationCode | text · max 30 · default NULL | Searchable |
RevenueOptionAmend | text · max 30 | Searchable |
RevenueOptionBillAdjustment | text · max 30 | Searchable |
RevenueOptionChargeAdjustment | text · max 30 | Searchable |
RevenueOptionClose | text · max 30 | Searchable |
RevenueOptionPricingTerm | text · max 30 | Searchable |
RevenueOptionRenew | text · max 30 | Searchable |
RevenuePeriodBillAdjustment | text · max 30 | Searchable |
RevenuePeriodChargeAdjustment | text · max 30 | Searchable |
RevenuePeriodPricingTerm | text · max 30 | Searchable |
SpecificDays | number | Searchable |
SubscriptionInvoiceList | text | Searchable |
SubscriptionInvoiceText | text · max 4000 · default [$Product Name]: [$Charge Name] [$Bill from Date]-[$Bill to Date] | Searchable |
SubscriptionProfileDescription | text · max 2000 | Searchable |
SubscriptionProfileId | number | Read-onlySearchable |
SubscriptionProfileName | text · max 300 | Searchable |
SubscriptionProfilePuid | text · max 120 | Searchable |
SuffixText | text · max 4000 | Searchable |
TransactionTypeName | text · max 80 | Searchable |
TransactionTypeSequenceId | number | Searchable |
UsageCapture | text · max 30 · default ORA_THIRD_PARTY | Searchable |
UsageEventAllowanceInvTemplate | text · max 200 | Searchable |
UsageEventCommitmentInvTemplate | text · max 200 | Searchable |
UsageEventEstimateInvTemplate | text · max 200 | Searchable |
UsageEventRegularInvTemplate | text · max 200 | Searchable |
UsageInvoiceLayoutTemplate | text · max 200 | Searchable |
WithholdProrationUsgYn | text · max 1 | Searchable |
Names, types, labels and flags from Oracle's REST specification (latest (2026.09)). Flexfield and custom attributes vary by pod: check /describe for yours.
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Use in AI Agent Studio
- Point a Business Object or REST tool at
/crmRestApi/resources/11.13.18.05/subscriptionProfilesand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Narrow with
q=on searchable fields and a smalllimit; for a count usetotalResults=true&limit=1. - Call once and pass the result on to later steps rather than calling the same endpoint again.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:AccountingRuleId, notaccountingruleid. - Send dates as
YYYY-MM-DD; date-time fields take ISO 8601 with a time zone. - A list returns 25 rows unless you set
limit; readhasMoreand moveoffsetto page through.