Tableau Connector for Oracle Fusion Cloud Financials

Build 25.0.9434

ProjectBudgetsPlanningOptions

The Planning Options resource is used to view the planning options configured for the project budget version. Planning options are user-definable options, including plan settings, rate settings, currency settings, and generation options that are used to control planning scenarios. Budget versions inherit planning options that are defined for financial plan types.

Columns

Name Type Description
ProjectBudgetsPlanVersionId [KEY] Long Identifier of the project budget version.
PlanningOptionId [KEY] Long Identifier of the planning option setup for the financial or project plan version.
PlanningResourceBreakdownStructure String Planning resource breakdown structure associated with the project.
PlanningLevel String Level of the budget at which amounts can be entered.
CalendarType String The type of calendar, such as accounting calendar or project accounting calendar, used for entering and displaying periodic financial information.
PeriodProfile String Defines how time periods are grouped and displayed when editing budget versions.
RateDerivationDateType String The date type, for example, the system date or a fixed date that is used as the basis for deriving rates for calculating amounts on a none time phase budget version.
RateDerivationDate Datetime The date that is used as the basis for deriving rates for calculating amounts on a none time phase budget version.
CostRateDerivationDateType String The date type, for example, the system date or a fixed date that is used as the basis for deriving rates for calculating cost amounts.
CostRateDerivationDate Datetime The date that is used as the basis for deriving rates for calculating cost amounts.
BillRateDerivationDateType String The date type, for example, the system date or a fixed date that is used as the basis for deriving rates for calculating revenue amounts.
BillRateDerivationDate Datetime The date that is used as the basis for deriving rates for calculating revenue amounts.
MultipleTransactionCurrencies String Indicates that the plan can use multiple transaction currencies. A value of Y indicates that the attribute is selected. A value of N means that the attribute is not selected.
DesignateAsApprovedCostBudgetFlag Bool Indicates whether a financial plan type is an approved cost budget.
DesignateAsApprovedRevenueBudgetFlag Bool Indicates whether a financial plan type is an approved revenue budget.
CurrentPlanningPeriod String Current planning period that drives the display of the periodic information. It can be the project accounting period or accounting period depending on the selected calendar type. This value is not applicable when the calendar type is set to NONE.
MaintainManualSpreadOnDateChanges String Indicates whether the periodic planning is retained in the plan version on plan line date modifications. A value of Y indicates that the attribute is selected. A value of N means that the attribute is not selected.
EnableBudgetaryControls String Indicates whether a financial plan type is eligible for integration with budgetary controls. A value of Y indicates that the attribute is selected. A value of N means that the attribute is not selected.
AssignTaskResourceInSingleCurrencyFlag Bool Indicates whether a budget line is enabled for assigning resources in a single currency for a task.
ProjectCurrency String Currency for the project.
ProjectLedgerCurrency String Project ledger currency for the project.
UseSameConversionAttributeForAllCurrencyConversionsFlag Bool Indicates whether you can use the same currency conversion attribute for all currencies.
CostRateTypeForConversionInPC String Cost rate type that is used as a cost conversion attribute for project currency.
CostDateTypeForConversionInPC String Date type that is used as a cost conversion attribute for project currency.
CostFixedDateForConversionInPC Datetime The date that is used to derive rates for calculating planned costs for project currency.
CostRateTypeForConversionInPLC String Cost rate type that is used as a cost conversion attribute for project ledger currency.
CostDateTypeForConversionInPLC String Date type that is used as a cost conversion attribute for project ledger currency.
CostFixedDateForConversionInPLC Datetime The date that is used to derive rates for calculating planned costs for project ledger currency.
RateTypeForCostConversion String Cost rate type that is used as a cost conversion attribute for planning currencies.
DateTypeForCostConversion String Date type that is used as a cost conversion attribute for planning currencies.
FixedDateForCostConversion Datetime The date that is used to derive rates for calculating planned costs for planning currencies.
RevenueRateTypeForConversionInPC String Revenue rate type that is used as a revenue conversion attribute for project currency.
RevenueDateTypeForConversionInPC String Date type that is used as a revenue conversion attribute for project currency.
RevenueFixedDateForConversionInPC Datetime The date that is used to derive rates for calculating planned revenue for project currency.
RevenueRateTypeForConversionInPLC String Revenue rate type that is used as a revenue conversion attribute for project ledger currency.
RevenueDateTypeForConversionInPLC String Date type that is used as a revenue conversion attribute for project ledger currency.
RevenueFixedDateForConversionInPLC Datetime The date that is used to derive rates for calculating planned revenue for project ledger currency.
RateTypeForRevenueConversion String Revenue rate type that is used as a revenue conversion attribute for planning currencies.
DateTypeForRevenueConversion String Date type that is used as a revenue conversion attribute for planning currencies.
FixedDateForRevenueConversion Datetime The date that is used to derive rates for calculating planned revenue for planning currencies.
UsePlanningRatesFlag Bool Enables utilization of planning rates for resources and resource classes when calculating budget amounts.
BurdenScheduleCostOptions String A set of burden multipliers that is maintained for use across projects. Also referred to as a standard burden schedule.
PersonCostOptions String Rate schedule used for the calculation of cost amounts for named persons.
JobCostOptions String Rate schedule used for the calculation of cost amounts for jobs.
NonlaborResourceCostOptions String Rate schedule used for the calculation of cost amounts for non-labor resources.
ResourceClassCostOptions String Rate schedule used for the calculation of cost amounts for resource classes. This is used for cost calculation when rates are unavailable in rate schedules for named persons, jobs, or non-labor resources.
PersonRevenueOptions String Rate schedule used for the calculation of revenue amounts for named persons.
JobRevenueOptions String Rate schedule used for the calculation of revenue amounts for jobs.
NonlaborResourceRevenueOptions String Rate schedule used for the calculation of revenue amounts for non-labor resources.
ResourceClassRevenueOptions String Rate schedule used for the calculation of revenue amounts for resource classes. This is used for revenue calculation when rates are unavailable in rate schedules for named persons, jobs, or non-labor resources.
RevenueGenerationMethod String Determines whether budget revenue is calculated based on quantity and rates, event amounts, or the spread ratio specified for tasks.
RetainOverrideRatesFromSourceFlag Bool Indicates whether user specified cost and revenue rates from the source must be retained when generating the target budget version.
DefaultReportingOption String Indicates whether cost or revenue quantity is used for reporting quantity when planning for cost and revenue in a separate budget version. By default, it is set to Cost when planning amounts are cost only or cost and revenue together. When the planning amounts are revenue only, it is set to Revenue.
ReportCost String Determines the cost amount types that are used to calculate and report margins on budgets.
AmountScale String The scale on which amounts are displayed on the user interface. For example, if you select to view amounts in 1000s, the $100,000,000 amount is displayed as 100,000.
CurrencyType String Indicates whether the project currency or the project ledger currency is used for displaying amounts when reviewing budget amounts.
ProjectRoleCostOptions String Rate schedule used for the calculation of cost amounts for project role. This is used for cost calculation when rates are unavailable in rate schedules for named persons.
ProjectRoleRevenueOptions String Rate schedule used for the calculation of revenue amounts for project role. This is used for revenue calculation when rates are unavailable in rate schedules for named persons.
FinancialPlanType String financialplantype
Finder String finder
PlanVersionId Long planversionid
ProjectId Long projectid

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