Oracle Fusion FSCM endpoint reference

Netting Agreements REST API

Get all netting agreements

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

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

Supported operations

GET /nettingAgreements
GET /nettingAgreements/{id}
PATCH /nettingAgreements/{id}
POST /nettingAgreements

Queryable q fields (25)

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

Example q request

GET /fscmRestApi/resources/11.13.18.05/nettingAgreements?q=AgreementEndDate='<value>'&onlyData=true&limit=25
Field Type Operators
AgreementEndDate string = !=
AgreementId integer = !=
AgreementName string = !=
AgreementStartDate string = !=
AllowDiscountFlag boolean = !=
BankAccountName string = !=
IncludedPayGroupsCode string = !=
IncludedTrxTypesCode string = !=
Language string = !=
LegalEntityName string = !=
LetterBurstingEnabledFlag boolean = !=
LetterCustomerSiteNumber string = !=
LetterEnabledFlag boolean = !=
LetterFromEmailAddress string = !=
LetterFromName string = !=
LetterReplyToEmailAddress string = !=
LetterSupplierSiteCode string = !=
LetterToEmailAddress string = !=
NetBalanceRule string = !=
NetCurrencyCode string = !=
NetCurrencyRule string = !=
NetOrderRule string = !=
NettingGroup string = !=
PartnerReference string = !=
PaymentCurrencyCode string = !=

Child resources (5)

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

nettingCustomerTradingPartnersnettingPayGroupsnettingPayablesInvoiceTypesnettingReceivablesTransactionTypesnettingSupplierTradingPartners

Response fields (30)

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

AgreementEndDateAgreementIdAgreementNameAgreementStartDateAllowDiscountFlagBankAccountNameIncludedPayGroupsCodeIncludedTrxTypesCodeLanguageLegalEntityNameLetterBurstingEnabledFlagLetterCustomerSiteNumberLetterEnabledFlagLetterFromEmailAddressLetterFromNameLetterReplyToEmailAddressLetterSupplierSiteCodeLetterToEmailAddressNetBalanceRuleNetCurrencyCodeNetCurrencyRuleNetOrderRuleNettingGroupPartnerReferencePaymentCurrencyCodenettingCustomerTradingPartnersnettingPayGroupsnettingPayablesInvoiceTypesnettingReceivablesTransactionTypesnettingSupplierTradingPartners

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