// fusionrest agent · project management

Project Plans

projectPlans Based on 26C

Look up Project Plans, with baselines, project calendars and task deliverables. Read-only.

/fscmRestApi/resources/11.13.18.05/projectPlans
Operations
GET (list)GET (one)
Record key
ProjectId
Required on create
no create on this resource
At a glance
89 fields1 finders15 children
I want to…List the latest 25Count recordsGet one record

Try it

Response fields ·
Filters (q)

Only attributes Oracle marks as searchable are offered.

Finder
Include children (expand)
Paging and options
limit
Endpoint and headers
GET /fscmRestApi/resources/11.13.18.05/projectPlans?fields=CalendarId,CreationDate,CurrencyCode,Description,EndDate&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "CalendarId": 0,
      "CreationDate": "2026-01-31T09:00:00+00:00",
      "CurrencyCode": "USD",
      "Description": "<string, max 2000>",
      "EndDate": "2026-01-31"
    }
  ],
  "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
CalendarIdnumberSearchable
CreationDatedate-timeRead-onlySearchable
CurrencyCodetext · max 15 · default USDSearchable
Descriptiontext · max 2000Searchable
EndDatedateSearchable
FinanciallyEnabledFlagyes/noRead-onlySearchable
Nametext · max 240Searchable
NumberAttr01numberSearchable
NumberAttr02numberSearchable
NumberAttr03numberSearchable
NumberAttr04numberSearchable
NumberAttr05numberSearchable
NumberAttr06numberSearchable
NumberAttr07numberSearchable
NumberAttr08numberSearchable
NumberAttr09numberSearchable
NumberAttr10numberSearchable
OrganizationIdnumber · default -1Searchable
PercentCompletenumber · default 0Read-onlySearchable
PrimaryProjectManagerNametext · max 240Read-onlySearchable
ProjectCode01numberSearchable
ProjectCode02numberSearchable
ProjectCode03numberSearchable
ProjectCode04numberSearchable
ProjectCode05numberSearchable
ProjectCode06numberSearchable
ProjectCode07numberSearchable
ProjectCode08numberSearchable
ProjectCode09numberSearchable
ProjectCode10numberSearchable
ProjectCode11numberSearchable
ProjectCode12numberSearchable
ProjectCode13numberSearchable
ProjectCode14numberSearchable
ProjectCode15numberSearchable
ProjectCode16numberSearchable
ProjectCode17numberSearchable
ProjectCode18numberSearchable
ProjectCode19numberSearchable
ProjectCode20numberSearchable
ProjectCode21numberSearchable
ProjectCode22numberSearchable
ProjectCode23numberSearchable
ProjectCode24numberSearchable
ProjectCode25numberSearchable
ProjectCode26numberSearchable
ProjectCode27numberSearchable
ProjectCode28numberSearchable
ProjectCode29numberSearchable
ProjectCode30numberSearchable
ProjectCode31numberSearchable
ProjectCode32numberSearchable
ProjectCode33numberSearchable
ProjectCode34numberSearchable
ProjectCode35numberSearchable
ProjectCode36numberSearchable
ProjectCode37numberSearchable
ProjectCode38numberSearchable
ProjectCode39numberSearchable
ProjectCode40numberSearchable
ProjectIdnumberSearchable
ProjectLedgerCurrencyCodetext · max 15Read-onlySearchable
ProjectNumbertext · max 25Searchable
ScheduleTypeCodetext · max 30Searchable
StartDatedateSearchable
Statustext · max 80Read-onlySearchable
StatusCodetext · max 30 · default ACTIVESearchable
SystemStatusCodetext · max 30Read-onlySearchable
TextAttr01text · max 200Searchable
TextAttr02text · max 200Searchable
TextAttr03text · max 200Searchable
TextAttr04text · max 200Searchable
TextAttr05text · max 200Searchable
TextAttr06text · max 200Searchable
TextAttr07text · max 200Searchable
TextAttr08text · max 200Searchable
TextAttr09text · max 200Searchable
TextAttr10text · max 200Searchable
TextAttr11text · max 200Searchable
TextAttr12text · max 200Searchable
TextAttr13text · max 200Searchable
TextAttr14text · max 200Searchable
TextAttr15text · max 200Searchable
TextAttr16text · max 200Searchable
TextAttr17text · max 200Searchable
TextAttr18text · max 200Searchable
TextAttr19text · max 200Searchable
TextAttr20text · max 200Searchable
ViewAccessCodetext · max 30 · default ORA_PJT_PRJ_PLAN_VIEW_TEAMSearchable

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.

Children 15

Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/projectPlans/{ProjectId}/child/<name>. Add them to a GET with expand.

Use in AI Agent Studio

More in For Builders.

Pitfalls