Oracle Fusion FSCM endpoint reference

Fed Treasury Confirmation Schedules REST API

Get all federal treasury confirmation schedules

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

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

Supported operations

DELETE /fedTreasuryConfirmationSchedules/{id}
GET /fedTreasuryConfirmationSchedules
GET /fedTreasuryConfirmationSchedules/{id}
PATCH /fedTreasuryConfirmationSchedules/{id}

Queryable q fields (26)

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

Example q request

GET /fscmRestApi/resources/11.13.18.05/fedTreasuryConfirmationSchedules?q=AgencyLocationCode='<value>'&onlyData=true&limit=25
Field Type Operators
AgencyLocationCode string = !=
Amount number = !=
BusinessUnit string = !=
ConfirmationDate string = !=
ControlNumber string = !=
CreatedBy string = !=
CreationDate string = !=
FederalPaymentTypeCode string = !=
FromRange integer = !=
LastUpdateDate string = !=
LastUpdateLogin string = !=
LastUpdatedBy string = !=
NumberOfPayments integer = !=
PaymentDate string = !=
PaymentGroup string = !=
PaymentInstructionId integer = !=
PaymentMethod string = !=
PaymentProcessRequest string = !=
RangeType string = !=
RevisionNumber integer = !=
ScheduleDate string = !=
Status string = !=
ToRange integer = !=
TreasuryAccounted string = !=
TreasuryConfirmationId integer = !=
TreasuryEventId integer = !=

Child resources (1)

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

fedTreasuryCheckRanges

Response fields (27)

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

AgencyLocationCodeAmountBusinessUnitConfirmationDateControlNumberCreatedByCreationDateFederalPaymentTypeCodeFromRangeLastUpdateDateLastUpdateLoginLastUpdatedByNumberOfPaymentsPaymentDatePaymentGroupPaymentInstructionIdPaymentMethodPaymentProcessRequestRangeTypeRevisionNumberScheduleDateStatusToRangeTreasuryAccountedTreasuryConfirmationIdTreasuryEventIdfedTreasuryCheckRanges

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