Project Work Plan Version 2

Logical Business Objects

Projects : Project Management : Project Work Plan

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
Handles	Task Descriptive Flexfields SDO
Handles	Project Descriptive Flexfields SDO
Handles	Opportunity Translation SDO
Handles	Opportunity SDO
Handles	Project Work Plan Messages SDO Version 2
Handles	Project Work Plan Response SDO Version 2
Handles	Project Work Plan Task SDO Version 2
Handles	Project Plan Response SDO
Handles	Project Work Plan Information SDO Version 2
Handles	Opportunity Response SDO
Handles	Project Work Plan Resource SDO Version 2
Handles	Project Work Plan Resource Translation SDO
Handles	Project Work Plan Token SDO Version 2
Handles	Project Information SDO
Handles	Project Plan Expense Resource SDO
Handles	Project Task Information SDO
Handles	Project Work Plan User-Defined Fields SDO Version 2
Handles	Work Plan Template SDO
Handles	Project Work Plan Translation SDO Version 2
Handles	Project Work Plan SDO Version 2
Handles	Project Work Plan Task Translation SDO Version 2
Handles	Expense Resources SDO
Handles	Project Work Plan Exception SDO Version 2
Handles	Project Work Plan List SDO Version 2
Handles	Project Task Response SDO
Handles	Labor Resources SDO

Operations

getProjectExceptions
createProjectPlan
getMyProjectList
updateProjectPlan
createProjectPlanFromTemplate
getProjectProductTypeServicePropertyPath
getProjectServiceNamespaceAndName
getProjectServicePropertyPaths
getTaskProductTypeServicePropertyPath
getTaskServiceNamespaceAndName
getTaskServicePropertyPaths
findProject
findProjectByProjectId
findProjectPlan
findProjectPlanByProjectName
findProjectPlanByProjectId
updateProjectPlanDescriptiveFlexfields
getDfltObjAttrHints
getServiceLastUpdateTime
getEntityList

getProjectExceptions

Finds the list of task exceptions based on the project identifier.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
projectId	long	Identifier of the project work plan to be retrieved.

Response Payload

Element Name	Type	Description
result	Project Work Plan Exception Version 2	Response for the request to return a list of task exceptions for a project that matches the project identifier.

createProjectPlan

Creates a project work plan.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
projectPlanRow	Project Work Plan Version 2	Details of the project plan information created.

Response Payload

Element Name	Type	Description
result	Project Work Plan Response Version 2	Response for the request to create a project work plan.

getMyProjectList

Finds and retrieves the list of projects managed by the user identifier.

Life Cycle Status: Active

Request Payload

Response Payload

Element Name	Type	Description
result	Project Work Plan List Version 2	Response to the request to retrieve a list of projects for a specified user.

updateProjectPlan

Updates an existing project work plan.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
projectPlanRow	Project Work Plan Version 2	Details of the project plan information updated.
projectName	string	Name of the project work plan to be updated.

Response Payload

Element Name	Type	Description
result	Project Work Plan Response Version 2	Response for the request to update a project work plan.

createProjectPlanFromTemplate

Creates a project work plan using a project work plan template.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
projectPlanRow	Project Work Plan Version 2	Object that represents the source project work plan.
projectTemplateRow	Work Plan Template	Object that represents the project work plan template to use when creating the project work plan.

Response Payload

Element Name	Type	Description
result	Project Work Plan Response Version 2	Response for the request to create a project plan using a project work plan template.

getProjectProductTypeServicePropertyPath

Gets the product type service for project descriptive flexfields.

Life Cycle Status: Active

Request Payload

Response Payload

Element Name	Type	Description
result	string	Returns the service property path for product type descriptive flexfields.

getProjectServiceNamespaceAndName

Gets the service name for project descriptive flexfields.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
productType	string	The value of product type.

Response Payload

Element Name	Type	Description
result	string	Returns the name and namespace for project descriptive flexfields.

getProjectServicePropertyPaths

Gets the service property for project descriptive flexfields.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
productType	string	The value of product type.
segmentCodes	string	The list of segment codes.

Response Payload

Element Name	Type	Description
result	string	Returns the service property path for projct descriptive flexfields.

getTaskProductTypeServicePropertyPath

Gets the product type service for task descriptive flexfields.

