Oracle Fusion FSCM endpoint reference

Revenue Contracts REST API

Get all revenue contracts

GET https://your-pod.oraclecloud.com/fscmRestApi/resources/11.13.18.05/revenueContracts

Everything on this page is extracted from Oracle's official OpenAPI specification for Fusion Cloud FSCM: 19 queryable q fields, 3 named finders, and 1 child resource. Unsure how q works? See the Oracle Fusion API guide.

Supported operations

GET /revenueContracts
GET /revenueContracts/{id}

Finders (3)

Finders are named, pre-built queries with bound parameters. They can search values plain q filters cannot reach.

Finder Bind variables
PrimaryKey
RevenueContractFinder
RevenueContractsFinder

Example finder request

GET /fscmRestApi/resources/11.13.18.05/revenueContracts?finder=PrimaryKey

Queryable q fields (19)

Only these fields can appear in a q filter expression on /revenueContracts. Filtering on any other field returns 400 Bad Request.

Example q request

GET /fscmRestApi/resources/11.13.18.05/revenueContracts?q=AllocationPendingReason='<value>'&onlyData=true&limit=25
Field Type Operators
AllocationPendingReason string = !=
AllocationStatus string = !=
BilledAmount number = !=
Classification string = !=
ContractGroupNumber string = !=
Currency string = !=
Date string = !=
EffectivePeriod string = !=
ExcludeFromAutomaticWriteOff string = !=
FreezeDate string = !=
IdentificationRule string = !=
NonexemptTransactionPrice number = !=
Number integer = !=
Reference string = !=
RequestId integer = !=
ResidualBalanceAdjustmentStatus string = !=
RevenueRecognisedAmount number = !=
ReviewStatus string = !=
TransactionPrice number = !=

Child resources (1)

Each child is reachable at /revenueContracts/{id}/child/<name> and most can also be inlined with expand.

performanceObligations

Response fields (25)

Top-level attributes returned for each row. Use fields= to request a subset and shrink the payload.

AllocationPendingReasonAllocationStatusBilledAmountClassificationCommentsContractGroupNumberConversionDateConversionRateTypeCurrencyCustomerContractHeaderIdDateEffectivePeriodExcludeFromAutomaticWriteOffFreezeDateIdentificationRuleLedgerNonexemptTransactionPriceNumberReferenceRequestIdResidualBalanceAdjustmentStatusRevenueRecognisedAmountReviewStatusTransactionPriceperformanceObligations

Build this query visually in OPAL

OPAL bundles this endpoint — and 59,000+ more — fully searchable offline, with a visual Q Builder and Finder Builder that only offer the fields listed above, so your filter can't 400. Download free · see features.

Related reference & reading