Oracle Fusion FSCM endpoint reference

Tax Exemptions REST API

Get all tax exemptions

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

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

Supported operations

GET /taxExemptions
GET /taxExemptions/{id}
PATCH /taxExemptions/{id}
POST /taxExemptions

Finders (2)

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

Finder Bind variables
ManageTaxExemptionsRF
PrimaryKey

Example finder request

GET /fscmRestApi/resources/11.13.18.05/taxExemptions?finder=ManageTaxExemptionsRF

Queryable q fields (54)

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

Example q request

GET /fscmRestApi/resources/11.13.18.05/taxExemptions?q=ClauseReference='<value>'&onlyData=true&limit=25
Field Type Operators
ApplyToLowerLevelsFlag boolean = !=
ClauseReference string = !=
ContentOwner string = !=
ContentOwnerId integer = !=
Country string = !=
CustomChargeFlag boolean = !=
CustomerAccountId integer = !=
DetFactorTemplCode string = !=
EffectiveFrom string = !=
EffectiveTo string = !=
ExemptCertificateNumber string = !=
ExemptReasonCode string = !=
ExemptionStatusCode string = !=
ExemptionTypeCode string = !=
ExemptionUsageCode string = !=
InventoryOrgId integer = !=
IssueDate string = !=
IssueFlag boolean = !=
IssuingTaxAuthority string = !=
IssuingTaxAuthorityId integer = !=
ItemNumber string = !=
LimitAmount number = !=
Organization string = !=
PartyName string = !=
PartyNumber string = !=
PartySiteNumber string = !=
PartyTaxAllowOffsetTaxFlag boolean = !=
PartyTaxClassificationCode string = !=
PartyTaxInclusiveTaxFlag boolean = !=
PartyTaxProcessForApplicabilityFlag boolean = !=
PartyTaxProfileId integer = !=
PartyTaxRoundingLevelCode string = !=
PartyTaxRoundingRuleCode string = !=
PartyType string = !=
PartyTypeCode string = !=
PartyTypeFlag boolean = !=
PartyUsage string = !=
PrintFlag boolean = !=
ProductId integer = !=
RateModifier number = !=
RecordTypeCode string = !=
RecordingDate string = !=
ReportingCodeName string = !=
ReportingTypeName string = !=
SiteUseId integer = !=
SuspendFromDate string = !=
SuspendToDate string = !=
Tax string = !=
TaxExemptionId integer = !=
TaxJurisdictionCode string = !=
TaxJurisdictionId integer = !=
TaxRateCode string = !=
TaxRegimeCode string = !=
TaxStatusCode string = !=

Response fields (57)

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

ApplyToLowerLevelsFlagClauseReferenceContentOwnerContentOwnerIdCountryCustomChargeFlagCustomerAccountIdDetFactorTemplCodeEffectiveFromEffectiveToExemptCertificateNumberExemptReasonCodeExemptionStatusCodeExemptionTypeCodeExemptionUsageCodeInventoryOrgIdIssueDateIssueFlagIssuingTaxAuthorityIssuingTaxAuthorityIdItemNumberLimitAmountOrganizationPartyNamePartyNumberPartySiteNumberPartyTaxAllowOffsetTaxFlagPartyTaxClassificationCodePartyTaxInclusiveTaxFlagPartyTaxProcessForApplicabilityFlagPartyTaxProfileIdPartyTaxRoundingLevelCodePartyTaxRoundingRuleCodePartyTypePartyTypeCodePartyTypeFlagPartyUsagePrintFlagProductIdRateModifierRecordTypeCodeRecordingDateReportingCodeCharReportingCodeIdReportingCodeNameReportingTypeIdReportingTypeNameSiteUseIdSuspendFromDateSuspendToDateTaxTaxExemptionIdTaxJurisdictionCodeTaxJurisdictionIdTaxRateCodeTaxRegimeCodeTaxStatusCode

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