Oracle Fusion FSCM endpoint reference

Tax Rates LOV REST API

Get all tax rates

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

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

Supported operations

GET /taxRatesLOV
GET /taxRatesLOV/{id}

Finders (3)

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

Finder Bind variables
KeywordFinder
PrimaryKey
TaxLineCreateFinder

Example finder request

GET /fscmRestApi/resources/11.13.18.05/taxRatesLOV?finder=KeywordFinder

Queryable q fields (15)

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

Example q request

GET /fscmRestApi/resources/11.13.18.05/taxRatesLOV?q=Description='<value>'&onlyData=true&limit=25
Field Type Operators
Description string = !=
EffectiveFrom string = !=
EffectiveTo string = !=
PercentageRate number = !=
QuantityRate integer = !=
RateTypeCode string = !=
RecoveryTypeCode string = !=
Tax string = !=
TaxJurisdictionCode string = !=
TaxJurisdictionName string = !=
TaxRateCode string = !=
TaxRateId integer = !=
TaxRateName string = !=
TaxRegimeCode string = !=
TaxStatusCode string = !=

Response fields (15)

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

DescriptionEffectiveFromEffectiveToPercentageRateQuantityRateRateTypeCodeRecoveryTypeCodeTaxTaxJurisdictionCodeTaxJurisdictionNameTaxRateCodeTaxRateIdTaxRateNameTaxRegimeCodeTaxStatusCode

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