// fusionrest agent · financials

Federal Transaction Data

fedIPACTransactionData Based on 26C

Create and look up Federal Transaction Data.

/fscmRestApi/resources/11.13.18.05/fedIPACTransactionData
Operations
GET (list)GET (one)POST (create)
Record key
TransactionDataId
Required on create
none marked
At a glance
89 fields1 finders0 children
I want to…List the latest 25Count recordsGet one recordCreate one

Try it

Response fields ·
Filters (q)

Only attributes Oracle marks as searchable are offered.

Finder
Paging and options
limit
Endpoint and headers
GET /fscmRestApi/resources/11.13.18.05/fedIPACTransactionData?fields=ACRN,ACTTraceNumber,AccomplishedDate,Accounted,AccountingClassificationCode&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "ACRN": "<string, max 30>",
      "ACTTraceNumber": 0,
      "AccomplishedDate": "2026-01-31",
      "Accounted": "<string, max 255>",
      "AccountingClassificationCode": "<string, max 30>"
    }
  ],
  "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 89

AttributeTypeUse
ACRNtext · max 30Optional on createSearchable
ACTTraceNumbernumberOptional on createSearchable
AccomplishedDatedateOptional on createSearchable
Accountedtext · max 255Read-onlySearchable
AccountingClassificationCodetext · max 30Optional on createSearchable
AccountingDatedateOptional on createSearchable
CLINtext · max 30Optional on createSearchable
ContactEmailAddresstext · max 320Optional on createSearchable
ContactNametext · max 360Optional on createSearchable
ContactPhoneNumbertext · max 60Optional on createSearchable
ContractNumbertext · max 30Optional on createSearchable
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
CreditDebitCodetext · max 30Optional on createSearchable
CustomerALCtext · max 30Optional on createSearchable
CustomerIdnumberOptional on createSearchable
CustomerNametext · max 360Optional on createSearchable
CustomerTransactionIdnumberOptional on createSearchable
Descriptiontext · max 500Optional on createSearchable
DetailAmountnumberOptional on createSearchable
DetailLineNumbernumberOptional on createSearchable
DoDAACtext · max 30Optional on createSearchable
DocumentIdnumberOptional on createSearchable
FSNAAAADSNnumberOptional on createSearchable
FYObligationIdnumberOptional on createSearchable
IPACBillingIdnumberOptional on createSearchable
IPACDocumentReferenceNumbernumberOptional on createSearchable
InvoiceAmountnumberOptional on createSearchable
InvoiceNumbertext · max 30Optional on createSearchable
JASNumbertext · max 30Optional on createSearchable
JobProjectNumbertext · max 30Optional on createSearchable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdateLogintext · max 32Read-onlySearchable
LastUpdatedBytext · max 64Read-onlySearchable
LoadDatedateOptional on createSearchable
Messagetext · max 500Optional on createSearchable
MiscellaneousInformationtext · max 500Optional on createSearchable
NumberOfDetailItemsnumberOptional on createSearchable
ObligatingDocumentNumbertext · max 30Optional on createSearchable
OriginalAccomplishedDatedateOptional on createSearchable
OriginalAccountingDatedateOptional on createSearchable
OriginalDoSymbolALCtext · max 25Optional on createSearchable
OriginalDocumentReferenceNumbernumberOptional on createSearchable
OriginalTransactionTypetext · max 30Optional on createSearchable
OriginatorALCtext · max 30Optional on createSearchable
PaymentCodetext · max 1Optional on createSearchable
ProcessDatedateRead-onlySearchable
PurchaseOrderNumbertext · max 30Optional on createSearchable
QuantitynumberOptional on createSearchable
ReceiverBETCtext · max 8Optional on createSearchable
ReceiverDUNSorUEItext · max 12Optional on createSearchable
ReceiverDUNSplus4OrEFTtext · max 4Optional on createSearchable
ReceiverDepartmentCodetext · max 30Optional on createSearchable
ReceiverTreasuryAccountSymboltext · max 35Optional on createSearchable
RecordTypetext · max 255Read-onlySearchable
RequisitionNumbertext · max 30Optional on createSearchable
SenderBETCtext · max 8Optional on createSearchable
SenderDUNSorUEItext · max 12Optional on createSearchable
SenderDUNSplus4OrEFTtext · max 4Optional on createSearchable
SenderDoSymbolALCtext · max 25Optional on createSearchable
SenderTreasuryAccountSymboltext · max 35Optional on createSearchable
Statustext · max 30Optional on createSearchable
SubmitterALCtext · max 30Optional on createSearchable
TaxpayerNumbertext · max 50Optional on createSearchable
TransactionContactEmailAddresstext · max 320Optional on createSearchable
TransactionContactPhonetext · max 60Optional on createSearchable
TransactionDataIdnumberOptional on createSearchable
TransactionIdnumberOptional on createSearchable
TransactionSetIdtext · max 30Optional on createSearchable
TransactionTypetext · max 255Read-onlySearchable
USSGLTransactionCodetext · max 30Optional on createSearchable
UnitOfIssuetext · max 10Optional on createSearchable
UnitPricenumberOptional on createSearchable
UserAttribute1text · max 150Optional on createSearchable
UserAttribute10text · max 150Optional on createSearchable
UserAttribute11text · max 150Optional on createSearchable
UserAttribute12text · max 150Optional on createSearchable
UserAttribute13text · max 150Optional on createSearchable
UserAttribute14text · max 150Optional on createSearchable
UserAttribute15text · max 150Optional on createSearchable
UserAttribute2text · max 150Optional on createSearchable
UserAttribute3text · max 150Optional on createSearchable
UserAttribute4text · max 150Optional on createSearchable
UserAttribute5text · max 150Optional on createSearchable
UserAttribute6text · max 150Optional on createSearchable
UserAttribute7text · max 150Optional on createSearchable
UserAttribute8text · max 150Optional on createSearchable
UserAttribute9text · max 150Optional on createSearchable
VoucherNumbertext · max 30Optional on createSearchable

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

Finders 1

Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.

Check a payload

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

Use in AI Agent Studio

More in For Builders.

Pitfalls