Awards
awards Based on 26C
Create, change and look up Awards, with award budget period, award CFDA and award certification. Actions include update award dates.
- Operations
- GET (list)GET (one)POST (create)PATCH (update)1 action
- Record key
AwardId- Required on create
- none marked
- At a glance
- 114 fields0 finders29 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/awards?fields=AwardId,AwardName,AwardNumber,AwardOwningOrganizationId,AwardOwningOrganizationName&limit=25&onlyData=true
{
"items": [
{
"AwardId": 0,
"AwardName": "<string>",
"AwardNumber": "<string>",
"AwardOwningOrganizationId": 0,
"AwardOwningOrganizationName": "<string, max 240>"
}
],
"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 114
| Attribute | Type | Use |
|---|---|---|
AwardId | number | Optional on createSearchable |
AwardName | text | Optional on createSearchable |
AwardNumber | text | Optional on createSearchable |
AwardOwningOrganizationId | number | Optional on createUpdatableSearchable |
AwardOwningOrganizationName | text · max 240 | Optional on createUpdatableSearchable |
AwardPurpose | text · max 80 | Optional on createUpdatableSearchable |
AwardPurposeCode | text · max 30 | Optional on createUpdatableSearchable |
AwardSource | text · max 20 | Optional on createUpdatableSearchable |
AwardType | text · max 30 | Optional on createUpdatableSearchable |
AwardValidationNeededFlag | yes/no | Optional on createUpdatable |
BillPlanName | text | Optional on createUpdatable |
BillSetNumber | number | Optional on createUpdatable |
BillToAccountId | text | Optional on createUpdatable |
BillToAccountNumber | text · max 80 | Optional on createUpdatable |
BillToContactEmail | text | Optional on createUpdatable |
BillToContactId | text | Optional on createUpdatable |
BillToContactName | text | Optional on createUpdatable |
BillToSite | text | Optional on createUpdatable |
BillToSiteUseId | text | Optional on createUpdatable |
BillingCycle | text | Optional on createUpdatable |
BillingCycleId | number | Optional on createUpdatable |
BurdenScheduleFixedDate | date | Optional on createUpdatableSearchable |
BurdenScheduleId | number | Optional on createUpdatableSearchable |
BurdenScheduleName | text · max 30 | Optional on createUpdatableSearchable |
BusinessUnitId | number | Optional on createSearchable |
BusinessUnitName | text | Optional on createSearchable |
CloseDate | date | Optional on createUpdatableSearchable |
ContractLineName | text | Optional on createUpdatable |
ContractStatus | text | Optional on createUpdatable |
ContractTypeId | number | Optional on create |
ContractTypeName | text | Optional on createSearchable |
CreatedBy | text · max 64 | Read-onlySearchable |
CreatedFrom | text · max 20 | Optional on createUpdatableSearchable |
CreationDate | date-time | Read-onlySearchable |
CurrencyCode | text | Optional on create |
DateChangeRequestId | number | Read-onlySearchable |
DaysToClose | number | Optional on create |
Description | text · max 240 | Optional on createUpdatableSearchable |
DocumentNumber | text | Optional on createUpdatable |
EndDate | date | Optional on create |
EventFormat | text | Optional on createUpdatable |
EventFormatId | number | Optional on createUpdatable |
ExpandedAuthorityFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
FederalInvoiceFormat | text | Optional on createUpdatable |
FederalInvoiceFormatCode | text | Optional on createUpdatable |
FlowThroughAmount | number | Optional on createUpdatableSearchable |
FlowThroughFederalFlag | yes/no · max 5 | Optional on createUpdatableSearchable |
FlowThroughFromDate | date | Optional on createUpdatableSearchable |
FlowThroughPrimarySponsorId | number | Optional on createUpdatableSearchable |
FlowThroughPrimarySponsorName | text | Optional on createUpdatableSearchable |
FlowThroughPrimarySponsorNumber | text | Optional on createUpdatableSearchable |
FlowThroughReferenceAwardName | text · max 100 | Optional on createUpdatableSearchable |
FlowThroughToDate | date | Optional on createUpdatableSearchable |
GeneratedInvoiceStatus | text | Optional on createUpdatable |
GeneratedInvoiceStatusCode | text | Optional on createUpdatable |
InstitutionComplianceApprovalDate | date | Optional on createUpdatableSearchable |
InstitutionComplianceFlag | yes/no · max 5 | Optional on createUpdatableSearchable |
InstitutionComplianceReviewCompletedFlag | yes/no · max 5 | Optional on createUpdatableSearchable |
InstitutionId | number | Optional on createUpdatableSearchable |
InstitutionName | text | Optional on createUpdatableSearchable |
IntellectualPropertyDescription | text · max 200 | Optional on createUpdatableSearchable |
IntellectualPropertyReportedFlag | yes/no · max 5 | Optional on createUpdatableSearchable |
InvoiceGrouping | text | Optional on createUpdatable |
InvoiceGroupingCode | text | Optional on createUpdatable |
InvoiceMethod | text | Optional on createUpdatable |
InvoiceMethodId | number | Optional on createUpdatable |
LaborFormat | text | Optional on createUpdatable |
LaborFormatId | number | Optional on createUpdatable |
LastUpdateDate | date-time | Read-onlySearchable |
LastUpdatedBy | text · max 64 | Read-onlySearchable |
LastValidated | date-time | Optional on createUpdatableSearchable |
LegalEntityId | number | Optional on create |
LegalEntityName | text | Optional on createSearchable |
LetterOfCreditFlag | yes/no | Optional on createUpdatable |
NetInvoiceFlag | yes/no | Optional on createUpdatable |
NonLaborFormat | text | Optional on createUpdatable |
NonLaborFormatId | number | Optional on createUpdatable |
PaymentTerms | text | Optional on createUpdatable |
PaymentTermsId | number | Optional on createUpdatable |
PreAwardDate | date | Optional on createUpdatableSearchable |
PreAwardGuaranteedFundingSource | text · max 100 | Optional on createUpdatableSearchable |
PreAwardSpendingAllowedFlag | yes/no · max 5 | Optional on createUpdatableSearchable |
PrepaymentTransactionTypeId | number | Optional on createUpdatable |
PrepaymentTransactionTypeName | text | Optional on createUpdatable |
PreviousAwardAccomplishmentRenewFlag | yes/no · max 5 | Optional on createUpdatableSearchable |
PreviousAwardBUId | number | Optional on createUpdatableSearchable |
PreviousAwardBUName | text | Optional on createUpdatableSearchable |
PreviousAwardId | number | Optional on createUpdatableSearchable |
PreviousAwardInProgressRenewFlag | yes/no · max 5 | Optional on createUpdatableSearchable |
PreviousAwardName | text | Optional on createUpdatableSearchable |
PreviousAwardNumber | text | Optional on createUpdatableSearchable |
PrincipalInvestigatorEmail | text | Optional on createSearchable |
PrincipalInvestigatorId | number | Optional on create |
PrincipalInvestigatorName | text | Optional on createSearchable |
PrincipalInvestigatorNumber | text | Optional on createSearchable |
RevenueMethod | text | Optional on createUpdatable |
RevenueMethodId | number | Optional on createUpdatable |
RevenuePlanName | text | Optional on createUpdatable |
ShipToAccountId | text | Optional on createUpdatable |
ShipToAccountNumber | text · max 80 | Optional on createUpdatable |
ShipToSite | text | Optional on createUpdatable |
ShipToSiteUseId | text | Optional on createUpdatable |
SourceAwardName | text · max 300 | Read-onlySearchable |
SourceTemplateId | number | Optional on createUpdatableSearchable |
SourceTemplateName | text | Optional on createUpdatableSearchable |
SourceTemplateNumber | text | Optional on createUpdatableSearchable |
SponsorAwardNumber | text · max 30 | Optional on createUpdatableSearchable |
SponsorId | number | Optional on createUpdatableSearchable |
SponsorName | text | Optional on createSearchable |
SponsorNumber | text | Optional on createSearchable |
StartDate | date | Optional on create |
TransactionTypeId | text | Optional on createUpdatable |
TransactionTypeName | text | Optional on createUpdatable |
ValidateStatus | text · max 1 · default N | Optional on createUpdatableSearchable |
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 29
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/awards/{AwardId}/child/<name>. Add them to a GET with expand.
AttachmentGET · POST · PATCH · DELETE Award Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameAwardBudgetPeriodGET · POST · PATCH · DELETE Award Budget Periods · 9 fieldsAwardBudgetPeriodIdAwardIdBudgetPeriodCreatedByCreationDateEndDateLastUpdateDateLastUpdatedByStartDateAwardCFDAGET · POST · PATCH · DELETE Award CFDAs · 8 fieldsAwardCFDAIdAwardIdCfdaCreatedByCreationDateLastUpdateDateLastUpdatedByProgramTitleAwardCertificationGET · POST · PATCH · DELETE Award Certifications · 19 fieldsApprovalDateAssuranceNumberAwardCertificationIdAwardIdCertificationDateCertificationIdCertificationNameCertifiedByPersonIdCertifiedByPersonNameCommentsCreatedByCreationDateExemptionNumberExpeditedReviewFlagExpirationDateFullReviewFlagLastUpdateDateLastUpdatedByStatusAwardDepartmentCreditGET · POST · PATCH · DELETE Award Department Credits · 9 fieldsAwardIdAwardOrganizationCreditIdCreatedByCreationDateCreditPercentageLastUpdateDateLastUpdatedByOrganizationIdOrganizationNameAwardErrorGET Award Errors · 10 fieldsAwardErrorIdAwardIdCreatedByCreationDateErrorCodeErrorTypeLastUpdateDateLastUpdatedByMessageTextMessageUserDetailsAwardFundingGET · POST · PATCH · DELETE Award Fundings · 20 fieldsAwardFundingIdAwardFundingSourceIdAwardIdBudgetPeriodBudgetPeriodIdCreatedByCreationDateCurrencyCodeDirectFundingAmountFundingIssueDateFundingIssueDescriptionFundingIssueNumberFundingIssueTypeFundingIssueTypeNameFundingSourceIdFundingSourceNameFundingSourceNumberIndirectFundingAmountLastUpdateDateLastUpdatedByAwardProjectFundingGET · POST · PATCH · DELETE Award Project Fundings · 12 fieldsAwardIdAwardProjectFundingIdAwardProjectLinkIdCreatedByCreationDateCurrencyCodeFundingAmountLastUpdateDateLastUpdatedByProjectIdProjectNameProjectNumberAwardFundingSourceGET · POST · PATCH · DELETE Award Funding Sources · 15 fieldsApprovalDateApprovalPersonIdApprovalPersonNameApprovalPersonNumberAwardFundingSourceSourceIdAwardIdCreatedByCreationDateFundingSourceIdFundingSourceNameFundingSourceNumberLastUpdateDateLastUpdatedByRequiredBySponsorTypeAwardHeaderDFFGET · POST · PATCH Award Descriptive Flexfields · 3 fieldsId__FLEX_Context__FLEX_Context_DisplayValueAwardKeywordGET · POST · PATCH · DELETE Award Keywords · 8 fieldsAwardIdAwardKeywordIdCreatedByCreationDateKeywordIdKeywordNameLastUpdateDateLastUpdatedByAwardPersonnelGET · POST · PATCH · DELETE Award Personnel · 20 fieldsAwardIdAwardPersonnelIdCreatedByCreationDateCreditPercentEmailAddressEndDateInternalFlagJobTitleLastUpdateDateLastUpdatedByOrganizationNamePartyIdPersonIdPersonNamePersonNumberPhoneNumberRoleRoleIdStartDateAwardPersonnelDFFGET · POST · PATCH Award Personnel Descriptive Flexfields · 3 fieldsId__FLEX_Context__FLEX_Context_DisplayValueAwardProjectGET · POST · PATCH · DELETE Award Projects · 15 fieldsAwardIdAwardNameAwardNumberAwardProjectIdBurdenScheduleFixedDateBurdenScheduleIdBurdenScheduleNameCreatedByCreationDateCurrencyCodeLastUpdateDateLastUpdatedByProjectIdProjectNameProjectNumberAwardProjectAttachmentGET · POST · PATCH · DELETE Award Project Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameAwardProjectCertificationGET · POST · PATCH · DELETE Award Project Certifications · 20 fieldsApprovalDateAssuranceNumberAwardIdAwardProjectCertificationIdAwdProjectLnkIdCertificationDateCertificationIdCertificationNameCertificationStatusCertifiedByCertifiedByPersonNameCommentsCreatedByCreationDateExemptionNumberExpeditedReviewFlagExpirationDateFullReviewFlagLastUpdateDateLastUpdatedByAwardProjectDFFGET · POST · PATCH Award Project Descriptive Flexfields · 3 fieldsId__FLEX_Context__FLEX_Context_DisplayValueAwardProjectDepartmentCreditGET · POST · PATCH · DELETE Award Project Organization Credits · 9 fieldsAwardIdAwardOrganizationCreditIdCreatedByCreationDateCreditPercentageLastUpdateDateLastUpdatedByOrganizationIdOrganizationNameAwardProjectFundingSourceGET · POST · PATCH · DELETE Award Project Funding Sources · 12 fieldsAwardFundingSourceIdAwardIdAwardProjectFundingSourceIdCreatedByCreationDateFundingSourceIdFundingSourceNameFundingSourceNumberFundingSourceTypeInternalFundingSourceBurdeningFlagLastUpdateDateLastUpdatedByAwardProjectKeywordGET · POST · PATCH · DELETE Award Project Keywords · 10 fieldsAwardIdAwardProjectKeywordIdAwardProjectLinkIdCreatedByCreationDateDescriptionKeywordIdKeywordNameLastUpdateDateLastUpdatedByAwardProjectOverrideBurdenSchedulesGET · POST · PATCH Award Project Override Burden Schedules · 18 fieldsAwardIdAwardProjectIdBurdenScheduleDescriptionBurdenScheduleIdBurdenScheduleNameCreatedByCreationDateDefaultBurdenStructureNameDefaultOrganizationHierarchyCodeDefaultOrganizationHierarchyNameHierarchyStartOrganizationIdHierarchyStartOrganizationNameHierarchyVersionIdHierarchyVersionNameLastUpdateDateLastUpdatedByOrganizationClassificationCodeOrganizationClassificationNameVersionsGET · POST · PATCH Versions · 21 fieldsBuildStatusBurdenScheduleIdBurdenStructureNameCreatedByCreationDateHierarchyStartOrganizationIdHierarchyStartOrganizationNameHierarchyVersionIdHierarchyVersionNameHoldVersionFromBuildFlagLastActiveBuildDateLastUpdateDateLastUpdatedByOrganizationClassificationCodeOrganizationClassificationNameOrganizationHierarchyCodeOrganizationHierarchyNameVersionEndDateVersionIdVersionNameVersionStartDateMultipliersGET · POST · PATCH Multipliers · 12 fieldsBurdenCostCodeCreatedByCreationDateLastUpdateDateLastUpdatedByMultiplierIdMultiplierNumberOrganizationClassificationCodeOrganizationClassificationNameOrganizationIdOrganizationNameVersionIdAwardProjectPersonnelGET · POST · PATCH · DELETE Award Project Personnel · 21 fieldsAwardIdAwardProjectPersonnelIdAwdProjectLnkIdCreatedByCreationDateCreditPercentageEmailAddressEndDateInternalFlagJobTitleLastUpdateDateLastUpdatedByOrganizationNamePartyIdPersonIdPersonNamePersonNumberPhoneNumberRoleIdRoleNameStartDateAwardProjectPersonnelDFFGET · POST · PATCH Award Project Personnel Descriptive Flexfields · 3 fieldsId__FLEX_Context__FLEX_Context_DisplayValueAwardProjectReferenceGET · POST · PATCH · DELETE Award Project Reference Types · 11 fieldsAwardIdAwardProjectReferenceIdCreatedByCreationDateDescriptionLastUpdateDateLastUpdatedByReferenceCommentReferenceIdReferenceTypeNameReferenceValueAwardProjectTaskBurdenScheduleGET · POST · PATCH · DELETE Award Project Task Burden Schedules · 13 fieldsAwardIdAwardProjectScheduleIdBurdenScheduleFixedDateBurdenScheduleIdBurdenScheduleNameCreatedByCreationDateLastUpdateDateLastUpdatedByProjectIdTaskIdTaskNameTaskNumberAwardReferenceGET · POST · PATCH · DELETE Award References · 11 fieldsAwardIdAwardReferenceIdCreatedByCreationDateDescriptionLastUpdateDateLastUpdatedByReferenceCommentReferenceIdReferenceTypeNameReferenceValueAwardTermsGET · POST · PATCH · DELETE Award Terms · 13 fieldsAwardIdAwardTermsIdCreatedByCreationDateDescriptionLastUpdateDateLastUpdatedByTermsCategoryIdTermsCategoryNameTermsIdTermsNameTermsOperatorTermsValue
Actions 1
POST …/action/updateAwardDates·AwardAttributesBudgetPeriods
Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/awardsand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Narrow with
q=on searchable fields and a smalllimit; for a count usetotalResults=true&limit=1. - Call once and pass the result on to later steps rather than calling the same endpoint again.
- This resource can change data. Put a human approval step before any create, update, delete or action call.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:AwardId, notawardid. - 6 fields are read-only: sending them in POST or PATCH fails or is ignored. The builder leaves them out.
- Send dates as
YYYY-MM-DD; date-time fields take ISO 8601 with a time zone. - A list returns 25 rows unless you set
limit; readhasMoreand moveoffsetto page through. - Text fields have maximum lengths (shown in the field table). Longer values are rejected.