// fusionrest agent · financials

Invoices

invoices Based on 26C

Create, change, delete and look up Invoices, with applied prepayments, available prepayments and invoice installments. Actions include apply prepayments and calculate tax.

The record key invoicesUniqID is a generated hash. Take it from the record's links (rel self) in a GET response; never build it yourself.

Oracle documents an Effective-Of header and an effectiveDate parameter for this resource, used for date-effective reads and changes.

/fscmRestApi/resources/11.13.18.05/invoices
Operations
GET (list)GET (one)POST (create)PATCH (update)DELETE8 actions
Record key
invoicesUniqID
Required on create
AccountingDateBusinessUnitInvoiceAmountInvoiceCurrencyInvoiceDateInvoiceNumberPaymentCurrencyPaymentMethodCodeTermsDate
At a glance
93 fields0 finders16 children
Extra parameters
?effectiveDate=Effective-Of:
I want to…List the latest 25Count recordsGet one recordCreate oneUpdate one

Try it

Response fields ·
Filters (q)

Only attributes Oracle marks as searchable are offered.

Include children (expand)
Paging and options
limit
Endpoint and headers
GET /fscmRestApi/resources/11.13.18.05/invoices?fields=AccountCodingStatus,AccountingDate,AccountingStatus,AmountPaid,ApplyAfterDate&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AccountCodingStatus": "<string, max 80>",
      "AccountingDate": "2026-01-31",
      "AccountingStatus": "<string, max 255>",
      "AmountPaid": 0,
      "ApplyAfterDate": "2026-01-31"
    }
  ],
  "count": 25,
  "hasMore": true,
  "limit": 25,
  "offset": 0
}

Shapes and placeholders, not real data. Replace https://<your-pod> and the login with your own: this site never sees them. Based on Oracle's 26C REST specification.

Fields 93

