Projects
projects Based on 26C
Create, change and look up Projects, with project classifications, project customers and project opportunities. Actions include add tasks from workplan template.
- Operations
- GET (list)GET (one)POST (create)PATCH (update)1 action
- Record key
ProjectId- Required on create
OwningOrganizationNameProjectName- At a glance
- 149 fields11 finders17 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/projects?fields=AllowCapitalizedInterestFlag,AllowCrossChargeFlag,AssetAllocationMethodCode,AutoAssetCreateFlag,AutoAssetLineAllocateMode&limit=25&onlyData=true
{
"items": [
{
"AllowCapitalizedInterestFlag": false,
"AllowCrossChargeFlag": false,
"AssetAllocationMethodCode": "<string, max 30>",
"AutoAssetCreateFlag": false,
"AutoAssetLineAllocateMode": "ALL_COSTS"
}
],
"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 149
| Attribute | Type | Use |
|---|---|---|
AllowCapitalizedInterestFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
AllowCrossChargeFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
AssetAllocationMethodCode | text · max 30 | Optional on createUpdatableSearchable |
AutoAssetCreateFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
AutoAssetLineAllocateMode | text · max 30 · default ALL_COSTS | Optional on createUpdatableSearchable |
BillingFlag | yes/no · max 1 | Read-onlySearchable |
BurdenScheduleFixedDate | date | Optional on createUpdatableSearchable |
BurdenScheduleId | number | Optional on createUpdatableSearchable |
BurdenScheduleName | text · max 30 | Optional on createUpdatableSearchable |
BurdeningFlag | yes/no · max 1 | Read-onlySearchable |
BusinessUnitId | number · default -1 | Read-onlySearchable |
BusinessUnitName | text · max 240 | Read-onlySearchable |
CIntRateSchId | number | Optional on createUpdatableSearchable |
CIntRateSchName | text · max 30 | Optional on createUpdatableSearchable |
CIntStopDate | date | Optional on createUpdatableSearchable |
CapitalEventProcessingMethodCode | text · max 30 | Optional on createUpdatableSearchable |
CapitalizableFlag | yes/no · max 1 | Read-onlySearchable |
CreatedBy | text · max 64 | Read-onlySearchable |
CreationDate | date-time | Read-onlySearchable |
CrossChargeLaborFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
CrossChargeNonLaborFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
CurrencyConvDate | date | Optional on createUpdatableSearchable |
CurrencyConvDateTypeCode | text · max 1 | Optional on createUpdatableSearchable |
CurrencyConvRateType | text · max 30 | Optional on createUpdatableSearchable |
EnableBudgetaryControlFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
ExternalProjectId | text · max 240 | Optional on createUpdatableSearchable |
HoursPerDay | number | Optional on createUpdatableSearchable |
IncludeNotesInKPINotificationsFlag | yes/no · max 5 | Optional on createUpdatableSearchable |
IntegrationApplicationCode | text · max 30 | Optional on createUpdatableSearchable |
IntegrationProjectReference | text · max 240 | Optional on createUpdatableSearchable |
KPINotificationEnabledFlag | yes/no · max 5 | Optional on createUpdatableSearchable |
LaborTpFixedDate | date | Optional on createUpdatableSearchable |
LaborTpSchedule | text · max 50 | Optional on createUpdatableSearchable |
LaborTpScheduleId | number | Optional on createUpdatableSearchable |
LastUpdateDate | date-time | Read-onlySearchable |
LastUpdatedBy | text · max 64 | Read-onlySearchable |
LegalEntityId | number · default -1 | Optional on createSearchable |
LegalEntityName | text · max 240 | Optional on createSearchable |
NlTransferPriceFixedDate | date | Optional on createUpdatableSearchable |
NlTransferPriceSchedule | text · max 50 | Optional on createUpdatableSearchable |
NlTransferPriceScheduleId | number | Optional on createUpdatableSearchable |
NumberAttr01 | number | Optional on createUpdatableSearchable |
NumberAttr02 | number | Optional on createUpdatableSearchable |
NumberAttr03 | number | Optional on createUpdatableSearchable |
NumberAttr04 | number | Optional on createUpdatableSearchable |
NumberAttr05 | number | Optional on createUpdatableSearchable |
NumberAttr06 | number | Optional on createUpdatableSearchable |
NumberAttr07 | number | Optional on createUpdatableSearchable |
NumberAttr08 | number | Optional on createUpdatableSearchable |
NumberAttr09 | number | Optional on createUpdatableSearchable |
NumberAttr10 | number | Optional on createUpdatableSearchable |
OwningOrganizationId | number · default -1 | Optional on createUpdatableSearchable |
OwningOrganizationName | text · max 240 | Required on createUpdatableSearchable |
PlanningProjectFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
ProjectCalendarId | number | Optional on createUpdatableSearchable |
ProjectCalendarName | text · max 240 | Optional on createUpdatableSearchable |
ProjectCode01 | number | Optional on createUpdatableSearchable |
ProjectCode02 | number | Optional on createUpdatableSearchable |
ProjectCode03 | number | Optional on createUpdatableSearchable |
ProjectCode04 | number | Optional on createUpdatableSearchable |
ProjectCode05 | number | Optional on createUpdatableSearchable |
ProjectCode06 | number | Optional on createUpdatableSearchable |
ProjectCode07 | number | Optional on createUpdatableSearchable |
ProjectCode08 | number | Optional on createUpdatableSearchable |
ProjectCode09 | number | Optional on createUpdatableSearchable |
ProjectCode10 | number | Optional on createUpdatableSearchable |
ProjectCode11 | number | Optional on createUpdatableSearchable |
ProjectCode12 | number | Optional on createUpdatableSearchable |
ProjectCode13 | number | Optional on createUpdatableSearchable |
ProjectCode14 | number | Optional on createUpdatableSearchable |
ProjectCode15 | number | Optional on createUpdatableSearchable |
ProjectCode16 | number | Optional on createUpdatableSearchable |
ProjectCode17 | number | Optional on createUpdatableSearchable |
ProjectCode18 | number | Optional on createUpdatableSearchable |
ProjectCode19 | number | Optional on createUpdatableSearchable |
ProjectCode20 | number | Optional on createUpdatableSearchable |
ProjectCode21 | number | Optional on createUpdatableSearchable |
ProjectCode22 | number | Optional on createUpdatableSearchable |
ProjectCode23 | number | Optional on createUpdatableSearchable |
ProjectCode24 | number | Optional on createUpdatableSearchable |
ProjectCode25 | number | Optional on createUpdatableSearchable |
ProjectCode26 | number | Optional on createUpdatableSearchable |
ProjectCode27 | number | Optional on createUpdatableSearchable |
ProjectCode28 | number | Optional on createUpdatableSearchable |
ProjectCode29 | number | Optional on createUpdatableSearchable |
ProjectCode30 | number | Optional on createUpdatableSearchable |
ProjectCode31 | number | Optional on createUpdatableSearchable |
ProjectCode32 | number | Optional on createUpdatableSearchable |
ProjectCode33 | number | Optional on createUpdatableSearchable |
ProjectCode34 | number | Optional on createUpdatableSearchable |
ProjectCode35 | number | Optional on createUpdatableSearchable |
ProjectCode36 | number | Optional on createUpdatableSearchable |
ProjectCode37 | number | Optional on createUpdatableSearchable |
ProjectCode38 | number | Optional on createUpdatableSearchable |
ProjectCode39 | number | Optional on createUpdatableSearchable |
ProjectCode40 | number | Optional on createUpdatableSearchable |
ProjectCurrencyCode | text · max 15 | Optional on createUpdatableSearchable |
ProjectDescription | text · max 2000 | Optional on createUpdatableSearchable |
ProjectEndDate | date | Optional on createUpdatableSearchable |
ProjectId | number | Optional on createSearchable |
ProjectLedgerCurrencyCode | text · max 15 | Read-onlySearchable |
ProjectManagerEmail | text | Optional on createUpdatableSearchable |
ProjectManagerName | text | Read-onlySearchable |
ProjectManagerResourceId | number | Read-onlySearchable |
ProjectName | text · max 240 | Required on createUpdatableSearchable |
ProjectNumber | text · max 25 | Optional on createUpdatableSearchable |
ProjectPlanViewAccessCode | text · max 30 · default ORA_PJT_PRJ_PLAN_VIEW_TEAM | Optional on createUpdatableSearchable |
ProjectPriorityCode | text · max 30 | Optional on createUpdatableSearchable |
ProjectStartDate | date | Optional on createUpdatableSearchable |
ProjectStatus | text · max 80 | Optional on createUpdatableSearchable |
ProjectStatusChangeComment | text · max 4000 | Optional on createUpdatableSearchable |
ProjectStatusCode | text · max 30 | Optional on createUpdatableSearchable |
ProjectTypeId | number · default -1 | Read-onlySearchable |
ProjectTypeName | text · max 240 | Read-onlySearchable |
ProjectUnitId | number · default -1 | Read-onlySearchable |
ProjectUnitName | text · max 240 | Read-onlySearchable |
ScheduleTypeCode | text · max 30 | Optional on createUpdatableSearchable |
ServiceType | text · max 80 | Optional on createUpdatableSearchable |
ServiceTypeCode | text · max 30 | Optional on createUpdatableSearchable |
SourceApplicationCode | text · max 30 · default ORA_PROJECT_SERVICE | Optional on createUpdatableSearchable |
SourceProjectReference | text · max 25 | Optional on createUpdatableSearchable |
SourceTemplateId | number | Optional on createSearchable |
SourceTemplateName | text · max 255 | Optional on createSearchable |
SponsoredFlag | yes/no · max 1 | Read-onlySearchable |
TextAttr01 | text · max 200 | Optional on createUpdatableSearchable |
TextAttr02 | text · max 200 | Optional on createUpdatableSearchable |
TextAttr03 | text · max 200 | Optional on createUpdatableSearchable |
TextAttr04 | text · max 200 | Optional on createUpdatableSearchable |
TextAttr05 | text · max 200 | Optional on createUpdatableSearchable |
TextAttr06 | text · max 200 | Optional on createUpdatableSearchable |
TextAttr07 | text · max 200 | Optional on createUpdatableSearchable |
TextAttr08 | text · max 200 | Optional on createUpdatableSearchable |
TextAttr09 | text · max 200 | Optional on createUpdatableSearchable |
TextAttr10 | text · max 200 | Optional on createUpdatableSearchable |
TextAttr11 | text · max 200 | Optional on createUpdatableSearchable |
TextAttr12 | text · max 200 | Optional on createUpdatableSearchable |
TextAttr13 | text · max 200 | Optional on createUpdatableSearchable |
TextAttr14 | text · max 200 | Optional on createUpdatableSearchable |
TextAttr15 | text · max 200 | Optional on createUpdatableSearchable |
TextAttr16 | text · max 200 | Optional on createUpdatableSearchable |
TextAttr17 | text · max 200 | Optional on createUpdatableSearchable |
TextAttr18 | text · max 200 | Optional on createUpdatableSearchable |
TextAttr19 | text · max 200 | Optional on createUpdatableSearchable |
TextAttr20 | text · max 200 | Optional on createUpdatableSearchable |
TransactionControlFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
WorkType | text · max 240 | Optional on createUpdatableSearchable |
WorkTypeId | number | Optional on createUpdatableSearchable |
WorkplanTemplateId | number | Optional on create |
WorkplanTemplateName | text | Optional on create |
Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.
Finders 11
Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.
findByOrg·OwningOrganizationNamefindByPartyName·PartyNamefindByProjectId·ProjectIdfindByProjectName·ProjectNamefindByProjectRoleAndProjectTeamMember·ActiveDatePersonNameProjectRolefindByProjectStatus·ProjectStatusfindByProjectTeamMember·ActiveDatePersonNamefindBySourceApplication·SourceApplicationCodeSourceProjectReferencefindChargeableProjectsByPersonIdAndDateRange·FinishDatePersonIdSearchAttributeStartDatefindChargeableProjectsByTeamMemberAndDateRange·FinishDatePersonIdStartDatefindProjectsByClassCategory·ClassCategory
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 17
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/projects/{ProjectId}/child/<name>. Add them to a GET with expand.
AttachmentsGET · POST · PATCH · DELETE Project Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameProjectClassificationsGET · POST · PATCH · DELETE Project Classifications · 6 fieldsClassCategoryClassCategoryIdClassCodeClassCodeIdCodePercentageProjectClassificationIdProjectCustomersGET · POST · DELETE Project Customers · 5 fieldsPartyIdPartyNamePartyNumberProjectIdProjectPartyIdCustomerTeamMembersGET · POST · PATCH · DELETE Customer Team Members · 11 fieldsEndDatePersonPersonIdPrimaryEmailPrimaryJobTitlePrimaryPhoneProjectPartyIdProjectRoleProjectRoleIdRegistryIdStartDateProjectDFFGET · POST · PATCH Project Descriptive Flexfields · 3 fieldsProjectId__FLEX_Context__FLEX_Context_DisplayValueProjectOpportunitiesGET · POST · PATCH Project Opportunities · 13 fieldsOpportunityAltNumberOpportunityAmountOpportunityCurrencyCodeOpportunityCustomerIdOpportunityCustomerNameOpportunityCustomerNumberOpportunityDescriptionOpportunityIdOpportunityNameOpportunityNumberOpportunityStatusOpportunityWinConfPercentProjectIdProjectStatusHistoryGET Project Status History · 16 fieldsCreatedByCreationDateLastUpdateDateLastUpdatedByNewStatusNewStatusClassificationNewStatusClassificationCodeNewStatusCodeObjectIdOldStatusOldStatusClassificationOldStatusClassificationCodeOldStatusCodeStatusChangeCommentsStatusHistoryIdStatusObjectProjectTeamMembersGET · POST · PATCH · DELETE Project Team Members · 18 fields · 1 findersAssignmentTypeAssignmentTypeCodeBillablePercentBillablePercentReasonBillablePercentReasonCodeFinishDatePersonEmailPersonIdPersonNameProjectIdProjectRoleResourceAllocationPercentageResourceAssignmentEffortInHoursResourcePlanningBillRateResourcePlanningCostRateStartDateTeamMemberIdTrackTimeFlagProjectTransactionControlsGET · POST · PATCH · DELETE Project Transaction Controls · 27 fields · 1 findersBillableBillableHintCapitalizableCapitalizableHintChargeableChargeableHintEmailAddressEndDateActiveExpenditureCategoryIdExpenditureCategoryNameExpenditureTypeIdExpenditureTypeNameJobJobIdNonLaborResourceIdNonLaborResourceNameOrganizationOrganizationIdPersonIdPersonNamePersonNumberPersonTypePersonTypeHintProjectIdRuleNumberStartDateActiveTransactionControlIdProviderBusinessUnitsGET · POST · DELETE Provider Business Units · 6 fields · 1 findersBusinessUnitIdBusinessUnitNameCreatedByCreationDateLastUpdatedByLastUpdatedDateTaskDependenciesGET · POST · PATCH · DELETE Task Dependencies · 12 fieldsDependencyIdDependencyTypeExternalPredecessorTaskIdExternalTaskIdLagPredecessorTaskIdPredecessorTaskNamePredecessorTaskNumberProjectIdTaskIdTaskNameTaskNumberTasksGET · POST · PATCH · DELETE Tasks · 134 fields · 2 findersActualQuantityAllowCrossChargeTransactionsFlagBaselineAllocationBaselineDurationBaselineFinishDateBaselineQuantityBaselineStartDateBillableFlagBurdenScheduleCapitalizableFlagChargeableFlagConstraintDateConstraintTypeCriticalFlagCrossChargeLaborFlagCrossChargeNonLaborFlagCurrentFinishDateCurrentQuantityCurrentStartDateElementTypeExecutionDisplaySequenceExternalParentTaskIdExternalTaskIdLowestLevelTaskManualScheduleMilestoneFlagParentTaskIdProgressStatusCodeReceiveIntercompanyAndInterprojectInvoicesFlagRemainingQuantityRequirementCodeRequirementNameServiceTypeServiceTypeCodeSourceApplicationSourceReferenceSprintTaskActualFinishDateTaskActualStartDateTaskCode01IdTaskCode02IdTaskCode03IdTaskCode04IdTaskCode05IdTaskCode06IdTaskCode07IdTaskCode08IdTaskCode09IdTaskCode10IdTaskCode11IdTaskCode12IdTaskCode13IdTaskCode14IdTaskCode15IdTaskCode16IdTaskCode17IdTaskCode18IdTaskCode19IdTaskCode20IdTaskCode21IdTaskCode22IdTaskCode23IdTaskCode24IdTaskCode25IdTaskCode26IdTaskCode27IdTaskCode28IdTaskCode29IdTaskCode30IdTaskCode31IdTaskCode32IdTaskCode33IdTaskCode34IdTaskCode35IdTaskCode36IdTaskCode37IdTaskCode38IdTaskCode39IdTaskCode40IdTaskDescriptionTaskDurationTaskFinishDateTaskIdTaskLevelTaskManagerEmailTaskManagerNameTaskManagerPersonIdTaskNameTaskNumberTaskNumberAttr01TaskNumberAttr02TaskNumberAttr03TaskNumberAttr04TaskNumberAttr05TaskNumberAttr06TaskNumberAttr07TaskNumberAttr08TaskNumberAttr09TaskNumberAttr10TaskOrganizationIdTaskOrganizationNameTaskPercentCompleteTaskPhysicalPercentCompleteTaskPriorityTaskQuantityTaskResourceAllocationPercentTaskSequenceTaskStartDateTaskTextAttr01TaskTextAttr02TaskTextAttr03TaskTextAttr04TaskTextAttr05TaskTextAttr06TaskTextAttr07TaskTextAttr08TaskTextAttr09TaskTextAttr10TaskTextAttr11TaskTextAttr12TaskTextAttr13TaskTextAttr14TaskTextAttr15TaskTextAttr16TaskTextAttr17TaskTextAttr18TaskTextAttr19TaskTextAttr20TopTaskIdTransactionCompletionDateTransactionControlFlagTransactionStartDateWorkTypeWorkTypeIdExpenseResourceAssignmentsGET · POST · PATCH · DELETE Expense Resource Assignments · 7 fieldsExpenseResourceActualAmountExpenseResourceAssignmentIdExpenseResourceIdExpenseResourceNameExpenseResourcePlannedAmountExpenseResourceRemainingAmountProjElementIdLaborResourceAssignmentsGET · POST · PATCH · DELETE Labor Resource Assignments · 10 fieldsLaborBilledAmountLaborCostAmountLaborPrimaryResourceLaborResourceAssignmentIdLaborResourceEmailLaborResourceIdLaborResourceNameProjElementIdProjectResourceAssignIdResourceAllocationPercentTaskAttachmentsGET · POST · PATCH · DELETE Attachments · 32 fields · 1 findersAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameTaskTransactionControlsGET · POST · PATCH · DELETE Task Transaction Controls · 28 fields · 1 findersBillableBillableHintCapitalizableCapitalizableHintChargeableChargeableHintEmailAddressEndDateActiveExpenditureCategoryIdExpenditureCategoryNameExpenditureTypeIdExpenditureTypeNameJobJobIdNonLaborResourceIdNonLaborResourceNameOrganizationOrganizationIdPersonIdPersonNamePersonNumberPersonTypePersonTypeHintProjectIdRuleNumberStartDateActiveTaskIdTransactionControlIdTasksDFFGET · POST · PATCH Tasks Descriptive Flexfields · 5 fieldsElementTypeObjectTypeProjElementId__FLEX_Context__FLEX_Context_DisplayValue
Actions 1
POST …/{ProjectId}/action/addTasksFromWorkplanTemplate·taskNumberPrefixreferenceTaskNumberworkplanTemplateNameisPeerreferenceTaskIdworkplanTemplateId
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/projectsand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
findByOrgfor the agent's main search: its variables become clean tool parameters. - 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:AllowCapitalizedInterestFlag, notallowcapitalizedinterestflag. - 17 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.