Oracle Fusion FSCM endpoint reference

Fed Treasury Account Symbols REST API

Get all treasury account symbols

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

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

Supported operations

DELETE /fedTreasuryAccountSymbols/{id}
GET /fedTreasuryAccountSymbols
GET /fedTreasuryAccountSymbols/{id}
PATCH /fedTreasuryAccountSymbols/{id}
POST /fedTreasuryAccountSymbols

Queryable q fields (28)

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

Example q request

GET /fscmRestApi/resources/11.13.18.05/fedTreasuryAccountSymbols?q=AgencyIdentifier='<value>'&onlyData=true&limit=25
Field Type Operators
AgencyIdentifier string = !=
AgencyType string = !=
AllocationTransferAgency string = !=
AllowPriorYearAccounting string = !=
AuthorityDuration string = !=
AvailabilityType string = !=
BeginYearOfAvailability string = !=
CancellationDate string = !=
CopyTAS string = !=
CreatedBy string = !=
CreationDate string = !=
EndDate string = !=
EndingPeriodOfAvailability string = !=
ExpirationDate string = !=
FedAccountSymbolId integer = !=
FederalAccountSymbol string = !=
FinancingAccount string = !=
FundType string = !=
LastUpdateDate string = !=
LastUpdateLogin string = !=
LastUpdatedBy string = !=
MainAccountCode string = !=
ReportingType string = !=
StartDate string = !=
SubAccountCode string = !=
SubLevelPrefixCode string = !=
TreasuryAccountSymbol string = !=
TreasuryAccountSymbolId integer = !=

Child resources (2)

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

fedTASBusinessEventTypeCodesfedTreasuryAccountSymbolDFF

Response fields (30)

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

AgencyIdentifierAgencyTypeAllocationTransferAgencyAllowPriorYearAccountingAuthorityDurationAvailabilityTypeBeginYearOfAvailabilityCancellationDateCopyTASCreatedByCreationDateEndDateEndingPeriodOfAvailabilityExpirationDateFedAccountSymbolIdFederalAccountSymbolFinancingAccountFundTypeLastUpdateDateLastUpdateLoginLastUpdatedByMainAccountCodeReportingTypeStartDateSubAccountCodeSubLevelPrefixCodeTreasuryAccountSymbolTreasuryAccountSymbolIdfedTASBusinessEventTypeCodesfedTreasuryAccountSymbolDFF

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