Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

FinancialProjectPlans

The Financial Project Plan resource is used to view the financial project plan version.

Columns

Name Type Description
PlanVersionId [KEY] Long Identifier of the financial project plan version.
ProjectPlanType String Name of the project plan type from which the financial project plan is created.
ProjectId Long Identifier of the project for which the financial project plan is created. You must enter either Project Name or Project Number but not for all three or a combination of them while creating a financial project plan.
ProjectNumber String Number of the project for which the financial project plan is created. You must enter either Project ID or Project Name but not for all three or a combination of them while creating a financial project plan.
ProjectName String Name of the project for which the financial project plan is created. You must enter either Project ID or Project Number but not for all three or a combination of them while creating a financial project plan.
PlannedEffort Decimal Measure of the effort planned for in the financial project plan version, expressed in hours.
ITDActualEffort Decimal Actual effort for the project from the start of the project till the current date, expressed in hours.
BaselineEffort Decimal Measure of the effort planned in the baseline financial project plan version, expressed in hours.
RawCostInProjectCurrency Decimal Planned cost for the project in project currency that corresponds to the work performed.
ITDActualRawCostInProjectCurrency Decimal Actual cost incurred for the project in project currency that corresponds to the work performed from the start date of the project till the current date.
BaselineRawCostInProjectCurrency Decimal Planned cost for the project in project currency in the baseline financial project plan version that corresponds to the work performed.
BurdenedCostInProjectCurrency Decimal Total planned cost for the project in project currency that includes both raw and burden costs.
ITDActualBurdenedCostInProjectCurrency Decimal Actual cost incurred for the project, including raw and burden costs, in project currency from the start date of the project till the current date.
BaselineBurdenedCostInProjectCurrency Decimal Total planned cost for the project, including raw and burden costs, in project currency in the baseline financial project plan version.
RawCostInProjectLedgerCurrency Decimal Planned cost for the project in project ledger currency that corresponds to the work performed.
ITDActualRawCostInProjectLedgerCurrency Decimal Actual cost incurred for the project in project ledger currency that corresponds to the work performed from the start date of the project till the current date.
BaselineRawCostInProjectLedgerCurrency Decimal Planned cost for the project in project ledger currency in the baseline financial project plan version that corresponds to the work performed.
BurdenedCostInProjectLedgerCurrency Decimal Total planned cost for the project in project ledger currency that includes both raw and burden costs.
ITDActualBurdenedCostInProjectLedgerCurrency Decimal Actual cost incurred for the project, including raw and burden costs, in project ledger currency from the start date of the project till the current date.
BaselineBurdenedCostInProjectLedgerCurrency Decimal Total planned cost for the project, including raw and burden costs, in project ledger currency in the baseline financial project plan version.
PlanVersionStatus String Indicates the status of the financial project plan version. Valid values are Current Working, Processing, and Failed.
DeferProcessing String Indicates that the financial project plan version will be managed in a deferred mode.
Finder String finder

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