AttributeTypeUse
AccountCodingStatustext · max 80Read-onlySearchable
AccountingDatedateRequired on createUpdatableSearchable
AccountingStatustext · max 255Read-onlySearchable
AmountPaidnumberRead-onlySearchable
ApplyAfterDatedateOptional on createUpdatableSearchable
ApprovalStatustext · max 80Read-onlySearchable
BankAccounttext · max 255Optional on createSearchable
BankChargeBearertext · max 255Optional on createUpdatableSearchable
BaseAmountnumberRead-onlySearchable
BudgetDatedateOptional on createUpdatableSearchable
BusinessUnittext · max 240Required on createUpdatableSearchable
CanceledBytext · max 64Read-onlySearchable
CanceledDatedateRead-onlySearchable
CanceledFlagyes/no · max 255Read-onlySearchable
ControlAmountnumberOptional on createUpdatableSearchable
ConversionDatedateOptional on createUpdatableSearchable
ConversionRatenumberOptional on createUpdatableSearchable
ConversionRateTypetext · max 30Optional on createUpdatableSearchable
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
DeliveryChanneltext · max 80Optional on createUpdatableSearchable
DeliveryChannelCodetext · max 30Optional on createUpdatableSearchable
Descriptiontext · max 240Optional on createUpdatableSearchable
DigitalPaymentAccounttext · max 150Optional on createSearchable
DocumentCategorytext · max 255Optional on createUpdatableSearchable
DocumentFiscalClassificationCodePathtext · max 240Optional on createUpdatableSearchable
DocumentSequencenumberOptional on createUpdatableSearchable
ExternalBankAccountIdnumberOptional on createSearchable
FirstPartyTaxRegistrationIdnumberOptional on createUpdatableSearchable
FirstPartyTaxRegistrationNumbertext · max 50Optional on createUpdatableSearchable
FundsStatustext · max 80Read-onlySearchable
GoodsReceivedDatedateOptional on createUpdatableSearchable
ImageDocumentNumbertext · max 50Read-onlySearchable
InvoiceAmountnumberRequired on createUpdatableSearchable
InvoiceCurrencytext · max 15Required on createUpdatableSearchable
InvoiceDatedateRequired on createUpdatableSearchable
InvoiceGrouptext · max 255Optional on createUpdatableSearchable
InvoiceIdnumberRead-onlySearchable
InvoiceNumbertext · max 50Required on createUpdatableSearchable
InvoiceReceivedDatedateOptional on createUpdatableSearchable
InvoiceSourcetext · max 255Optional on createSearchable
InvoiceSourceCodetext · max 25Read-onlySearchable
InvoiceTypetext · max 255Optional on createUpdatableSearchable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdateLogintext · max 32Read-onlySearchable
LastUpdatedBytext · max 64Read-onlySearchable
LegalEntitytext · max 240Optional on createUpdatableSearchable
LegalEntityIdentifiertext · max 255Optional on createUpdatable
LiabilityDistributiontextOptional on createSearchable
PaidStatustext · max 80Read-onlySearchable
Partytext · max 360Read-onlySearchable
PartySitetext · max 240Read-onlySearchable
PayAloneFlagyes/no · max 255Optional on createUpdatableSearchable
PayGrouptext · max 255Optional on createUpdatableSearchable
PaymentCurrencytext · max 15Required on createUpdatableSearchable
PaymentMethodtext · max 100Optional on createUpdatableSearchable
PaymentMethodCodetext · max 30Required on createUpdatableSearchable
PaymentReasontext · max 80Optional on createUpdatableSearchable
PaymentReasonCodetext · max 30Optional on createUpdatableSearchable
PaymentReasonCommentstext · max 240Optional on createUpdatableSearchable
PaymentTermstext · max 50Optional on createUpdatableSearchable
ProcurementBUtextOptional on createUpdatable
ProductTabletext · max 30Read-onlySearchable
PurchaseOrderNumbertext · max 30Optional on createUpdatableSearchable
ReferenceKeyFivetext · max 150Read-onlySearchable
ReferenceKeyFourtext · max 150Read-onlySearchable
ReferenceKeyOnetext · max 4000Read-onlySearchable
ReferenceKeyThreetext · max 150Read-onlySearchable
ReferenceKeyTwotext · max 150Read-onlySearchable
RemittanceMessageOnetext · max 150Optional on createUpdatableSearchable
RemittanceMessageThreetext · max 150Optional on createUpdatableSearchable
RemittanceMessageTwotext · max 150Optional on createUpdatableSearchable
Requestertext · max 240Optional on createUpdatableSearchable
RequesterIdnumberOptional on createUpdatableSearchable
RoutingAttribute1text · max 270Read-onlySearchable
RoutingAttribute2text · max 270Optional on createUpdatableSearchable
RoutingAttribute3text · max 270Optional on createUpdatableSearchable
RoutingAttribute4text · max 270Optional on createUpdatableSearchable
RoutingAttribute5text · max 270Read-onlySearchable
SettlementPrioritytext · max 255Optional on createUpdatableSearchable
Streamtext · max 80Read-onlySearchable
StreamDetailIdnumberOptional on createUpdatableSearchable
Suppliertext · max 360Optional on createUpdatableSearchable
SupplierIBANtext · max 255Optional on createSearchable
SupplierNumbertext · max 30Read-onlySearchable
SupplierSitetext · max 240Optional on createUpdatableSearchable
SupplierTaxRegistrationNumbertext · max 50Optional on createUpdatableSearchable
TaxationCountrytext · max 80Optional on createUpdatableSearchable
TermsDatedateRequired on createUpdatableSearchable
UniqueRemittanceIdentifiertext · max 256Optional on createUpdatableSearchable
UniqueRemittanceIdentifierCheckDigittext · max 2Optional on createUpdatableSearchable
ValidationStatustext · max 255Optional on createSearchable
VoucherNumbertext · max 50Optional on createSearchable

Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.

Check a payload

Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.

Children 16

Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/invoices/{invoicesUniqID}/child/<name>. Add them to a GET with expand.

Actions 8

Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.

Use in AI Agent Studio

More in For Builders.

Pitfalls