Oracle Fusion FSCM endpoint reference

Invoices REST API

Get all invoices

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

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

Supported operations

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

Finders (1)

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

Finder Bind variables
PrimaryKey —

Example finder request

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

Queryable q fields (88)

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

Example q request

GET /fscmRestApi/resources/11.13.18.05/invoices?q=AccountCodingStatus='<value>'&onlyData=true&limit=25
Field Type Operators
AccountCodingStatus string = !=
AccountingDate string = !=
AccountingStatus string = !=
AmountPaid number = !=
ApplyAfterDate string = !=
ApprovalStatus string = !=
BankAccount string = !=
BankChargeBearer string = !=
BaseAmount number = !=
BudgetDate string = !=
BusinessUnit string = !=
CanceledBy string = !=
CanceledDate string = !=
CanceledFlag boolean = !=
ControlAmount number = !=
ConversionDate string = !=
ConversionRate number = !=
ConversionRateType string = !=
CreatedBy string = !=
CreationDate string = !=
DeliveryChannel string = !=
DeliveryChannelCode string = !=
Description string = !=
DocumentCategory string = !=
DocumentFiscalClassificationCodePath string = !=
DocumentSequence integer = !=
ExternalBankAccountId integer = !=
FirstPartyTaxRegistrationId integer = !=
FirstPartyTaxRegistrationNumber string = !=
FundsStatus string = !=
GoodsReceivedDate string = !=
ImageDocumentNumber string = !=
InvoiceAmount number = !=
InvoiceCurrency string = !=
InvoiceDate string = !=
InvoiceGroup string = !=
InvoiceId integer = !=
InvoiceNumber string = !=
InvoiceReceivedDate string = !=
InvoiceSource string = !=
InvoiceSourceCode string = !=
InvoiceType string = !=
LastUpdateDate string = !=
LastUpdateLogin string = !=
LastUpdatedBy string = !=
LegalEntity string = !=
LiabilityDistribution string = !=
PaidStatus string = !=
Party string = !=
PartySite string = !=
PayAloneFlag boolean = !=
PayGroup string = !=
PaymentCurrency string = !=
PaymentMethod string = !=
PaymentMethodCode string = !=
PaymentReason string = !=
PaymentReasonCode string = !=
PaymentReasonComments string = !=
PaymentTerms string = !=
ProductTable string = !=
PurchaseOrderNumber string = !=
ReferenceKeyFive string = !=
ReferenceKeyFour string = !=
ReferenceKeyOne string = !=
ReferenceKeyThree string = !=
ReferenceKeyTwo string = !=
RemittanceMessageOne string = !=
RemittanceMessageThree string = !=
RemittanceMessageTwo string = !=
Requester string = !=
RequesterId integer = !=
RoutingAttribute1 string = !=
RoutingAttribute2 string = !=
RoutingAttribute3 string = !=
RoutingAttribute4 string = !=
RoutingAttribute5 string = !=
SettlementPriority string = !=
Supplier string = !=
SupplierIBAN string = !=
SupplierNumber string = !=
SupplierSite string = !=
SupplierTaxRegistrationNumber string = !=
TaxationCountry string = !=
TermsDate string = !=
UniqueRemittanceIdentifier string = !=
UniqueRemittanceIdentifierCheckDigit string = !=
ValidationStatus string = !=
VoucherNumber string = !=

Child resources (7)

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

appliedPrepaymentsattachmentsavailablePrepaymentsinvoiceDffinvoiceGdfinvoiceInstallmentsinvoiceLines

Response fields (97)

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

AccountCodingStatusAccountingDateAccountingStatusAmountPaidApplyAfterDateApprovalStatusBankAccountBankChargeBearerBaseAmountBudgetDateBusinessUnitCanceledByCanceledDateCanceledFlagControlAmountConversionDateConversionRateConversionRateTypeCreatedByCreationDateDeliveryChannelDeliveryChannelCodeDescriptionDocumentCategoryDocumentFiscalClassificationCodePathDocumentSequenceExternalBankAccountIdFirstPartyTaxRegistrationIdFirstPartyTaxRegistrationNumberFundsStatusGoodsReceivedDateImageDocumentNumberInvoiceAmountInvoiceCurrencyInvoiceDateInvoiceGroupInvoiceIdInvoiceNumberInvoiceReceivedDateInvoiceSourceInvoiceSourceCodeInvoiceTypeLastUpdateDateLastUpdateLoginLastUpdatedByLegalEntityLegalEntityIdentifierLiabilityDistributionPaidStatusPartyPartySitePayAloneFlagPayGroupPaymentCurrencyPaymentMethodPaymentMethodCodePaymentReasonPaymentReasonCodePaymentReasonCommentsPaymentTermsProcurementBUProductTablePurchaseOrderNumberReferenceKeyFiveReferenceKeyFourReferenceKeyOneReferenceKeyThreeReferenceKeyTwoRemittanceMessageOneRemittanceMessageThreeRemittanceMessageTwoRequesterRequesterIdRoutingAttribute1RoutingAttribute2RoutingAttribute3RoutingAttribute4RoutingAttribute5SettlementPrioritySupplierSupplierIBANSupplierNumberSupplierSiteSupplierTaxRegistrationNumberTaxationCountryTermsDateUniqueRemittanceIdentifierUniqueRemittanceIdentifierCheckDigitValidationStatusVoucherNumberappliedPrepaymentsattachmentsavailablePrepaymentsinvoiceDffinvoiceGdfinvoiceInstallmentsinvoiceLines

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