Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

ProjectForecasts

The Project Forecasts resource is used to view project forecasts.

Columns

Name Type Description
PlanVersionId [KEY] Long Identifier of the forecast version.
PlanVersionNumber Long The number of the version of the forecast.
PlanVersionName String Name of the forecast version.
PlanVersionDescription String Description of the forecast version.
PlanVersionStatus String The status of the forecast version. A list of valid values is defined in the lookup type PJO_PLAN_STATUS.
ForecastCreationMethod String Determines whether the forecast version is generated from another plan or copied from another forecast version. A list of valid values - Copy from another source and Generate from another source - is defined in the lookup type PJO_FORECAST_CREATION_METHOD. There is no default value while creating a forecast version. You must enter either this attribute or Forecast Creation Method Code but not both while creating a forecast version.
ForecastCreationMethodCode String Determines whether the forecast version is generated from another plan or copied from another forecast version. A list of valid values - COPY and GENERATE - is defined in the lookup type PJO_FORECAST_CREATION_METHOD. There is no default value while creating a forecast version. You must enter either this attribute or Forecast Creation Method but not both while creating a forecast version.
ForecastGenerationSource String Determines whether the forecast version is generated from an existing forecast version based on a financial plan type or from the project plan. A list of valid values - Financial plan type and Project plan type - is defined in the lookup type PJO_PLAN_TYPE_CODE. There is no default value while creating a forecast version. You must enter either this attribute or Forecast Generation Source Code but not both while creating a forecast version.
ForecastGenerationSourceCode String Determines whether the forecast version is generated from an existing forecast version based on a financial plan type or from the project plan. A list of valid values - FINANCIAL_PLAN and PROJECT_PLAN - is defined in the lookup type PJO_PLAN_TYPE_CODE. There is no default value while creating a forecast version. You must enter either this attribute or Forecast Generation Source but not both while creating a forecast version.
SourcePlanVersionId Long Identifier of the version of the project plan, budget, or forecast used as the source for creating the forecast version.
SourcePlanType String Indicates the financial plan type or the project plan from which the forecast version is created. If the forecast generation source is entered as Project plan type, then this attribute is defaulted as project plan by the application. If the forecast generation source is entered as Financial plan type, then you must enter a value for this attribute.
SourcePlanVersionNumber Long The number of the version of the project plan, budget, or forecast used as the source for creating the forecast version.
SourcePlanVersionName String The name of the version of the project plan, budget, or forecast used as the source for creating the forecast version.
SourcePlanVersionStatus String The status of the source plan version from which the forecast version is created. A list of valid values is defined in the lookup type PJO_PLAN_STATUS.
ProjectId Long Identifier of the project for which the forecast version is created. You must enter a value for only one from among this attribute, Project Number, and Project Name but not for all three or a combination of them while creating a forecast version.
ProjectNumber String Number of the project for which the forecast version is created. You must enter a value for only one from among this attribute, Project ID, and Project Name but not for all three or a combination of them while creating a forecast version.
ProjectName String Name of the project for which the forecast version is created. You must enter a value for only one from among this attribute, Project ID, and Project Number but not for all three or a combination of them while creating a forecast version.
FinancialPlanType String Name of the financial plan type used to create the forecast version.
DeferFinancialPlanCreation String Indicates that the forecast version will be created in a deferred mode. The default value is Y. A value of Y means that the forecast version will be created in a deferred mode by the Process Financial Plan Versions process. A value of N means that the forecast version will be created in real time and will be included in the response of the POST operation.
AdministrativeCode String Identifies the action that an administrator can perform on the forecast version based on specific requirements. Not to be used in typical implementations.
LockedFlag Bool Indicates if the project forecast version is locked.
LockedBy String Name of the user who has locked the project forecast version.
PlanningAmounts String Indicates whether a forecast version includes cost amounts, revenue amounts, or both. A list of valid values - Cost, Revenue, and Cost and revenue - is defined in the lookup type PJO_PLANNED_FOR_CODE. There is no default value while creating a forecast version. You must enter either this attribute or Forecast Generation Source but not both while creating a forecast version.
AdjustmentPercentage Decimal Percentage by which to adjust the forecast version amounts when copying amounts from another source.
RawCostInProjectCurrency Decimal The estimated raw cost for the project at the completion of the project in the project currency.
BurdenedCostInProjectCurrency Decimal The estimated burdened cost for the project at the completion of the project in the project currency.
RevenueInProjectCurrency Decimal The estimated revenue for the project at the completion of the project in the project currency.
ActualRawCostInProjectCurrency Decimal The actual raw cost incurred by the project in the project currency.
ActualBurdenedCostInProjectCurrency Decimal The actual burdened cost incurred by the project in the project currency.
ActualRevenueInProjectCurrency Decimal The actual revenue generated by the project in the project currency.
TotalCommitmentsInProjectCurrency Decimal The total commitments incurred by the project in the project currency.
ETCStartDate Date Date when the estimate to complete is intended to begin as planned on the forecast line.
ETCRawCostInProjectCurrency Decimal The estimated raw cost required to complete the project in the project currency.
ETCBurdenedCostInProjectCurrency Decimal The estimated burdened cost required to complete the project in the project currency.
RawCostInProjectLedgerCurrency Decimal The estimated raw cost for the project at the completion of the project in the project ledger currency.
BurdenedCostInProjectLedgerCurrency Decimal The estimated burdened cost for the project at the completion of the project in the project ledger currency.
RevenueInProjectLedgerCurrency Decimal The estimated revenue for the project at the completion of the project in the project currency.
EACLaborEffort Decimal Estimated labor effort for the project at the completion of the project. EAC labor effort includes both billable and nonbillable estimated labor effort at the completion of the project.
EACEquipmentEffort Decimal Estimated equipment effort for the project at the completion of the project. EAC equipment effort includes both billable and nonbillable estimated equipment effort at the completion of the project.
CurrentBaselineBudgetMarginVariance Decimal Variance between the margins of the forecast version and the current baseline budget version.
CurrentBaselineBudgetMarginVariancePercentage Decimal Variance between the margins of the forecast version and the current baseline budget version, expressed as a percentage.
OriginalBaselineBudgetMarginVariance Decimal Variance between the margins of the forecast version and the original baseline budget version.
OriginalBaselineBudgetMarginVariancePercentage Decimal Variance between the margins of the forecast version and the original baseline budget version, expressed as a percentage.
CurrentForecastMarginVariance Decimal Variance between the margins of the forecast version and the current forecast version.
CurrentForecastMarginVariancePercentage Decimal Variance between the margins of the forecast version and the current forecast version, expressed as a percentage.
PreviousForecastMarginVariance Decimal Variance between the margins of the forecast version and the previous forecast version.
PreviousForecastMarginVariancePercentage Decimal Variance between the margins of the forecast version and the previous forecast version, expressed as a percentage.
Margin Decimal The difference between project-related costs and revenue amounts.
MarginPercentage Decimal The difference between project-related costs and revenue amounts, expressed as a percentage.
PlanningOptionId Long Identifier of the planning option setup for the project forecast version.
ProjectResourcesStatus String Status of the project resources to be used for generation. Valid values are: All and Confirmed.
RbsVersionId Long RbsVersionId
Finder String finder

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454