Project Budgets
projectBudgets Based on 26C
Create, change, delete and look up Project Budgets, with planning options, planning resources and version errors. Actions include adjust for range of projects and refresh rates for range of projects.
- Operations
- GET (list)GET (one)POST (create)PATCH (update)DELETE8 actions
- Record key
PlanVersionId- Required on create
PlanVersionNameProjectIdProjectNameProjectNumber- At a glance
- 31 fields2 finders12 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/projectBudgets?fields=AdministrativeCode,BudgetCreationMethod,BudgetGenerationSource,CopyAdjustmentPercentage,DeferFinancialPlanCreation&limit=25&onlyData=true
{
"items": [
{
"AdministrativeCode": "<string>",
"BudgetCreationMethod": "<string>",
"BudgetGenerationSource": "<string>",
"CopyAdjustmentPercentage": 0,
"DeferFinancialPlanCreation": "Y"
}
],
"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 31
| Attribute | Type | Use |
|---|---|---|
AdministrativeCode | text | Optional on createUpdatable |
BudgetCreationMethod | text | Optional on create |
BudgetGenerationSource | text | Optional on create |
CopyAdjustmentPercentage | number | Optional on create |
DeferFinancialPlanCreation | text · default Y | Optional on createUpdatable |
FinancialPlanType | text · max 240 | Optional on createUpdatableSearchable |
LockedBy | text | Read-onlySearchable |
LockedFlag | yes/no | Optional on createUpdatableSearchable |
PCBurdenedCostAmounts | number | Read-only |
PCRawCostAmounts | number | Read-only |
PCRevenueAmounts | number | Read-only |
PFCBurdenedCostAmounts | number | Read-only |
PFCRawCostAmounts | number | Read-only |
PFCRevenueAmounts | number | Read-only |
PlanVersionDescription | text · max 2000 | Optional on createUpdatableSearchable |
PlanVersionId | number | Read-onlySearchable |
PlanVersionName | text · max 225 | Required on createUpdatableSearchable |
PlanVersionNumber | number | Read-onlySearchable |
PlanVersionStatus | text | Optional on createUpdatableSearchable |
PlanningAmounts | text · max 30 | Optional on createSearchable |
PlanningOptionId | number | Read-onlySearchable |
PlanningResourceBreakdownStructure | text | Optional on createUpdatable |
ProjectId | number | Required on createSearchable |
ProjectName | text · max 240 | Required on createSearchable |
ProjectNumber | text · max 25 | Required on createSearchable |
ProjectResourcesStatus | text | Optional on create |
RbsVersionId | number | Read-onlySearchable |
SourcePlanType | text | Optional on create |
SourcePlanVersionId | number | Optional on create |
SourcePlanVersionNumber | number | Optional on create |
SourcePlanVersionStatus | text | Optional on createUpdatable |
Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.
Finders 2
Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.
CurrentBaselineProjectBudgetFinder·FinancialPlanTypeProjectIdCurrentWorkingProjectBudgetFinder·FinancialPlanTypeProjectId
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 12
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/projectBudgets/{PlanVersionId}/child/<name>. Add them to a GET with expand.
AttachmentsGET · POST · PATCH · DELETE Project Budget Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNamePlanningOptionsGET · POST · PATCH Planning Options · 58 fields · 1 findersAmountScaleAssignTaskResourceInSingleCurrencyFlagBillRateDerivationDateBillRateDerivationDateTypeBurdenScheduleCostOptionsCalendarTypeCostDateTypeForConversionInPCCostDateTypeForConversionInPLCCostFixedDateForConversionInPCCostFixedDateForConversionInPLCCostRateDerivationDateCostRateDerivationDateTypeCostRateTypeForConversionInPCCostRateTypeForConversionInPLCCurrencyTypeCurrentPlanningPeriodDateTypeForCostConversionDateTypeForRevenueConversionDefaultReportingOptionDesignateAsApprovedCostBudgetFlagDesignateAsApprovedRevenueBudgetFlagEnableBudgetaryControlsFixedDateForCostConversionFixedDateForRevenueConversionGenSrcPlanVersionIdJobCostOptionsJobRevenueOptionsMaintainManualSpreadOnDateChangesMultipleTransactionCurrenciesNonlaborResourceCostOptionsNonlaborResourceRevenueOptionsPeriodProfilePersonCostOptionsPersonRevenueOptionsPlanningLevelPlanningOptionIdPlanningResourceBreakdownStructureProjectCurrencyProjectLedgerCurrencyProjectRoleCostOptionsProjectRoleRevenueOptionsRateDerivationDateRateDerivationDateTypeRateTypeForCostConversionRateTypeForRevenueConversionReportCostResourceClassCostOptionsResourceClassRevenueOptionsRetainOverrideRatesFromSourceFlagRevenueDateTypeForConversionInPCRevenueDateTypeForConversionInPLCRevenueFixedDateForConversionInPCRevenueFixedDateForConversionInPLCRevenueGenerationMethodRevenueRateTypeForConversionInPCRevenueRateTypeForConversionInPLCUsePlanningRatesFlagUseSameConversionAttributeForAllCurrencyConversionsFlagAmountTypesGET · POST Amount Types · 8 fields · 1 findersAmountTypeIdBillRateFlagBurdenedCostFlagBurdenedCostRateFlagQuantityFlagRawCostFlagRawCostRateFlagRevenueFlagBudgetaryControlSettingsGET · POST · PATCH Budgetary Control Settings · 5 fields · 1 findersBudgetaryControlSettingIdControlBudgetControlLevelDefaultRateTypeTolerancePercentageExportOptionsGET · POST · PATCH Export Options · 49 fields · 1 findersBurdenedCostEffectiveMultiplierBurdenedCostStandardMultiplierBurdenedCostStandardRateDisplayRatesAndAmountsInMultipleTransactionCurrenciesFlagEffectiveBurdenedCostRateEffectiveRawCostRateEffectiveRevenueRateExportOptionIdFromDateMarginPercentagePlanningCurrencyPlanningResourceProjectCurrencyConversionCostDateProjectCurrencyConversionCostDateTypeProjectCurrencyConversionCostRateProjectCurrencyConversionCostRateTypeProjectCurrencyConversionRevenueDateProjectCurrencyConversionRevenueDateTypeProjectCurrencyConversionRevenueRateProjectCurrencyConversionRevenueRateTypeProjectLedgerCurrencyConversionCostDateProjectLedgerCurrencyConversionCostDateTypeProjectLedgerCurrencyConversionCostRateProjectLedgerCurrencyConversionCostRateTypeProjectLedgerCurrencyConversionRevenueDateProjectLedgerCurrencyConversionRevenueDateTypeProjectLedgerCurrencyConversionRevenueRateProjectLedgerCurrencyConversionRevenueRateTypeResourceClassSpreadCurveStandardRawCostRateStandardRevenueRateTaskNameTaskNumberToDateTotalBurdenedCostTotalBurdenedCostInProjectCurrencyTotalBurdenedCostInProjectLedgerCurrencyTotalMarginTotalMarginInProjectCurrencyTotalMarginInProjectLedgerCurrencyTotalQuantityTotalRawCostTotalRawCostInProjectCurrencyTotalRawCostInProjectLedgerCurrencyTotalRevenueTotalRevenueInProjectCurrencyTotalRevenueInProjectLedgerCurrencyUnitOfMeasurePlanningCurrenciesGET · POST · DELETE Planning Currencies · 2 fields · 1 findersPlanningCurrencyCodePlanningCurrencyIdPlanningOptionsDFFGET · POST · PATCH Planning Options Descriptive Flexfields · 3 fields · 1 findersPlanningOptionId__FLEX_Context__FLEX_Context_DisplayValuePlanningResourcesGET · POST · PATCH · DELETE Planning Resources · 10 fieldsMaintainManualSpreadOnDateChangesPlanningElementIdPlanningEndDatePlanningStartDateRbsElementIdResourceNameTaskIdTaskNameTaskNumberUnitOfMeasurePlanningAmountsGET · POST · PATCH · DELETE Planning Amounts · 19 fields · 1 findersBurdenedCostAmountsCurrencyEffectiveBurdenedCostRateEffectiveRawCostRateEffectiveRevenueRateManualSpreadFlagPCBurdenedCostAmountsPCRawCostAmountsPCRevenueAmountsPFCBurdenedCostAmountsPFCRawCostAmountsPFCRevenueAmountsPlanLineIdQuantityRawCostAmountsRevenueAmountsStandardBurdenedCostRateStandardRawCostRateStandardRevenueRatePlanLinesDFFGET · POST · PATCH Plan Lines Descriptive Flexfields · 3 fields · 1 findersPlanLineId__FLEX_Context__FLEX_Context_DisplayValuePlanningAmountDetailsGET · POST · PATCH · DELETE Planning Amount Details · 19 fieldsBurdenedCostAmountsEffectiveBurdenedCostRateEffectiveRawCostRateEffectiveRevenueRateManualSpreadFlagPCBurdenedCostAmountsPCRawCostAmountsPCRevenueAmountsPFCBurdenedCostAmountsPFCRawCostAmountsPFCRevenueAmountsPeriodNamePlanLineDetailIdQuantityRawCostAmountsRevenueAmountsStandardBurdenedCostRateStandardRawCostRateStandardRevenueRateVersionErrorsGET Version Errors · 12 fieldsErrorTypeMessageCauseMessageNameMessageTextMessageUserActionMessageUserDetailsPeriodNamePlanVersionIdResourceNameTaskNameTaskNumberTransactionCurrencyCode
Actions 8
POST …/action/adjustForRangeOfProjects·fromProjectNumberfinancialPlanTypeadjustmentPercentageadjustmentTypetoProjectNumberplanVersionStatusPOST …/action/refreshRatesForRangeOfProjects·fromProjectNumberfinancialPlanTyperetainRateOverridetoProjectNumberplanVersionStatusrefreshOnlyConversionRatesrefreshRatesPeriodForwardPOST …/action/reprocessFailedProjectBudgetsPOST …/{PlanVersionId}/action/adjust·adjustmentPercentagefromPeriodadjustmentTypetoPeriodcreateNewWorkingVersionPOST …/{PlanVersionId}/action/refreshRates·retainRateOverriderefreshOnlyConversionRatesrefreshRatesPeriodForwardPOST …/{PlanVersionId}/child/PlanningResources/{PlanningElementId}/child/PlanningAmounts/{PlanLineId}/action/adjust·adjustmentPercentageadjustmentTypePOST …/{PlanVersionId}/child/PlanningResources/{PlanningElementId}/child/PlanningAmounts/{PlanLineId}/action/refreshRates·retainRateOverriderefreshOnlyConversionRatesrefreshRatesPeriodForwardPOST …/{PlanVersionId}/child/PlanningResources/{PlanningElementId}/child/PlanningAmounts/{PlanLineId}/child/PlanningAmountDetails/{PlanLineDetailId}/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/projectBudgetsand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
CurrentBaselineProjectBudgetFinderfor 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:AdministrativeCode, notadministrativecode. - 11 fields are read-only: sending them in POST or PATCH fails or is ignored. The builder leaves them out.
- 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.