Financial Project Plans
financialProjectPlans Based on 26C
Create, change and look up Financial Project Plans, with planning options, resource assignments and version errors. Actions include adjust for range of projects and baseline financial project plan.
- Operations
- GET (list)GET (one)POST (create)PATCH (update)17 actions
- Record key
PlanVersionId- Required on create
ProjectId- At a glance
- 34 fields0 finders8 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/financialProjectPlans?fields=BaselineBurdenedCostInProjectCurrency,BaselineBurdenedCostInProjectLedgerCurrency,BaselineEffort,BaselineRawCostInProjectCurrency,BaselineRawCostInProjectLedgerCurrency&limit=25&onlyData=true
{
"items": [
{
"BaselineBurdenedCostInProjectCurrency": 0,
"BaselineBurdenedCostInProjectLedgerCurrency": 0,
"BaselineEffort": 0,
"BaselineRawCostInProjectCurrency": 0,
"BaselineRawCostInProjectLedgerCurrency": 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 34
| Attribute | Type | Use |
|---|---|---|
BaselineBurdenedCostInProjectCurrency | number | Read-onlySearchable |
BaselineBurdenedCostInProjectLedgerCurrency | number | Read-onlySearchable |
BaselineEffort | number | Read-onlySearchable |
BaselineRawCostInProjectCurrency | number | Read-onlySearchable |
BaselineRawCostInProjectLedgerCurrency | number | Read-onlySearchable |
BaselineRevenueInProjectCurrency | number | Read-onlySearchable |
BaselineRevenueInProjectLedgerCurrency | number | Read-onlySearchable |
BurdenedCostInProjectCurrency | number | Read-onlySearchable |
BurdenedCostInProjectLedgerCurrency | number | Read-onlySearchable |
CreatedBy | text · max 64 | Read-onlySearchable |
CreationDate | date-time | Read-onlySearchable |
DeferProcessing | text | Optional on createUpdatable |
ITDActualBurdenedCostInProjectCurrency | number | Read-onlySearchable |
ITDActualBurdenedCostInProjectLedgerCurrency | number | Read-onlySearchable |
ITDActualEffort | number | Read-onlySearchable |
ITDActualRawCostInProjectCurrency | number | Read-onlySearchable |
ITDActualRawCostInProjectLedgerCurrency | number | Read-onlySearchable |
ITDActualRevenueInProjectCurrency | number | Read-onlySearchable |
ITDActualRevenueInProjectLedgerCurrency | number | Read-onlySearchable |
LastUpdateDate | date-time | Read-onlySearchable |
LastUpdatedBy | text · max 64 | Read-onlySearchable |
Margin | number | Read-onlySearchable |
MarginPercentage | number | Read-onlySearchable |
PlanVersionId | number | Optional on createSearchable |
PlanVersionStatus | text | Read-onlySearchable |
PlannedEffort | number | Read-onlySearchable |
ProjectId | number | Required on createUpdatableSearchable |
ProjectName | text · max 240 | Read-onlySearchable |
ProjectNumber | text · max 25 | Read-onlySearchable |
ProjectPlanType | text · max 240 | Read-onlySearchable |
RawCostInProjectCurrency | number | Read-onlySearchable |
RawCostInProjectLedgerCurrency | number | Read-onlySearchable |
RevenueInProjectCurrency | number | Read-onlySearchable |
RevenueInProjectLedgerCurrency | number | Read-onlySearchable |
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 8
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/financialProjectPlans/{PlanVersionId}/child/<name>. Add them to a GET with expand.
PlanningOptionsGET · PATCH Planning Options · 63 fields · 1 findersAllowNegativeETCCalculationFlagAssociateProjectCostsToSummaryTaskAssignmentsFlagAutoApproveFlagAutoBaselineFlagAutomaticallyGenerateBudgetVersionFlagAutomaticallyGenerateForecastVersionFlagBudgetFinancialPlanTypeBufferForSynchronizeTaskTransactionDatesWithTaskPlannedDatesBurdenScheduleCostOptionsCalendarTypeCurrentPlanningPeriodDateTypeForConversionInPCDateTypeForConversionInPLCDateTypeForCostConversionDateTypeForRevenueConversionEnableCostsForPlanFlagEnableRevenueForPlanFlagEstimateToCompleteMethodFixedDateForConversionInPCFixedDateForConversionInPLCFixedDateForCostConversionFixedDateForRevenueConversionForecastFinancialPlanTypeJobCostOptionsJobRevenueOptionsMaintainManualSpreadOnDateChangesMultipleTransactionCurrenciesNonlaborResourceCostOptionsNonlaborResourceRevenueOptionsPeriodProfilePersonCostOptionsPersonRevenueOptionsPhysicalPercentCompleteCalculationMethodPlanningOptionIdPlanningResourceBreakdownStructurePrimaryPhysicalPercentCompleteBasisProjectCurrencyProjectLedgerCurrencyProjectRoleCostOptionsProjectRoleRevenueOptionsRateDerivationDateRateDerivationDateTypeRateTypeForConversionInPCRateTypeForConversionInPLCRateTypeForCostConversionRateTypeForRevenueConversionResourceClassCostOptionsResourceClassRevenueOptionsRevenueCalculationMethodRevenueDateTypeForConversionInPCRevenueDateTypeForConversionInPLCRevenueFixedDateForConversionInPCRevenueFixedDateForConversionInPLCRevenueRateTypeForConversionInPCRevenueRateTypeForConversionInPLCRollUpTaskDatesFlagSetUnplannedAssignmentsAsPlannedAssignmentsFlagSynchronizeTaskTransactionDatesWithTaskPlannedDatesFlagThirdPartySchedulingFlagUpdatePlannedQuantityWithEACQuantityFlagUsePlanningRatesFlagUseSameConversionAttributeForAllCurrencyConversionsFlagUseSameDatesForTaskAssignmentsAsTaskDatesFlagPlanningCurrenciesGET · POST · DELETE Planning Currencies · 2 fields · 1 findersPlanningCurrencyCodePlanningCurrencyIdPlanningOptionsDFFGET · PATCH Planning Options Descriptive Flexfields · 3 fields · 1 findersPlanningOptionId__FLEX_Context__FLEX_Context_DisplayValueResourceAssignmentsGET · POST · PATCH · DELETE Resource Assignments · 18 fieldsAdministrativeCodeBaselineFinishDateBaselineStartDateMaintainManualSpreadOnDateChangesPlanningElementIdPlanningFinishDatePlanningStartDateRateBasedFlagRbsElementIdResourceClassResourceNameSpreadCurveTaskIdTaskNameTaskNumberUnitOfMeasureUnplannedFlagUseTaskDatesAsTaskAssignmentDatesFlagPlanningAmountsGET · POST · PATCH Planning Amounts · 42 fieldsBaselineBurdenedCostBaselineBurdenedCostInProjectCurrencyBaselineBurdenedCostInProjectLedgerCurrencyBaselineCurrencyBaselineQuantityBaselineRawCostBaselineRawCostInProjectCurrencyBaselineRawCostInProjectLedgerCurrencyBaselineRevenueBaselineRevenueInProjectCurrencyBaselineRevenueInProjectLedgerCurrencyBurdenedCostBurdenedCostInProjectCurrencyBurdenedCostInProjectLedgerCurrencyCurrencyEffectiveBurdenedCostRateEffectiveRawCostRateEffectiveRevenueRateITDActualBurdenedCostITDActualBurdenedCostInProjectCurrencyITDActualBurdenedCostInProjectLedgerCurrencyITDActualQuantityITDActualRawCostITDActualRawCostInProjectCurrencyITDActualRawCostInProjectLedgerCurrencyITDActualRevenueITDActualRevenueInProjectCurrencyITDActualRevenueInProjectLedgerCurrencyManualSpreadFlagMarginMarginPercentagePlanLineIdPlannedQuantityRawCostRawCostInProjectCurrencyRawCostInProjectLedgerCurrencyRevenueRevenueInProjectCurrencyRevenueInProjectLedgerCurrencyStandardBurdenedCostRateStandardRawCostRateStandardRevenueRatePlanLinesDFFGET · POST · PATCH Plan Lines Descriptive Flexfields · 3 fields · 1 findersPlanLineId__FLEX_Context__FLEX_Context_DisplayValuePlanningAmountDetailsGET · POST · PATCH Planning Amount Details · 28 fieldsBurdenedCostBurdenedCostInProjectCurrencyBurdenedCostInProjectLedgerCurrencyEffectiveBurdenedCostRateEffectiveRawCostRateEffectiveRevenueRateITDActualBurdenedCostITDActualBurdenedCostInProjectCurrencyITDActualBurdenedCostInProjectLedgerCurrencyITDActualQuantityITDActualRawCostITDActualRawCostInProjectCurrencyITDActualRawCostInProjectLedgerCurrencyITDActualRevenueITDActualRevenueInProjectCurrencyITDActualRevenueInProjectLedgerCurrencyManualSpreadFlagPeriodNamePlannedQuantityRawCostRawCostInProjectCurrencyRawCostInProjectLedgerCurrencyRevenueRevenueInProjectCurrencyRevenueInProjectLedgerCurrencyStandardBurdenedCostRateStandardRawCostRateStandardRevenueRateVersionErrorsGET Plan Version Errors · 12 fieldsErrorTypeMessageCauseMessageNameMessageTextMessageUserActionMessageUserDetailsPeriodNamePlanVersionIdResourceNameTaskNameTaskNumberTransactionCurrencyCode
Actions 17
POST …/action/adjustForRangeOfProjects·fromProjectNumberprojectPlanTypeadjustmentPercentageadjustmentTypetoProjectNumberPOST …/action/baselineFinancialProjectPlan·autoBaselineFlagprojectNumbertaskNumberListbudgetFinancialPlanTypeprojectNameprojectIdPOST …/action/baselineRangeOfFinancialProjectPlans·fromProjectNumberprojectPlanTypetoProjectNumberPOST …/action/refreshRatesForRangeOfProjects·fromProjectNumberprojectPlanTyperetainRateOverridetoProjectNumberrefreshOnlyConversionRatesrefreshRatesPeriodForwardPOST …/action/reprocessFailedFinancialProjectPlansPOST …/action/updateActualAmountsForRangeOfProjects·fromProjectNumberprojectPlanTypetoProjectNumberPOST …/action/updatePlannedAmountsFromProgressForRangeOfProjects·fromProjectNumberprojectPlanTypetoProjectNumberPOST …/{PlanVersionId}/action/adjust·adjustmentPercentagefromPeriodadjustmentTypetoPeriodPOST …/{PlanVersionId}/action/refreshRates·retainRateOverriderefreshOnlyConversionRatesrefreshRatesPeriodForwardPOST …/{PlanVersionId}/action/replaceResource·oldResourceEndDatenewResourceElementIdoldResourceElementIdtaskIdPOST …/{PlanVersionId}/action/resourceAssignmentSimulator·quantityeffectiveBurdenedCostRateeffectiveRevenueRateresourceNamerawCostburdenedCostrevenueeffectiveRawCostRatetaskNamecurrencyfinishDaterbsElementIdtaskNumbertaskIdstartDatePOST …/{PlanVersionId}/action/updateActualAmountsPOST …/{PlanVersionId}/action/updatePlannedAmountsFromProgress·taskNumberresourceListPOST …/{PlanVersionId}/child/ResourceAssignments/{PlanningElementId}/child/PlanningAmounts/{PlanLineId}/action/adjust·adjustmentPercentageadjustmentTypePOST …/{PlanVersionId}/child/ResourceAssignments/{PlanningElementId}/child/PlanningAmounts/{PlanLineId}/action/refreshRates·retainRateOverriderefreshOnlyConversionRatesrefreshRatesPeriodForwardPOST …/{PlanVersionId}/child/ResourceAssignments/{PlanningElementId}/child/PlanningAmounts/{PlanLineId}/action/updatePlannedAmountsFromProgressPOST …/{PlanVersionId}/child/ResourceAssignments/{PlanningElementId}/child/PlanningAmounts/{PlanLineId}/child/PlanningAmountDetails/{PlanningAmountDetailsUniqID}/action/adjust·adjustmentPercentageadjustmentType
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/financialProjectPlansand 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:DeferProcessing, notdeferprocessing. - 31 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.