Life Cycle Status: Active

Request Payload

Response Payload

Element Name	Type	Description
result	string	Returns the product type service property path for task descriptive flexfields.

getTaskServiceNamespaceAndName

Gets the service name for task descriptive flexfields.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
productType	string	The value of product type.

Response Payload

Element Name	Type	Description
result	string	Returns the name and namespace for task descriptive flexfields.

getTaskServicePropertyPaths

Gets the service property for task descriptive flexfields.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
productType	string	The value of product type.
segmentCodes	string	The list of segment codes.

Response Payload

Element Name	Type	Description
result	string	Returns the service property path for task descriptive flexfields.

findProject

Reads project header information based on any project attribute such as project status, opportunity name, or project codes.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
findCriteria	{http://xmlns.oracle.com/adf/svc/types/}FindCriteria	Criteria to filter the response to the request to find projects. For example, use project status to find closed projects.
findControl	{http://xmlns.oracle.com/adf/svc/types/}FindControl	Option to specify if the response to the request to find project should contain all translations.

Response Payload

Element Name	Type	Description
result	Project Work Plan Information Version 2	Response to the request to find a project that returns the project header information for the projects that matches the criteria.

findProjectByProjectId

Finds project header information based on the project identifier.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
findCriteria	{http://xmlns.oracle.com/adf/svc/types/}FindCriteria	Criteria used to filter query results.
BindProjectId	long	Identifier of the project to be retrieved.
findControl	{http://xmlns.oracle.com/adf/svc/types/}FindControl	Option to specify if the response to the request to find project based on project identifier should contain all translations.

Response Payload

Element Name	Type	Description
result	Project Work Plan Information Version 2	Response for the request to find a project that returns the project header information based on the project identifier.

findProjectPlan

Reads project work plans based on any project attribute such as project status, opportunity name, or project codes.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
findCriteria	{http://xmlns.oracle.com/adf/svc/types/}FindCriteria	Criteria to filter the response to the request to find project work plans. For example, use project status to find closed project work plans.
findControl	{http://xmlns.oracle.com/adf/svc/types/}FindControl	Option to specify if the response to the request to find project plan should contain all translations.

Response Payload

Element Name	Type	Description
result	Project Plan Response	Response for the request to find project plan that returns the project work plans for the projects that match the search criteria.

findProjectPlanByProjectName

Finds a project work plan based on the project name.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
findCriteria	{http://xmlns.oracle.com/adf/svc/types/}FindCriteria	Criteria used to filter query results.
BindProjectName	string	Name of the project work plan to be retrieved.
findControl	{http://xmlns.oracle.com/adf/svc/types/}FindControl	Option to specify if the response to the request to find project plan based on project name should contain all translations.

Response Payload

Element Name	Type	Description
result	Project Plan Response	Response to the request to find a project work plan based on the project name.

findProjectPlanByProjectId

Finds a project work plan based on the project identifier.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
findCriteria	{http://xmlns.oracle.com/adf/svc/types/}FindCriteria	Criteria used to filter query results.
BindProjectId	long	Identifier of the project work plan to be retrieved.
findControl	{http://xmlns.oracle.com/adf/svc/types/}FindControl	Option to specify if the response to the request to find project plan based on project identifier should contain all translations.

Response Payload

Element Name	Type	Description
result	Project Plan Response	Response for the request to find a project work plan based on the project identifier.

updateProjectPlanDescriptiveFlexfields

Updates project plan and task structure descriptive flexfield attributes.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
projectForDff	Project Information SDO	Updates the project plan descriptive flexfields with the input parameters provided.

Response Payload

Element Name	Type	Description
result	Project Information SDO	Returns the updated descriptive flexfields.

getDfltObjAttrHints

Retrieves user interface hints, such as the service data object label and object attribute labels, for the specified service data object and locale. As a prerequisite, process the getEntityList operation defined on this service to get the list of possible values for the viewName request payload element.

Life Cycle Status: Active

Request Payload

Element Name	Type	Description
viewName	string	The service view usage name, an internal name for the service data object. Specify the value of the element from the getEntityList operation response payload.
localeName	string	The locale to use when evaluating locale-based user interface hints. The localeName is in ISO 639-1 format.

Response Payload

Element Name	Type	Description
result	{http://xmlns.oracle.com/adf/svc/types/}ObjAttrHints	The label and user interface hints for the specified service data object and its attributes in a name-value pair format.

getServiceLastUpdateTime

Returns the date and time when the schema files referenced in the service definition last changed.

Life Cycle Status: Active

Request Payload

Response Payload

Element Name	Type	Description
result	{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp	The date and time when the service definition last changed in ISO 8601 format.

getEntityList

Gets the list of service data objects defined on this service.

Life Cycle Status: Active

Request Payload

Response Payload

Element Name	Type	Description
result	{http://xmlns.oracle.com/adf/svc/types/}ServiceViewInfo	A list of service data objects defined on this service. For each service data object, the result includes the QName, internal name, and Boolean values indicating whether create, update, merge, and delete operations can be performed on the object.

Security

The following tables list the privileges required to perform the service operations, and the duty roles that each privilege is granted to.

Service Operations to Privileges Mapping

Operation Name	Privilege Code	Privilege Name	Privilege Description
All Operations	PJT_MANAGE_PROJECT_WORK_PLAN_SERVICE_PRIV	Manage Project Work Plan Service	Allows access to the project work plan service for creation of project, addition and organization of tasks, and maintenance of project and task details.

Privileges to Duty Roles Mapping

Privilege Code	Granted to Duty Role Code	Granted to Duty Role Name	Granted To Duty Role Description
PJT_MANAGE_PROJECT_WORK_PLAN_SERVICE_PRIV	ORA_PJF_PROJECT_MANAGEMENT_DUTY_ABSTRACT	Project Management Duty	Manages individual projects and is not assigned the project manager job role. Performs web service operations to create and update projects, tasks, resources, and associated attributes. Manages the integration between Oracle Fusion Project Foundation and Oracle Fusion Project Management.
PJT_MANAGE_PROJECT_WORK_PLAN_SERVICE_PRIV	ORA_PJT_PROJECT_EXECUTION_APPLICATION_ADMINISTRATION_DUTY	Project Execution Application Administration	Performs setup tasks such as defining progress thresholds, default calendar options for projects and resources, enterprise codes for projects and tasks, and calendars to establish work schedules for projects and resources. Manages project enterprise resources, project roles, resource pools, target utilization percentages, and project enterprise resource maintenance conditions. Initiates processes to maintain the project resource search index.

Duty Roles to Duty or Job Roles Mapping

Duty Role Code	Granted to Duty or Job Role Code	Granted to Duty or Job Role Name	Granted To Duty or Job Role Description
ORA_PJF_PROJECT_MANAGEMENT_DUTY_ABSTRACT	ORA_FUN_FSCM_LOAD_INTERFACE_ADMIN_DUTY	FSCM Load Interface Administration	Manages load interface file for import
ORA_PJF_PROJECT_MANAGEMENT_DUTY_ABSTRACT	ORA_PJO_PROJECT_BUDGET_BASELINE_CREATION_DUTY	Project Budget Baseline Creation	Allows creation of baseline version of project budget.
ORA_PJF_PROJECT_MANAGEMENT_DUTY_ABSTRACT	ORA_PJO_PROJECT_BUDGET_MANAGEMENT_DUTY	Project Budget Management	Creates, edits, and deletes working budget versions. Edits versions in Excel. Submits versions for baseline creation.
ORA_PJF_PROJECT_MANAGEMENT_DUTY_ABSTRACT	ORA_PJF_PROJECT_DEFINITION_DUTY	Project Definition	Edits project and task attributes.
ORA_PJF_PROJECT_MANAGEMENT_DUTY_ABSTRACT	ORA_PJO_PROJECT_PLAN_MANAGEMENT_DUTY	Project Plan Management	Creates, edits, and deletes task assignments and views project progress.
ORA_PJF_PROJECT_MANAGEMENT_DUTY_ABSTRACT	ORA_PJF_PROJECTS_REPORTING_ANALYSIS_DUTY	Projects Reporting Analysis	Access project Business Intelligence Applications data.
ORA_PJF_PROJECT_MANAGEMENT_DUTY_ABSTRACT	ORA_XCC_TRANSACTIONAL_DUTY	Transaction Entry with Budgetary Control	Manages the budgetary control tasks by job roles who perform transactions that are subject to budgetary control, such as accounts payable manager.