Oracle Fusion FSCM endpoint reference

Transaction Tax Lines REST API

Get all transaction tax lines

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

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

Supported operations

GET /transactionTaxLines
GET /transactionTaxLines/{id}

Finders (2)

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

Finder Bind variables
PrimaryKey
findByTransactionFinder

Example finder request

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

Queryable q fields (46)

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

Example q request

GET /fscmRestApi/resources/11.13.18.05/transactionTaxLines?q=Cancelled='<value>'&onlyData=true&limit=25
Field Type Operators
ApplicationId integer = !=
Cancelled string = !=
ContentOwnerId integer = !=
EntityCode string = !=
EventClassCode string = !=
ExemptCertificateNumber string = !=
InternalOrganizationId integer = !=
LineAmount number = !=
PlaceOfSupplyTypeCode string = !=
SelfAssessed string = !=
SummaryTaxLineId integer = !=
Tax string = !=
TaxAmount number = !=
TaxAmountIncluded string = !=
TaxDate string = !=
TaxDetermineDate string = !=
TaxId integer = !=
TaxJurisdictionCode string = !=
TaxJurisdictionId integer = !=
TaxJurisdictionName string = !=
TaxLineId integer = !=
TaxLineNumber integer = !=
TaxOnlyLine string = !=
TaxPointBasis string = !=
TaxPointDate string = !=
TaxRate number = !=
TaxRateCode string = !=
TaxRateId integer = !=
TaxRateName string = !=
TaxRateType string = !=
TaxRegimeCode string = !=
TaxRegimeId integer = !=
TaxRegimeName string = !=
TaxStatusCode string = !=
TaxStatusId integer = !=
TaxStatusName string = !=
TaxableAmount number = !=
TrxId integer = !=
TrxLevelType string = !=
TrxLineId integer = !=
TrxLineNumber integer = !=
TrxNumber string = !=
UnroundedTaxAmount number = !=
UnroundedTaxableAmount number = !=
WhtGroupId integer = !=
WhtTaxClassificationCode string = !=

Response fields (46)

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

ApplicationIdCancelledContentOwnerIdEntityCodeEventClassCodeExemptCertificateNumberInternalOrganizationIdLineAmountPlaceOfSupplyTypeCodeSelfAssessedSummaryTaxLineIdTaxTaxAmountTaxAmountIncludedTaxDateTaxDetermineDateTaxIdTaxJurisdictionCodeTaxJurisdictionIdTaxJurisdictionNameTaxLineIdTaxLineNumberTaxOnlyLineTaxPointBasisTaxPointDateTaxRateTaxRateCodeTaxRateIdTaxRateNameTaxRateTypeTaxRegimeCodeTaxRegimeIdTaxRegimeNameTaxStatusCodeTaxStatusIdTaxStatusNameTaxableAmountTrxIdTrxLevelTypeTrxLineIdTrxLineNumberTrxNumberUnroundedTaxAmountUnroundedTaxableAmountWhtGroupIdWhtTaxClassificationCode

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