Oracle Fusion FSCM endpoint reference

Fed SAM Vendor Details REST API

Get all SAM trading partner details

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

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 /fedSAMVendorDetails/{id}
GET /fedSAMVendorDetails
GET /fedSAMVendorDetails/{id}
POST /fedSAMVendorDetails

Queryable q fields (26)

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

Example q request

GET /fscmRestApi/resources/11.13.18.05/fedSAMVendorDetails?q=AccountNumber='<value>'&onlyData=true&limit=25
Field Type Operators
AccountNumber string = !=
AgencyLocationCode string = !=
BusinessTypesInformation string = !=
BusinessUnit string = !=
CageCode string = !=
DebtSubjectToOffset string = !=
DoDAAC string = !=
EFTIndicator string = !=
EntityStructure string = !=
EntityURL string = !=
LegalBusinessName string = !=
Location string = !=
NAICSCodesInformation string = !=
NoPublicDisplay string = !=
PhysAddrCity string = !=
PhysAddrCountryCode string = !=
PhysAddrProvinceOrState string = !=
PscCodesInformation string = !=
PurposeOfRegistration string = !=
SamTradingPartnerId integer = !=
SbaBizTypesInformation string = !=
Status string = !=
SupplierId integer = !=
TaxIdentifierNumber string = !=
TaxpayerName string = !=
UniqueEntityIdentifier string = !=

Child resources (1)

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

fedSAMExceptionMessages

Response fields (115)

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

AccountNumberAccountTypeAccountingStationAchEmailAchFaxAchNonUSPhoneAchUSPhoneActivationDateAgencyBusinessPurposeAgencyLocationCodeApPocCityApPocCountryCodeApPocEmailApPocFaxUSOnlyApPocFirstNameApPocLastNameApPocMiddleInitialApPocNonUSPhoneApPocSTAddr1ApPocSTAddr2ApPocStateOrProvinceApPocTitleApPocUSPhoneApPocUSPhoneExtensionApPocZipCodePlus4ApPocZipOrPostalCodeArPocEmailArPocFaxUSOnlyArPocFirstNameArPocLastNameArPocMiddleInitialArPocNonUSPhoneArPocTitleArPocUSPhoneArPocUSPhoneExtensionAuthorizationDateAverageAnnualRevenueAverageNumberOfEmployeesBusinessTypesInformationBusinessUnitCageCodeCongressionalDistrictCreatedByCreationDateDebtSubjectToOffsetDepartmentCodeDisbursingOfficeSymbolDivisionNameDivisionNumberDoDAACDoingBusinessAsNameEFTIndicatorEFTWaiverEnableImportEntityStructureEntityURLExclusionStatusFinancialInstituteHQParentUEILastUpdateLoginLastUpdatedByLegalBusinessNameLocationLockboxNumberMailAddrCityMailAddrCountryMailAddrLine1MailAddrLine2MailAddrStateOrProvinceMailAddrZipCodePlus4MailAddrZipPostalCodeMarketingPartnerIdentificationNumberMerchantId1MerchantId2NAICSCodesInformationNoPublicDisplayPaidByCreditCardPhysAddrCityPhysAddrCountryCodePhysAddrLine1PhysAddrLine2PhysAddrProvinceOrStatePhysAddrZipCodePlus4PhysAddrZipOrPostalCodePhysicalAddressPrimaryNAICSCodePrimaryNAICSDescriptionProcessStatusPscCodesInformationPurposeOfRegistrationRegistrationExpirationDateRemittanceAddressLine1RemittanceAddressLine2RemittanceCityRemittanceCountryCodeRemittanceNameRemittanceStateOrProvinceRemittanceZipCodePlus4RemittanceZipOrPostalCodeRoutingNumberSAMRecordLastImportedDateSAMRecordLastUpdatedDateSamTradingPartnerIdSbaBizTypesInformationSourceStatusSupplierSupplierIdTaxIdentifierNumberTaxIdentifierTypeTaxpayerNameUltimateParentUEIUniqueEntityIdentifierUniqueEntityIdentifierDUNSfedSAMExceptionMessages

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