Project Plan Response

A service data object that provides information such as project description, project dates, and task details for a project.

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

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 Translation SDO Version 2

Contains

Project Descriptive Flexfields SDO

Contains

Project Task Response SDO

Contains

Opportunity Response SDO

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.

CreatedFromProjectId

long

Identifier of the financial project template from which the project is created.

Description

string

Description of the project.

EPSName

string

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

Email

string

E-mail address of the project manager.

ExternalProjectId

string

Identifier of the project from the source application.

HoursPerDay

float

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

IsIntegrated

string

Indicator of 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.

LastUpdatedDate

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

The date when you last updated the project.

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.

ObjectVersionNumber

int

Number used to implement optimistic locking. This number is incremented every time a row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

ProjectCategory

string

Category of the project. 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.

ProjectId

long

Identifier of the project.
  • Primary Key

ProjectNumber

string

User-defined number that identifies the project.

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.

ProjectStatusCode

string

Code that represents the status of the project.

ProjectTranslation

Project Work Plan Translation Version 2

Language-specific project work plan information including names and descriptions.

ReadOpportunity

Opportunity Response

Details of the opportunity associated to the project.

ReadProjectDff

Project Descriptive Flexfields SDO

The descriptive flexfield values defined on the project.

ReadProjectTaskResponse

Project Task Response

List of tasks in the project work plan.

ResourceId

long

Identifier of the project manager assigned to the project.

ScheduleId

long

Identifier of the calendar used to define a project plan.

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

Planned start date of the project.

TemplateIndicator

string

Indicator of whether the work plan is a work plan template or an actual project work plan.

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.