1. REST API for Oracle Fusion Cloud Project Management
  2. Tasks
  3. Change Orders

Get all change orders

get

/fscmRestApi/resources/11.13.18.05/changeOrders

Request

Query Parameters
  • When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
  • This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.

    Format: ?fields=Attribute1,Attribute2

    Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2
  • Used as a predefined finder to search the collection.

    Format: ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>

    The following are the available finder names and corresponding finder variables:

    • PrimaryKey: Finds a change order with the specified primary key.
      Finder Variables:
      • ChangeDocumentId; integer; External identifier of a project change order.
    • findByChangeDocumentNumber: Finds a change order with the specified change order number.
      Finder Variables:
      • Bind_ChangeDocumentNumber; string; The unique identifier of change order number.
    • findByChangeOrderName: Finds all change orders with the specified name.
      Finder Variables:
      • Bind_Name; string; The name of the change order being queried.
    • findByPrimaryKey: Finds a change order with the specified primary key.
      Finder Variables:
      • Bind_ChangeDocumentId; string; External identifier of a project change order.
    • findChangeOrdersByProject: Finds all change orders with the specified project ID.
      Finder Variables:
      • Bind_ProjectId; string; The unique Identifier of the project for a change order.
    • findChangeOrdersByStage: Finds all change orders with the specified stage.
      Finder Variables:
      • Bind_Stage; string; The stage of the change orders being queried.
    • findChangeOrdersByStatus: Finds all change orders with the specified status.
      Finder Variables:
      • Bind_Status; string; The status of the change orders being queried.
    • findChangeOrdersByTask: Finds all change orders with the specified Task ID.
      Finder Variables:
      • Bind_TaskId; integer; The unique identifier of the task for a change order.
    • findCreatedChangeOrder: Finds all change orders with the specified creator.
      Finder Variables:
      • Bind_CreatorId; string; The unique identifier for the creator of a change order.
    • findMyChangeOrder: Finds all change orders with the specified Owner.
      Finder Variables:
      • Bind_OwnerId; string; The unique identifier for the owner of the change order.
  • This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
  • This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>

    Example:
    self,canonical
  • Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
  • The resource item payload will be filtered in order to contain only data (no links section, for example).
  • This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
  • This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY

    Format: ?q=expression1;expression2

    You can use these queryable attributes to filter this collection resource using the q query parameter:
    • CancelDate; string; Date when the change order was canceled. Application calculated field.
    • CancelReason; string; User comments for cancelling the change order. Mandatory for cancelling the change order.
    • CancelType; string; The code of the reason for canceling the change order. Mandatory for cancelling the change order. Valid values are DUPLICATE, INSUFFICIENT_INFORMATION, NO_LONGER_REQUIRED, OTHER, and REJECTED.
    • ChangeDocumentId; integer; Unique identifier of a project change order. Mandatory for PATCH operation.
    • ChangeDocumentNumber; integer; Unique number of the change order. Application calculated field.
    • Comments; string; User comments for the change order.
    • CreationDate; string; Date when the change order was created. Application calculated.
    • CreatorEmail; string; Email of the creator of a change order.
    • CreatorId; integer; Identifier of the creator for a change order. Mandatory for POST operation if Creator Name or Creator Email is not provided.
    • CreatorName; string; Name of the creator of a change order.
    • Customer; string; Customer of the project for which change order is created. If project is specified for the change order, customer is defaulted to project customer.
    • Description; string; Description of the change order.
    • ImpactIfNotImpl; string; Impact if the change is not implemented.
    • Justification; string; Justification for a change order.
    • Name; string; Name of the change order.
    • OwnerEmail; string; Email of the owner of a change order. The default value is the creator email of the change order.
    • OwnerId; integer; Unique identifier of the owner of change order. The default value is creator of the change order.
    • OwnerName; string; Name of the owner of a change order. The default value is the creator name of the change order.
    • Priority; string; The code of the priority of a change order. Valid values are HIGH, LOW, and MEDIUM. The default value is MEDIUM.
    • ProjectId; integer; Unique identifier of the project for which change document is created.
    • ProjectName; string; Name of the project for which change order is created.
    • Reason; string; The code of the reason for which the change order is created, rejected, and canceled. Valid values are BUDGET_REVISION, CLIENT_SCOPE_CHANGES, CONTRACT_MODIFICATION, DESIGN_CHANGES, GENERAL, OTHER, SCHEDULE_MODIFICATION, and SCOPE_REVISION. The default value is GENERAL.
    • Stage; string; The code of the current stage of a change order. Valid values are CREATE, IMPACT_ANALYSIS, APPROVAL, CLOSE, REVIEW, IMPLEMENTATION. The default value is CREATE.
    • Status; string; The code of the current status of a change order. Status is derived from stage of the change order. You need to mention status only when you want to cancel the change order. Valid value is CANCELED.
    • TaskId; integer; Unique identifier of the task for which change document is created.
    • TaskName; string; Name of the task for which change order is created.
    • TaskNumber; string; Unique number of the task associated with a specific project for which change order is created.
  • The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Header Parameters
  • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
  • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.

