Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

ProjectPlanDetailsTaskWorkItems

The Task Work Items resource is used to view the association of a work item with a project task.

Columns

Name Type Description
ProjectPlanDetailsProjectId [KEY] Long Unique identifier of the project.
ObjectAssociationId [KEY] Long The unique identifier of the association of two business objects. For example, an identifier of the association between a work item and a project task.
TaskId Long Unique identifier of the project task.
TaskName String The name of the task.
TaskNumber String The number of a task that's unique within the project.
TypeId Long The unique identifier of the work item type.
Type String The name of the work item type.
SourceWorkItemId Long The unique identifier of the associated work item in the source application.
WorkItemName String The name of the associated work item in the source application.
WorkItemRevision String The revision of the associated work item in the source application.
WorkItemCurrentStatusCode String The code that represents the current status of the associated work item in the source application.
WorkItemCurrentStatus String The current status of the associated work item in the source application. For example, draft, prototype, or design.
TaskCompletionEventCode String The code that represents the associated work item event or status change in the source application required to automatically mark the project task as complete.
TaskCompletionEvent String The associated work item event or status change required in the source application to automatically mark the project task as complete. For example, approved, production, and suppliers invited.
TaskCompletionEventStatusCode String The code that represents whether the task completion event is pending, completed, or not set. Valid values are ORA_PENDING, ORA_COMPLETE, and ORA_NOT_SET. The list of values is defined in the lookup ORA_PJE_COMPLETION_RULE_STATUS. The list of values can be accessed using the Setup and Maintenance work area and the Manage Standard Lookups task.
TaskCompletionEventStatus String The status that indicates whether the task completion event is pending, completed, or not set. The list of values is defined in the lookup ORA_PJE_COMPLETION_RULE_STATUS. The list of values can be accessed using the Setup and Maintenance work area and the Manage Standard Lookups task.
CreatedBy String The user who created the record.
CreationDate Datetime The date when the record was created.
LastUpdatedBy String The user who last updated the record.
LastUpdateDate Datetime The date when the record was last updated.
Finder String Finder criteria used to filter task work items based on specific search parameters and conditions.
ProjectId Long A finder used to filter data using Finder column. Unique identifier of the project.

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