// fusionrest agent · project management

Project Program Insights

projectProgramInsights Based on 26C

Look up Project Program Insights. Read-only.

The record key projectProgramInsightsUniqID is a generated hash. Take it from the record's links (rel self) in a GET response; never build it yourself.

/fscmRestApi/resources/11.13.18.05/projectProgramInsights
Operations
GET (list)GET (one)
Record key
projectProgramInsightsUniqID
Required on create
no create on this resource
At a glance
310 fields5 finders1 children2 file/large text fields
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/projectProgramInsights?fields=ACBudgetLaborCost,ACBudgetMargin,ACCurrentandOriginalBudgetCostVariancePercentage,ACDurationinDays,ACOriginalBudgetCost&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "ACBudgetLaborCost": 0,
      "ACBudgetMargin": 0,
      "ACCurrentandOriginalBudgetCostVariancePercentage": 0,
      "ACDurationinDays": 0,
      "ACOriginalBudgetCost": 0
    }
  ],
  "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 310

AttributeTypeUse
ACBudgetLaborCostnumberRead-onlySearchable
ACBudgetMarginnumberRead-onlySearchable
ACCurrentandOriginalBudgetCostVariancePercentagenumberRead-onlySearchable
ACDurationinDaysnumberRead-onlySearchable
ACOriginalBudgetCostnumberRead-onlySearchable
ACOriginalBudgetLaborEffortinHoursnumberRead-onlySearchable
ACOriginalBudgetandActualCostVariancenumberRead-onlySearchable
ACOriginalBudgetandEACForecastCostVariancenumberRead-onlySearchable
ACOriginalBudgetandEACForecastMarginVariancenumberRead-onlySearchable
ACOriginalBudgetandEACForecastRevenueVariancenumberRead-onlySearchable
ActualWorkPlanEffortinHoursnumberRead-onlySearchable
AmountToBillnumberRead-onlySearchable
AsOfPeriodEndDatedate-timeRead-onlySearchable
AsOfPeriodNametextRead-onlySearchable
AsOfPeriodStartDatedate-timeRead-onlySearchable
AssessmentCodetext · max 30Read-onlySearchable
AssessmentMeaningtext · max 80Read-onlySearchable
AssignmentsEndingSoonnumberRead-onlySearchable
AssignmentsReservednumberRead-onlySearchable
CostPerformanceIndexnumberRead-onlySearchable
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
CurrencyCodetextRead-onlySearchable
Descriptiontext · max 2000Read-onlySearchable
EACBudgetCostnumberRead-onlySearchable
EACBudgetLaborEffortnumberRead-onlySearchable
EACBudgetRevenuenumberRead-onlySearchable
EACCurrentandOriginalBudgetMarginVariancenumberRead-onlySearchable
EACCurrentandOriginalBudgetRevenueVariancenumberRead-onlySearchable
EACCurrentandPreviousForecastCostVariancenumberRead-onlySearchable
EACCurrentandPreviousForecastLaborEffortVariancenumberRead-onlySearchable
EACCurrentandPreviousForecastMarginVariancenumberRead-onlySearchable
EACCurrentandPreviousForecastRevenueVariancenumberRead-onlySearchable
EACForecastLaborCostnumberRead-onlySearchable
EACForecastLaborEffortnumberRead-onlySearchable
EACForecastLaborEffortVariancePercentagenumberRead-onlySearchable
EACForecastMarginnumberRead-onlySearchable
EACForecastRevenuenumberRead-onlySearchable
EarnedValuenumberRead-onlySearchable
EarnedValueCostVariancenumberRead-onlySearchable
EarnedValueScheduleVariancenumberRead-onlySearchable
EstimatetoCompleteCostnumberRead-onlySearchable
EstimatetoCompleteLaborEffortinHoursnumberRead-onlySearchable
FinishDatedateRead-onlySearchable
ITDActualCapitalizableCostnumberRead-onlySearchable
ITDActualCapitalizableCostPercentagenumberRead-onlySearchable
ITDActualCapitalizableCostPercentagePrevValuestext · max 255Read-onlySearchable
ITDActualCapitalizableCostPrevValuestext · max 255Read-onlySearchable
ITDActualCostnumberRead-onlySearchable
ITDActualCostPrevValuestext · max 255Read-onlySearchable
ITDActualInvoiceAmountnumberRead-onlySearchable
ITDActualLaborCostnumberRead-onlySearchable
ITDActualLaborCostPrevValuestext · max 255Read-onlySearchable
ITDActualLaborEffortnumberRead-onlySearchable
ITDActualLaborEffortPrevValuestext · max 255Read-onlySearchable
ITDActualMarginnumberRead-onlySearchable
ITDActualMarginPercentagenumberRead-onlySearchable
ITDActualMarginPercentagePrevValuestext · max 255Read-onlySearchable
ITDActualMarginPrevValuestext · max 255Read-onlySearchable
ITDActualNonbillableCostnumberRead-onlySearchable
ITDActualNonbillableCostPercentagenumberRead-onlySearchable
ITDActualNonbillableCostPercentagePrevValuestext · max 255Read-onlySearchable
ITDActualNonbillableCostPrevValuestext · max 255Read-onlySearchable
ITDActualNonbillableLaborEffortinHoursnumberRead-onlySearchable
ITDActualNonbillableLaborEffortinHoursPrevValuestext · max 255Read-onlySearchable
ITDActualSpentCostPercentagenumberRead-onlySearchable
ITDActualSpentCostPercentagePrevValuestext · max 255Read-onlySearchable
ITDActualSpentLaborEffortPercentagenumberRead-onlySearchable
ITDActualSpentLaborEffortPercentagePrevValuestext · max 255Read-onlySearchable
ITDActualandCommittedCostnumberRead-onlySearchable
ITDActualandCommittedCostPrevValuestext · max 255Read-onlySearchable
ITDBudgetCostnumberRead-onlySearchable
ITDBudgetCostPrevValuestext · max 255Read-onlySearchable
ITDBudgetLaborCostnumberRead-onlySearchable
ITDBudgetLaborCostPrevValuestext · max 255Read-onlySearchable
ITDBudgetLaborEffortnumberRead-onlySearchable
ITDBudgetLaborEffortPrevValuestext · max 255Read-onlySearchable
ITDBudgetMarginnumberRead-onlySearchable
ITDBudgetMarginPercentagenumberRead-onlySearchable
ITDBudgetMarginPercentagePrevValuestext · max 255Read-onlySearchable
ITDBudgetMarginPrevValuestext · max 255Read-onlySearchable
ITDBudgetRevenuenumberRead-onlySearchable
ITDBudgetRevenuePrevValuestext · max 255Read-onlySearchable
ITDCommittedCostnumberRead-onlySearchable
ITDCostVariancenumberRead-onlySearchable
ITDCostVariancePercentagenumberRead-onlySearchable
ITDCostVariancePercentagePrevValuestext · max 255Read-onlySearchable
ITDCostVariancePrevValuestext · max 255Read-onlySearchable
ITDDurationinDaysnumberRead-onlySearchable
ITDForecastCostnumberRead-onlySearchable
ITDForecastCostPrevValuestext · max 255Read-onlySearchable
ITDForecastCostVariancenumberRead-onlySearchable
ITDForecastCostVariancePercentagenumberRead-onlySearchable
ITDForecastCostVariancePercentagePrevValuestext · max 255Read-onlySearchable
ITDForecastCostVariancePrevValuestext · max 255Read-onlySearchable
ITDForecastLaborCostnumberRead-onlySearchable
ITDForecastLaborCostPrevValuestext · max 255Read-onlySearchable
ITDForecastLaborEffortnumberRead-onlySearchable
ITDForecastLaborEffortPrevValuestext · max 255Read-onlySearchable
ITDForecastLaborEffortVariancePercentagenumberRead-onlySearchable
ITDForecastLaborEffortVariancePercentagePrevValuestext · max 255Read-onlySearchable
ITDForecastMarginnumberRead-onlySearchable
ITDForecastMarginPercentageVariancenumberRead-onlySearchable
ITDForecastMarginPercentageVariancePrevValuestext · max 255Read-onlySearchable
ITDForecastMarginPrevValuestext · max 255Read-onlySearchable
ITDForecastMarginVariancenumberRead-onlySearchable
ITDForecastMarginVariancePercentagenumberRead-onlySearchable
ITDForecastMarginVariancePercentagePrevValuestext · max 255Read-onlySearchable
ITDForecastMarginVariancePrevValuestext · max 255Read-onlySearchable
ITDForecastRevenuenumberRead-onlySearchable
ITDForecastRevenuePrevValuestext · max 255Read-onlySearchable
ITDForecastRevenueVariancenumberRead-onlySearchable
ITDForecastRevenueVariancePercentagenumberRead-onlySearchable
ITDForecastRevenueVariancePercentagePrevValuestext · max 255Read-onlySearchable
ITDForecastRevenueVariancePrevValuestext · max 255Read-onlySearchable
ITDLaborEffortVariancePercentagenumberRead-onlySearchable
ITDLaborEffortVariancePercentagePrevValuestext · max 255Read-onlySearchable
ITDMarginPercentageVariancenumberRead-onlySearchable
ITDMarginPercentageVariancePrevValuestext · max 255Read-onlySearchable
ITDMarginVariancenumberRead-onlySearchable
ITDMarginVariancePrevValuestext · max 255Read-onlySearchable
ITDRevenuenumberRead-onlySearchable
ITDRevenuePrevValuestext · max 255Read-onlySearchable
ITDRevenueVariancenumberRead-onlySearchable
ITDRevenueVariancePercentagenumberRead-onlySearchable
ITDRevenueVariancePercentagePrevValuestext · max 255Read-onlySearchable
ITDRevenueVariancePrevValuestext · max 255Read-onlySearchable
ImagetextRead-only
ImageIdnumberRead-onlySearchable
ImageNametext · max 240Read-onlySearchable
IncludePerformanceMeasuresFlagtext · max 1Read-onlySearchable
InvoicesAwaitingApprovalnumberRead-onlySearchable
LastRefreshedDatedate-timeRead-onlySearchable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdatedBytext · max 64Read-onlySearchable
LineOfBusinessCodetext · max 30Read-onlySearchable
LineOfBusinessMeaningtext · max 80Read-onlySearchable
MilestonesAtRisknumberRead-onlySearchable
MilestonesDueSoonnumberRead-onlySearchable
MilestonesPastDuenumberRead-onlySearchable
MissingTimeCardsFiveWeeksOldnumberRead-onlySearchable
MissingTimeCardsFourWeeksOldnumberRead-onlySearchable
MissingTimeCardsOneWeekOldnumberRead-onlySearchable
MissingTimeCardsThreeWeeksOldnumberRead-onlySearchable
MissingTimeCardsTwoWeeksOldnumberRead-onlySearchable
ObjectIdnumberRead-onlySearchable
ObjectNametext · max 240Read-onlySearchable
ObjectNoteExistsFlagtext · max 1Read-onlySearchable
ObjectNumbertext · max 25Read-onlySearchable
ObjectParentIdnumberRead-onlySearchable
ObjectTypetext · max 7Read-onlySearchable
ObjectWatchListIdtext · max 240Read-onlySearchable
Objectivetext · max 400Read-onlySearchable
OwnerIdnumberRead-onlySearchable
OwnerNametext · max 240Read-onlySearchable
OwningOrganizationIdnumberRead-onlySearchable
OwningOrganizationNametext · max 240Read-onlySearchable
PTDActualCapitalizableCostnumberRead-onlySearchable
PTDActualCapitalizableCostPercentagenumberRead-onlySearchable
PTDActualCapitalizableCostPercentagePrevValuestext · max 255Read-onlySearchable
PTDActualCapitalizableCostPrevValuestext · max 255Read-onlySearchable
PTDActualCostnumberRead-onlySearchable
PTDActualCostPrevValuestext · max 255Read-onlySearchable
PTDActualLaborCostnumberRead-onlySearchable
PTDActualLaborCostPrevValuestext · max 255Read-onlySearchable
PTDActualLaborEffortnumberRead-onlySearchable
PTDActualLaborEffortPrevValuestext · max 255Read-onlySearchable
PTDActualMarginnumberRead-onlySearchable
PTDActualMarginPercentagenumberRead-onlySearchable
PTDActualMarginPercentagePrevValuestext · max 255Read-onlySearchable
PTDActualMarginPrevValuestext · max 255Read-onlySearchable
PTDActualNonbillableCostnumberRead-onlySearchable
PTDActualNonbillableCostPercentagenumberRead-onlySearchable
PTDActualNonbillableCostPercentagePrevValuestext · max 255Read-onlySearchable
PTDActualNonbillableCostPrevValuestext · max 255Read-onlySearchable
PTDActualNonbillableLaborEffortinHoursnumberRead-onlySearchable
PTDActualNonbillableLaborEffortinHoursPrevValuestext · max 255Read-onlySearchable
PTDActualandCommittedCostnumberRead-onlySearchable
PTDActualandCommittedCostPrevValuestext · max 255Read-onlySearchable
PTDBudgetCostnumberRead-onlySearchable
PTDBudgetCostPrevValuestext · max 255Read-onlySearchable
PTDBudgetLaborCostnumberRead-onlySearchable
PTDBudgetLaborCostPrevValuestext · max 255Read-onlySearchable
PTDBudgetLaborEffortnumberRead-onlySearchable
PTDBudgetLaborEffortPrevValuestext · max 255Read-onlySearchable
PTDBudgetMarginnumberRead-onlySearchable
PTDBudgetMarginPercentagenumberRead-onlySearchable
PTDBudgetMarginPercentagePrevValuestext · max 255Read-onlySearchable
PTDBudgetMarginPrevValuestext · max 255Read-onlySearchable
PTDBudgetRevenuenumberRead-onlySearchable
PTDBudgetRevenuePrevValuestext · max 255Read-onlySearchable
PTDCommittedCostnumberRead-onlySearchable
PTDCostVariancenumberRead-onlySearchable
PTDCostVariancePercentagenumberRead-onlySearchable
PTDCostVariancePercentagePrevValuestext · max 255Read-onlySearchable
PTDCostVariancePrevValuestext · max 255Read-onlySearchable
PTDForecastCostnumberRead-onlySearchable
PTDForecastCostPrevValuestext · max 255Read-onlySearchable
PTDForecastCostVariancenumberRead-onlySearchable
PTDForecastCostVariancePercentagenumberRead-onlySearchable
PTDForecastCostVariancePercentagePrevValuestext · max 255Read-onlySearchable
PTDForecastCostVariancePrevValuestext · max 255Read-onlySearchable
PTDForecastLaborCostnumberRead-onlySearchable
PTDForecastLaborCostPrevValuestext · max 255Read-onlySearchable
PTDForecastLaborEffortnumberRead-onlySearchable
PTDForecastLaborEffortPrevValuestext · max 255Read-onlySearchable
PTDForecastLaborEffortVariancePercentagenumberRead-onlySearchable
PTDForecastLaborEffortVariancePercentagePrevValuestext · max 255Read-onlySearchable
PTDForecastMarginnumberRead-onlySearchable
PTDForecastMarginPercentageVariancenumberRead-onlySearchable
PTDForecastMarginPercentageVariancePrevValuestext · max 255Read-onlySearchable
PTDForecastMarginPrevValuestext · max 255Read-onlySearchable
PTDForecastMarginVariancenumberRead-onlySearchable
PTDForecastMarginVariancePercentagenumberRead-onlySearchable
PTDForecastMarginVariancePercentagePrevValuestext · max 255Read-onlySearchable
PTDForecastMarginVariancePrevValuestext · max 255Read-onlySearchable
PTDForecastRevenuenumberRead-onlySearchable
PTDForecastRevenuePrevValuestext · max 255Read-onlySearchable
PTDForecastRevenueVariancenumberRead-onlySearchable
PTDForecastRevenueVariancePercentagenumberRead-onlySearchable
PTDForecastRevenueVariancePercentagePrevValuestext · max 255Read-onlySearchable
PTDForecastRevenueVariancePrevValuestext · max 255Read-onlySearchable
PTDLaborEffortVariancePercentagenumberRead-onlySearchable
PTDLaborEffortVariancePercentagePrevValuestext · max 255Read-onlySearchable
PTDMarginPercentageVariancenumberRead-onlySearchable
PTDMarginPercentageVariancePrevValuestext · max 255Read-onlySearchable
PTDMarginVariancenumberRead-onlySearchable
PTDMarginVariancePrevValuestext · max 255Read-onlySearchable
PTDRevenuenumberRead-onlySearchable
PTDRevenuePrevValuestext · max 255Read-onlySearchable
PTDRevenueVariancenumberRead-onlySearchable
PTDRevenueVariancePercentagenumberRead-onlySearchable
PTDRevenueVariancePercentagePrevValuestext · max 255Read-onlySearchable
PTDRevenueVariancePrevValuestext · max 255Read-onlySearchable
ParentProgramNumbertext · max 25Read-onlySearchable
PersonImagetextRead-only
PersonImageIdnumberRead-onlySearchable
PlannedValuenumberRead-onlySearchable
PreviousPeriodNametext · max 15Read-onlySearchable
PreviousPeriodStartDatedate-timeRead-onlySearchable
PriorPeriodNametext · max 15Read-onlySearchable
PriorPeriodStartDatedate-timeRead-onlySearchable
PriorityCodetext · max 30Read-onlySearchable
PriorityMeaningtext · max 80Read-onlySearchable
ProgramBudgetnumberRead-onlySearchable
ProgramBudgetCurrencytext · max 15Read-onlySearchable
ProgramLevelnumberRead-onlySearchable
ProjectCompletePercentagenumberRead-onlySearchable
ProjectRelationshipIdnumberRead-onlySearchable
PublicFlagtext · max 1Read-onlySearchable
RegionCodetext · max 30Read-onlySearchable
RegionMeaningtext · max 80Read-onlySearchable
SchedulePerformanceIndexnumberRead-onlySearchable
StartDatedateRead-onlySearchable
StatusNametext · max 80Read-onlySearchable
StrategyCodetext · max 30Read-onlySearchable
StrategyMeaningtext · max 80Read-onlySearchable
SystemStatusCodetext · max 30Read-onlySearchable
TaskExceptionsCountnumberRead-onlySearchable
TreeStructureIdnumberRead-onlySearchable
UnpaidInvoiceAmountnumberRead-onlySearchable
UserAccesstext · max 30Read-onlySearchable
UserAccessMeaningtext · max 80Read-onlySearchable
WeekFiveToEightOverAllocatednumberRead-onlySearchable
WeekFiveToEightUnderAllocatednumberRead-onlySearchable
WeekNineToTwelveOverAllocatednumberRead-onlySearchable
WeekNineToTwelveUnderAllocatednumberRead-onlySearchable
WeekOneToFourOverAllocatednumberRead-onlySearchable
WeekOneToFourUnderAllocatednumberRead-onlySearchable
WorkPlanCompletePercentagenumberRead-onlySearchable
WorkPlanScheduledEffortinHoursnumberRead-onlySearchable
YTDActualCapitalizableCostnumberRead-onlySearchable
YTDActualCapitalizableCostPercentagenumberRead-onlySearchable
YTDActualCostnumberRead-onlySearchable
YTDActualLaborCostnumberRead-onlySearchable
YTDActualLaborEffortnumberRead-onlySearchable
YTDActualMarginnumberRead-onlySearchable
YTDActualMarginPercentagenumberRead-onlySearchable
YTDActualNonbillableCostnumberRead-onlySearchable
YTDActualNonbillableCostPercentagenumberRead-onlySearchable
YTDActualNonbillableLaborEffortinHoursnumberRead-onlySearchable
YTDActualandCommittedCostnumberRead-onlySearchable
YTDBudgetCostnumberRead-onlySearchable
YTDBudgetLaborCostnumberRead-onlySearchable
YTDBudgetLaborEffortnumberRead-onlySearchable
YTDBudgetMarginnumberRead-onlySearchable
YTDBudgetMarginPercentagenumberRead-onlySearchable
YTDBudgetRevenuenumberRead-onlySearchable
YTDCommittedCostnumberRead-onlySearchable
YTDCostVariancenumberRead-onlySearchable
YTDCostVariancePercentagenumberRead-onlySearchable
YTDForecastCostnumberRead-onlySearchable
YTDForecastCostVariancenumberRead-onlySearchable
YTDForecastCostVariancePercentagenumberRead-onlySearchable
YTDForecastLaborCostnumberRead-onlySearchable
YTDForecastLaborEffortnumberRead-onlySearchable
YTDForecastLaborEffortVariancePercentagenumberRead-onlySearchable
YTDForecastMarginnumberRead-onlySearchable
YTDForecastMarginPercentageVariancenumberRead-onlySearchable
YTDForecastMarginVariancenumberRead-onlySearchable
YTDForecastMarginVariancePercentagenumberRead-onlySearchable
YTDForecastRevenuenumberRead-onlySearchable
YTDForecastRevenueVariancenumberRead-onlySearchable
YTDForecastRevenueVariancePercentagenumberRead-onlySearchable
YTDLaborEffortVariancePercentagenumberRead-onlySearchable
YTDMarginPercentageVariancenumberRead-onlySearchable
YTDMarginVariancenumberRead-onlySearchable
YTDRevenuenumberRead-onlySearchable
YTDRevenueVariancenumberRead-onlySearchable
YTDRevenueVariancePercentagenumberRead-onlySearchable

Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.

Finders 5

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 1

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

Use in AI Agent Studio

More in For Builders.

Pitfalls