There's no request body for this operation.

Back to Top

Response

Supported Media Types

Default Response

The following table describes the default response for this task.
Headers
  • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
  • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Body ()
Root Schema : changeOrders
Type: object
Show Source
Nested Schema : Items
Type: array
Title: Items
The items in the collection.
Show Source
Nested Schema : changeOrders-item-response
Type: object
Show Source
  • Title: Change Order Cancellation Date
    Date when the change order was canceled. Application calculated field.
  • Title: Change Order Cancellation Comments
    Maximum Length: 2000
    User comments for cancelling the change order. Mandatory for cancelling the change order.
  • Title: Reason Code for Canceling
    Maximum Length: 30
    The code of the reason for canceling the change order. Mandatory for cancelling the change order. Valid values are DUPLICATE, INSUFFICIENT_INFORMATION, NO_LONGER_REQUIRED, OTHER, and REJECTED.
  • Title: Change Order ID
    Read Only: true
    Unique identifier of a project change order. Mandatory for PATCH operation.
  • Title: Change Order Number
    Read Only: true
    Unique number of the change order. Application calculated field.
  • Change Impacts
    Title: Change Impacts
    The Change Impacts resource is used to create, view, update, or delete the impacts due to the respective change order.
  • Change Participants
    Title: Change Participants
    The Change Participants resource is used to view, create, update, or delete the participants for a change order.
  • Title: Comments
    Maximum Length: 2000
    User comments for the change order.
  • Title: Creation Date
    Read Only: true
    Date when the change order was created. Application calculated.
  • Title: Creator Email
    Email of the creator of a change order.
  • Title: Creator ID
    Identifier of the creator for a change order. Mandatory for POST operation if Creator Name or Creator Email is not provided.
  • Title: Creator Name
    Name of the creator of a change order.
  • Title: Customer
    Read Only: true
    Customer of the project for which change order is created. If project is specified for the change order, customer is defaulted to project customer.
  • Title: Description
    Maximum Length: 2000
    Description of the change order.
  • Title: Impact if Not Implemented
    Maximum Length: 2000
    Impact if the change is not implemented.
  • Title: Justification
    Maximum Length: 2000
    Justification for a change order.
  • Links
  • Title: Change Order Name
    Maximum Length: 80
    Name of the change order.
  • Title: Change Order Owner Email
    Email of the owner of a change order. The default value is the creator email of the change order.
  • Title: Change Order Owner Id
    Unique identifier of the owner of change order. The default value is creator of the change order.
  • Title: Change Order Owner Name
    Name of the owner of a change order. The default value is the creator name of the change order.
  • Title: Priority Code
    Maximum Length: 30
    The code of the priority of a change order. Valid values are HIGH, LOW, and MEDIUM. The default value is MEDIUM.
  • Title: Project Id
    Unique identifier of the project for which change document is created.
  • Title: Project Name
    Name of the project for which change order is created.
  • Title: Reason Code
    Maximum Length: 30
    The code of the reason for which the change order is created, rejected, and canceled. Valid values are BUDGET_REVISION, CLIENT_SCOPE_CHANGES, CONTRACT_MODIFICATION, DESIGN_CHANGES, GENERAL, OTHER, SCHEDULE_MODIFICATION, and SCOPE_REVISION. The default value is GENERAL.
  • Title: Stage Code
    Maximum Length: 30
    The code of the current stage of a change order. Valid values are CREATE, IMPACT_ANALYSIS, APPROVAL, CLOSE, REVIEW, IMPLEMENTATION. The default value is CREATE.
  • Title: Status Code
    Maximum Length: 30
    The code of the current status of a change order. Status is derived from stage of the change order. You need to mention status only when you want to cancel the change order. Valid value is CANCELED.
  • Title: Task ID
    Unique identifier of the task for which change document is created.
  • Title: Task Name
    Name of the task for which change order is created.
  • Title: Task Number
    Unique number of the task associated with a specific project for which change order is created.
