Project Work Plan Version 2

A service data object that captures project-related information such as project description, project dates, and task information.

QName: {http://xmlns.oracle.com/apps/projects/projectManagement/common/projectServiceV2/}ProjectPlan

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contains

Project Work Plan Task Version 2

Contains

Opportunity

Handled by

Project Work Plan Version 2

Attributes

The following table describes attributes in the service data object.

Name Type Description

CompletionDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Planned finish date of the project.

Description

string

Description of the project.

EPSName

string

Name of the enterprise project structure element associated to the project.

EffortUnit

string

Unit of measure for effort. Valid values are DAYS, HOURS, or MINUTES.

ExternalProjectId

string

Identifier of the project from the source application.
  • Primary Key

HoursPerDay

int

Number of hours in a working day. Used to convert between hours and days.

IsIntegrated

string

Indicator whether the task is integrated with corresponding financial system.

LastSyncDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Indicates date and time when this task was last synchronized with corresponding financial system.

Name

string

Name of the project.

NumberAttr01

decimal

Value for user-defined project numeric attribute 01.

NumberAttr02

decimal

Value for user-defined project numeric attribute 02.

NumberAttr03

decimal

Value for user-defined project numeric attribute 03.

NumberAttr04

decimal

Value for user-defined project numeric attribute 04.

NumberAttr05

decimal

Value for user-defined project numeric attribute 05.

NumberAttr06

decimal

Value for user-defined project numeric attribute 06.

NumberAttr07

decimal

Value for user-defined project numeric attribute 07.

NumberAttr08

decimal

Value for user-defined project numeric attribute 08.

NumberAttr09

decimal

Value for user-defined project numeric attribute 09.

NumberAttr10

decimal

Value for user-defined project numeric attribute 10.

Opportunity

Opportunity

Details of the opportunity associated to the project.

ProjectCategory

string

Category of the project. Currently, the only valid value is FIN_EXEC.

ProjectCode01

string

Value for user-defined project attribute value set 01.

ProjectCode02

string

Value for user-defined project attribute value set 02.

ProjectCode03

string

Value for user-defined project attribute value set 03.

ProjectCode04

string

Value for user-defined project attribute value set 04.

ProjectCode05

string

Value for user-defined project attribute value set 05.

ProjectCode06

string

Value for user-defined project attribute value set 06.

ProjectCode07

string

Value for user-defined project attribute value set 07.

ProjectCode08

string

Value for user-defined project attribute value set 08.

ProjectCode09

string

Value for user-defined project attribute value set 09.

ProjectCode10

string

Value for user-defined project attribute value set 10.

ProjectCode11

string

Value for user-defined project attribute value set 11.

ProjectCode12

string

Value for user-defined project attribute value set 12.

ProjectCode13

string

Value for user-defined project attribute value set 13.

ProjectCode14

string

Value for user-defined project attribute value set 14.

ProjectCode15

string

Value for user-defined project attribute value set 15.

ProjectCode16

string

Value for user-defined project attribute value set 16.

ProjectCode17

string

Value for user-defined project attribute value set 17.

ProjectCode18

string

Value for user-defined project attribute value set 18.

ProjectCode19

string

Value for user-defined project attribute value set 19.

ProjectCode20

string

Value for user-defined project attribute value set 20.

ProjectCode21

string

Value for user-defined project attribute value set 21.

ProjectCode22

string

Value for user-defined project attribute value set 22.

ProjectCode23

string

Value for user-defined project attribute value set 23.

ProjectCode24

string

Value for user-defined project attribute value set 24.

ProjectCode25

string

Value for user-defined project attribute value set 25.

ProjectCode26

string

Value for user-defined project attribute value set 26.

ProjectCode27

string

Value for user-defined project attribute value set 27.

ProjectCode28

string

Value for user-defined project attribute value set 28.

ProjectCode29

string

Value for user-defined project attribute value set 29.

ProjectCode30

string

Value for user-defined project attribute value set 30.

ProjectCode31

string

Value for user-defined project attribute value set 31.

ProjectCode32

string

Value for user-defined project attribute value set 32.

ProjectCode33

string

Value for user-defined project attribute value set 33.

ProjectCode34

string

Value for user-defined project attribute value set 34.

ProjectCode35

string

Value for user-defined project attribute value set 35.

ProjectCode36

string

Value for user-defined project attribute value set 36.

ProjectCode37

string

Value for user-defined project attribute value set 37.

ProjectCode38

string

Value for user-defined project attribute value set 38.

ProjectCode39

string

Value for user-defined project attribute value set 39.

ProjectCode40

string

Value for user-defined project attribute value set 40.

ProjectCurrencyCode

string

Code indicating the currency in which financial amounts are recorded in the project plan. If no currency is specified, the application uses the default project currency specified during application setup.

ProjectManagerEmailId

string

E-mail address of the project manager.

ProjectManagerId

long

Identifier of the project manager assigned to the project.

ProjectNumber

string

Identifier of the project from the source application.

ProjectPlanViewAccessCode

string

Access level code that specifies who can view the project plan in Oracle Fusion Task Management.Valid codes are ORA_PJT_PRJ_PLAN_VIEW_TEAM and ORA_PJT_PRJ_PLAN_VIEW_ALL

ProjectStatus

string

Status of the project. Valid values are active, draft, or closed.

ProjectTask

Project Work Plan Task Version 2

List of tasks in the project work plan.

ScheduleId

long

Identifier of the calendar used on the project work plan.

ScheduleName

string

Name of the calendar used for planning the project.

ScheduleTypeCode

string

The schedule type of the project.Valid values are FIXED_EFFORT and FIXED_DURATION.

StartDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Start date of the project.

TextAttr01

string

Value for user-defined project free form text attribute 01.

TextAttr02

string

Value for user-defined project free form text attribute 02.

TextAttr03

string

Value for user-defined project free form text attribute 03.

TextAttr04

string

Value for user-defined project free form text attribute 04.

TextAttr05

string

Value for user-defined project free form text attribute 05.

TextAttr06

string

Value for user-defined project free form text attribute 06.

TextAttr07

string

Value for user-defined project free form text attribute 07.

TextAttr08

string

Value for user-defined project free form text attribute 08.

TextAttr09

string

Value for user-defined project free form text attribute 09.

TextAttr10

string

Value for user-defined project free form text attribute 10.

TextAttr11

string

Value for user-defined project free form text attribute 11.

TextAttr12

string

Value for user-defined project free form text attribute 12.

TextAttr13

string

Value for user-defined project free form text attribute 13.

TextAttr14

string

Value for user-defined project free form text attribute 14.

TextAttr15

string

Value for user-defined project free form text attribute 15.

TextAttr16

string

Value for user-defined project free form text attribute 16.

TextAttr17

string

Value for user-defined project free form text attribute 17.

TextAttr18

string

Value for user-defined project free form text attribute 18.

TextAttr19

string

Value for user-defined project free form text attribute 19.

TextAttr20

string

Value for user-defined project free form text attribute 20.