Tableau Connector for Oracle Fusion Cloud Financials

Build 25.0.9434

FinancialProjectPlansResourceAssignments

The Resource Assignments resource is used to view a financial project plan resource assignment.

Columns

Name Type Description
FinancialProjectPlansPlanVersionId [KEY] Long Identifier of the financial project plan version.
PlanningElementId [KEY] Long Identifier of the resource assignment on the financial project plan version.
TaskId Long Identifier of the task for which a financial project plan resource assignment is created. You must enter either Task Name or Task Number but not for all three or a combination of them while creating a financial project plan resource assignment.
TaskNumber String Number of the task for which a financial project plan resource assignment is created. You must enter either Task Name or Task ID but not for all three or a combination of them while creating a financial project plan resource assignment.
TaskName String Name of the task for which a financial project plan resource assignment is created. You must enter either Task ID or Task Number but not for all three or a combination of them while creating a financial project plan resource assignment.
RbsElementId Long Identifier of the resource breakdown structure element used to create the financial project plan resource assignments line.
ResourceName String Name or alias of the resource included in the planning resource breakdown structure that is used to create the financial project plan resource assignment.
PlanningStartDate Datetime The date that is planned on the financial project plan for a resource to begin their assignment on a project task.
PlanningFinishDate Datetime The date that is planned on the financial project plan for a resource to finish their assignment on a project task.
BaselineStartDate Datetime The date that is planned on the baseline financial project plan for a resource to begin their assignment on a project task.
BaselineFinishDate Datetime The date that is planned on the baseline financial project plan for a resource to finish their assignment on a project task.
SpreadCurve String Name of the set of distribution factors that enables the application to automatically distribute quantity and cost for a resource on a task assignment across a range of accounting or project accounting periods.
UnitOfMeasure String Unit of work that measures the quantity of effort for which the resource is planned for on the financial project plan resource assignment.
ResourceClass String Grouping of predefined resource types to which the resource in the financial project plan resource assignment belongs. A list of valid values are Labor, Equipment, Material Items, and Financial Resources.
UseTaskDatesAsTaskAssignmentDatesFlag Bool Indicates if the resource assignment dates on the task in the financial project plan resource assignment are the same as the task dates on the project.
RateBasedFlag Bool Indicates if the financial project plan resource assignment is rate based.
UnplannedFlag Bool Indicates if the financial project plan resource assignment is unplanned.
AdministrativeCode String Action identifier used for administrative purpose only.
MaintainManualSpreadOnDateChanges String Indicates whether the periodic planning is retained in the plan version on plan line date modifications.
Finder String finder
PlanVersionId Long planversionid

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