Nested Schema : Change Impacts
Type: array
Title: Change Impacts
The Change Impacts resource is used to create, view, update, or delete the impacts due to the respective change order.
Show Source
Nested Schema : Change Participants
Type: array
Title: Change Participants
The Change Participants resource is used to view, create, update, or delete the participants for a change order.
Show Source
Nested Schema : changeOrders-ChangeImpacts-item-response
Type: object
Show Source
  • Title: Impact Area Code
    Maximum Length: 30
    The code of the impact area of a change order. Valid values are BUDGET_AND_FORECAST, CONTRACTS, OTHERS, PROJECT_PLAN, REQUIREMENTS, and RESOURCES. The default value is PROJECT_PLAN.
  • Change Impact Details
    Title: Change Impact Details
    The Change Impact Details resource is used to view, create, update or delete the impact details for a change order. Change Impact Details can be created only for the impacts where the impact area is defined as Budget and Forecast.
  • Title: Contract Amount
    Contract amount of the impact of a change order.
  • Title: Impact Currency Code
    Maximum Length: 15
    Currency code for the amounts impacted by the change. If project is specified for the change order, currency is defaulted to project currency. Otherwise, default value for currency is USD.
  • Title: Impact Description
    Maximum Length: 2000
    Description of the impact of a change order.
  • Title: Effort in Hours
    Effort required in hours to implement the change requested.
  • Title: Estimated Cost
    Estimated cost to implement the change requested.
  • Title: Estimated Revenue
    Estimated revenue to implement the change requested.
  • Title: Impacted Object ID
    Identifier of the impacted object such as a budget version or a forecast version.
  • Title: Impact Id
    Read Only: true
    Unique identifier of the impact to the change order.
  • Title: Impact Owner Email
    Email of the impact owner.
  • Title: Impact Owner Id
    Resource identifier of the impact owner.
  • Title: Impact Owner Name
    Name of the impact owner.
  • Title: Impact To
    Maximum Length: 30
    The detail of the impacted object type such as a cost budget or revenue budget.
  • Links
  • Title: Impact Name
    Maximum Length: 100
    Summary of the impact of a change order.
Nested Schema : Change Impact Details
Type: array
Title: Change Impact Details
The Change Impact Details resource is used to view, create, update or delete the impact details for a change order. Change Impact Details can be created only for the impacts where the impact area is defined as Budget and Forecast.
Show Source
Nested Schema : changeOrders-ChangeImpacts-ChangeImpactDetails-item-response
Type: object
Show Source
Nested Schema : changeOrders-ChangeParticipants-item-response
Type: object
Show Source
  • Title: Approval or Rejection Comments
    Maximum Length: 2000
    Approval or rejection comments by participant for a change order. Mandatory for rejecting the change order.
  • Title: Approver Indicator
    Maximum Length: 2
    Default Value: false
    Indicates whether a participant is an approver on the change order. Valid values are Y, N, and R. The default value is N.
  • Title: Approver Status
    Maximum Length: 30
    Default Value: N
    Approval status of participant for a change order. Valid values are In Progress, Completed, and Rejected.
  • Title: Assessment Comments
    Maximum Length: 2000
    Assessment comments by participant for a change order.
  • Title: Assessor Indicator
    Maximum Length: 2
    Default Value: false
    Indicates whether a participant is an assessor on the change order. Valid values are Y and N. The default value is N.
  • Title: Assessor Status
    Maximum Length: 30
    Default Value: N
    Assessment status of assessor for a change order. Valid values are In Progress and Completed.
  • Title: Implementation Comments
    Maximum Length: 2000
    Implementation comments by participant for a change order.
  • Title: Implementor Indicator
    Maximum Length: 2
    Default Value: false
    Indicates whether a participant is an implementor on the change order. Valid values are Y and N. The default value is N.
  • Title: Implementor Status
    Maximum Length: 30
    Default Value: N
    Implementation status of participant for a change order. Valid values are In Progress and Completed.
  • Links
  • Title: Participant Email
    Email of the change order participant.
  • Title: Participant Id
    Read Only: true
    Unique identifier of the change order participant.
  • Title: Participant Name
    Name of the change order participant.
  • Title: Participant Resource Id
    Resource identifier of the change order participant.
  • Title: Rejection Date
    Date when change order was rejected. Calculated by application.
  • Title: Rejection Reason Code
    Maximum Length: 30
    The code of the rejection type for a change order. Mandatory for rejecting the change order. Valid values are INSUFFICIENT_INFORMATION, OTHER, SCOPE_REDUCTION, and UNACCEPTABLE_RISK.
  • Title: Review Comments
    Maximum Length: 2000
    Review comments by participant for a change order.
  • Title: Reviewer Indicator
    Maximum Length: 2
    Default Value: true
    Indicates whether a participant is a reviewer on the change order. Valid values are Y and N. The default value is N.
  • Title: Reviewer Status
    Maximum Length: 30
    Default Value: N
    Review status of participant for a change order. Valid values are In Progress and Completed.
Back to Top

Examples

The following example shows how to get all the change orders by submitting a GET request on the REST resource using cURL.

curl --user ppm_cloud_user https://your_organization.com:port/fscmRestApi/resources/11.13.18.05/changeOrders

Example of Response Body

The following example shows the contents of the response body in JSON format.

{
"items": [
  {
"CancelDate": null,
"ChangeDocumentId": 300100036279827,
"CancelReason": null,
"CancelType": null,
"Comments": null,
"CreatorId": 300100023180811,
"Description": null,
"ImpactIfNotImpl": null,
"Justification": null,
"Name": "Dev Test Bug 19244031",
"OwnerId": 300100023180811,
"Priority": "MEDIUM",
"ProjectId": null,
"Reason": "GENERAL",
"Stage": "CREATE",
"Status": "DRAFT",
"OwnerName": "Mark Taylor",
"OwnerEmail": "prj_mark_taylor_in_grp@oracle.com",
"ProjectName": null,
"ChangeDocumentNumber": null,
"CreatorName": "Mark Taylor",
"CreatorEmail": "prj_mark_taylor_in_grp@oracle.com",
"CreationDate": "2014-07-24T00:10:38+00:00",
"Customer": null,
},

{
"CancelDate": null,
"ChangeDocumentId": 300100082399118,
"CancelReason": null,
"CancelType": null,
"Comments": null,
"CreatorId": 300100023180814,
"Description": "Initiating new Change Request for Approval",
"ImpactIfNotImpl": null,
"Justification": "Change Request to incorporate Design change ",
"Name": "PJS BAT Change Order for Approval",
"OwnerId": 300100023180814,
"Priority": "MEDIUM",
"ProjectId": 300100082399099,
"Reason": "DESIGN_CHANGES",
"Stage": "APPROVAL",
"Status": "IN_PROGRESS",
"OwnerName": "Mary Smith",
"OwnerEmail": "prj_mary_smith_in_grp@oracle.com",
"ProjectName": null,
"ChangeDocumentNumber": 24,
"CreatorName": "Mary Smith",
"CreatorEmail": "prj_mary_smith_in_grp@oracle.com",
"CreationDate": "2015-12-10T08:44:07.142+00:00",
"Customer": null,
},

{
"CancelDate": null,
"ChangeDocumentId": 300100082399121,
"CancelReason": null,
"CancelType": null,
"Comments": null,
"CreatorId": 300100023180814,
"Description": " Initiating new Change Request for Implementation",
"ImpactIfNotImpl": null,
"Justification": "Change Request to incorporate Design change ",
"Name": "PJS BAT Change Order for Implementation",
"OwnerId": 300100023180814,
"Priority": "HIGH",
"ProjectId": 300100082399099,
"Reason": "DESIGN_CHANGES",
"Stage": "IMPLEMENTATION",
"Status": "APPROVED",
"OwnerName": "Mary Smith",
"OwnerEmail": "prj_mary_smith_in_grp@oracle.com",
"ProjectName": null,
"ChangeDocumentNumber": 25,
"CreatorName": "Mary Smith",
"CreatorEmail": "prj_mary_smith_in_grp@oracle.com",
"CreationDate": "2015-12-10T08:48:45.003+00:00",
"Customer": null,
},
  
{
"CancelDate": null,
"ChangeDocumentId": 300100082399111,
"CancelReason": null,
"CancelType": null,
"Comments": null,
"CreatorId": 300100023180814,
"Description": "Initiating new Change Request for Review",
"ImpactIfNotImpl": null,
"Justification": "Change Request to incorporate Design change ",
"Name": "PJS BAT Change Order for Review",
"OwnerId": 300100023180814,
"Priority": "HIGH",
"ProjectId": 300100082399099,
"Reason": "DESIGN_CHANGES",
"Stage": "REVIEW",
"Status": "IN_PROGRESS",
"OwnerName": "Mary Smith",
"OwnerEmail": "prj_mary_smith_in_grp@oracle.com",
"ProjectName": null,
"ChangeDocumentNumber": 23,
"CreatorName": "Mary Smith",
"CreatorEmail": "prj_mary_smith_in_grp@oracle.com",
"CreationDate": "2015-12-10T08:39:40.077+00:00",
"Customer": null,
}
,
Back to Top