Jump to

• Request
• Response

Get all work order group

get

/fscmRestApi/resources/11.13.18.05/workOrderGroups

Request

Query Parameters

• expand: string
  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).
• fields: string
  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
• finder: string
  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 the work order group with the specified primary key.
    Finder Variables:
    • WoGroupId; integer; Unique identifier of the work order in the work order group.
• limit: integer
  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.
• links: string
  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
  
• offset: integer
  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.
• onlyData: boolean
  The resource item payload will be filtered in order to contain only data (no links section, for example).
• orderBy: string
  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
• q: string
  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:
  

  • CreatedBy; string; Indicates the user who created the work order group.
  • CreationDate; string; Indicates the date and time when the work order group was created.
  • GroupCode; string; Represents the user key for the work order group entity.
  • GroupDescription; string; Description of the work order group.
  • GroupName; string; Name of the work order group.
  • GroupSource; string; Indicates the source of the group definition, allowing for separate groups to be defined for different products, such as Manufacturing or Maintenance. Valid values can be found in the lookup with the lookup type = ORA_WIE_SOURCE.
  • InactiveDate; string; Date when the work order group becomes inactive.
  • LastUpdateDate; string; Indicates the date and time of the most recent update to the work order group.
  • LastUpdateLogin; string; Indicates the session login of the user who last updated the work order group.
  • LastUpdatedBy; string; Indicates the user who made the most recent update to the work order group.
  • ObjectVersionNumber; integer; This number is used to implement optimistic locking, and it increments each time the row is updated. It's compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
  • OrganizationCode; string; Abbreviation that identifies the inventory organization that's enabled for manufacturing.
  • OrganizationId; integer; Organization identifier that represents the plant to which this work order group belongs.
  • OrganizationIdOrg; integer; Organization identifier that represents the plant to which this work order group is assigned.
  • OrganizationName; string; Name of the inventory organization that's enabled for manufacturing.
  • Status; string; Represents the status of the work order group.
  • WoGroupId; integer; Unique identifier for a work order group record, generated automatically by the application.
• totalResults: boolean
  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

• Metadata-Context: string
  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".
• REST-Framework-Version: string
  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

• application/json

Default Response

The following table describes the default response for this task.

Headers

• Metadata-Context:
  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".
• REST-Framework-Version:
  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 : workOrderGroups

Type: object

Show Source

• count(required): integer
  The number of resource instances returned in the current range.
• hasMore(required): boolean
  Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
• items: array Items
  Title: Items

  The items in the collection.
• limit(required): integer
  The actual paging size used by the server.
• links(required): array Links
  Title: Links

  The link relations associated with the resource instance.
• offset(required): integer
  The offset value used in the current page.
• totalResults: integer
  The estimated row count when "?totalResults=true", otherwise the count is not included.

{
    "required":[
        "count",
        "hasMore",
        "limit",
        "links",
        "offset"
    ],
    "type":"object",
    "properties":{
        "count":{
            "type":"integer",
            "description":"The number of resource instances returned in the current range."
        },
        "hasMore":{
            "type":"boolean",
            "description":"Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false."
        },
        "items":{
            "title":"Items",
            "type":"array",
            "description":"The items in the collection.",
            "items":{
                "$ref":"#/components/schemas/workOrderGroups-item-response"
            }
        },
        "limit":{
            "type":"integer",
            "description":"The actual paging size used by the server."
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "offset":{
            "type":"integer",
            "description":"The offset value used in the current page."
        },
        "totalResults":{
            "type":"integer",
            "description":"The estimated row count when \"?totalResults=true\", otherwise the count is not included."
        }
    },
    "x-hints":{
        "subgroup":"Manufacturing",
        "usage":"BusinessObject",
        "group":"SCM"
    }
}

Nested Schema : Items

Type: array

Title: Items

The items in the collection.

Show Source

• Array of: object workOrderGroups-item-response

{
    "title":"Items",
    "type":"array",
    "description":"The items in the collection.",
    "items":{
        "$ref":"#/components/schemas/workOrderGroups-item-response"
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : workOrderGroups-item-response

Type: object

Show Source

• CreatedBy: string
  Read Only: true

  Maximum Length: 64

  Indicates the user who created the work order group.
• CreationDate: string (date-time)
  Read Only: true

  Indicates the date and time when the work order group was created.
• GroupCode: string
  Title: Group Code

  Maximum Length: 30

  Represents the user key for the work order group entity.
• GroupDescription: string
  Title: Group Description

  Maximum Length: 240

  Description of the work order group.
• GroupName: string
  Maximum Length: 120

  Name of the work order group.
• GroupSource: string
  Title: Group Source

  Maximum Length: 30

  Default Value: ORA_MANUFACTURING

  Indicates the source of the group definition, allowing for separate groups to be defined for different products, such as Manufacturing or Maintenance. Valid values can be found in the lookup with the lookup type = ORA_WIE_SOURCE.
• InactiveDate: string (date)
  Date when the work order group becomes inactive.
• LastUpdateDate: string (date-time)
  Read Only: true

  Indicates the date and time of the most recent update to the work order group.
• LastUpdatedBy: string
  Read Only: true

  Maximum Length: 64

  Indicates the user who made the most recent update to the work order group.
• LastUpdateLogin: string
  Read Only: true

  Maximum Length: 32

  Indicates the session login of the user who last updated the work order group.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• ObjectVersionNumber: integer (int32)
  This number is used to implement optimistic locking, and it increments each time the row is updated. It's compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
• OrganizationCode: string
  Maximum Length: 18

  Abbreviation that identifies the inventory organization that's enabled for manufacturing.
• OrganizationId: integer (int64)
  Title: Organization

  Organization identifier that represents the plant to which this work order group belongs.
• OrganizationIdOrg: integer (int64)
  Read Only: true

  Organization identifier that represents the plant to which this work order group is assigned.
• OrganizationName: string
  Title: Organization

  Read Only: true

  Maximum Length: 240

  Name of the inventory organization that's enabled for manufacturing.
• Status: string
  Read Only: true

  Maximum Length: 255

  Represents the status of the work order group.
• WoGroupId: integer (int64)
  Unique identifier for a work order group record, generated automatically by the application.
• WorkOrderGroupDetail: array Work Order Group Detail
  Title: Work Order Group Detail

  The details of the group name and the work orders associated with it.
• WorkOrderGroupDFF: array Flexfields for Work Order Group
  Title: Flexfields for Work Order Group

  Descriptive flex fields that the work order group references.

{
    "type":"object",
    "properties":{
        "CreatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"Indicates the user who created the work order group.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "CreationDate":{
            "type":"string",
            "description":"Indicates the date and time when the work order group was created.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "GroupCode":{
            "title":"Group Code",
            "maxLength":30,
            "type":"string",
            "description":"Represents the user key for the work order group entity.",
            "nullable":false,
            "x-queryable":true
        },
        "GroupDescription":{
            "title":"Group Description",
            "maxLength":240,
            "type":"string",
            "description":"Description of the work order group.",
            "nullable":true,
            "x-queryable":true
        },
        "GroupName":{
            "maxLength":120,
            "type":"string",
            "description":"Name of the work order group.",
            "nullable":false,
            "x-queryable":true
        },
        "GroupSource":{
            "title":"Group Source",
            "maxLength":30,
            "type":"string",
            "description":"Indicates the source of the group definition, allowing for separate groups to be defined for different products, such as Manufacturing or Maintenance. Valid values can be found in the lookup with the lookup type = ORA_WIE_SOURCE.",
            "nullable":false,
            "default":"ORA_MANUFACTURING",
            "x-queryable":true
        },
        "InactiveDate":{
            "type":"string",
            "description":"Date when the work order group becomes inactive.",
            "format":"date",
            "nullable":true,
            "x-queryable":true
        },
        "LastUpdateDate":{
            "type":"string",
            "description":"Indicates the date and time of the most recent update to the work order group.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "LastUpdateLogin":{
            "maxLength":32,
            "type":"string",
            "description":"Indicates the session login of the user who last updated the work order group.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "LastUpdatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"Indicates the user who made the most recent update to the work order group.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "ObjectVersionNumber":{
            "type":"integer",
            "description":"This number is used to implement optimistic locking, and it increments each time the row is updated. It's compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.",
            "format":"int32",
            "nullable":false,
            "x-hints":{
                "precision":9
            },
            "x-queryable":true
        },
        "OrganizationCode":{
            "maxLength":18,
            "type":"string",
            "description":"Abbreviation that identifies the inventory organization that's enabled for manufacturing.",
            "nullable":true,
            "x-hints":{
                "controlType":"choice"
            },
            "x-queryable":true
        },
        "OrganizationId":{
            "title":"Organization",
            "type":"integer",
            "description":"Organization identifier that represents the plant to which this work order group belongs.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18,
                "dependencies":[
                    "OrganizationCode"
                ]
            },
            "x-queryable":true
        },
        "OrganizationIdOrg":{
            "type":"integer",
            "description":"Organization identifier that represents the plant to which this work order group is assigned.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "precision":18
            },
            "x-queryable":true
        },
        "OrganizationName":{
            "title":"Organization",
            "maxLength":240,
            "type":"string",
            "description":"Name of the inventory organization that's enabled for manufacturing.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "Status":{
            "maxLength":255,
            "type":"string",
            "description":"Represents the status of the work order group.",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "dependencies":[
                    "InactiveDate"
                ]
            },
            "x-queryable":true
        },
        "WoGroupId":{
            "type":"integer",
            "description":"Unique identifier for a work order group record, generated automatically by the application.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18,
                "fnd:GLOBALLY_UNIQUE":"true"
            },
            "x-queryable":true
        },
        "WorkOrderGroupDFF":{
            "title":"Flexfields for Work Order Group",
            "type":"array",
            "description":"Descriptive flex fields that the work order group references.",
            "items":{
                "$ref":"#/components/schemas/workOrderGroups-WorkOrderGroupDFF-item-response"
            },
            "x-cardinality":"1"
        },
        "WorkOrderGroupDetail":{
            "title":"Work Order Group Detail",
            "type":"array",
            "description":"The details of the group name and the work orders associated with it.",
            "items":{
                "$ref":"#/components/schemas/workOrderGroups-WorkOrderGroupDetail-item-response"
            }
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        }
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : Work Order Group Detail

Type: array

Title: Work Order Group Detail

The details of the group name and the work orders associated with it.

Show Source

• Array of: object workOrderGroups-WorkOrderGroupDetail-item-response

{
    "title":"Work Order Group Detail",
    "type":"array",
    "description":"The details of the group name and the work orders associated with it.",
    "items":{
        "$ref":"#/components/schemas/workOrderGroups-WorkOrderGroupDetail-item-response"
    }
}

Nested Schema : Flexfields for Work Order Group

Type: array

Title: Flexfields for Work Order Group

Descriptive flex fields that the work order group references.

Show Source

• Array of: object workOrderGroups-WorkOrderGroupDFF-item-response

{
    "title":"Flexfields for Work Order Group",
    "type":"array",
    "description":"Descriptive flex fields that the work order group references.",
    "items":{
        "$ref":"#/components/schemas/workOrderGroups-WorkOrderGroupDFF-item-response"
    },
    "x-cardinality":"1"
}

Nested Schema : link

Type: object

Show Source

• href: string
  Title: hyperlink reference

  The URI to the related resource.
• kind: string
  Title: kind

  Allowed Values: [ "collection", "item", "describe", "other" ]

  The kind of the related resource.
• name: string
  Title: name

  The name of the link to the related resource.
• properties: object properties
• rel: string
  Title: relation

  Allowed Values: [ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]

  The name of the relation to the resource instance. Example: self.

{
    "type":"object",
    "properties":{
        "kind":{
            "title":"kind",
            "type":"string",
            "description":"The kind of the related resource.",
            "enum":[
                "collection",
                "item",
                "describe",
                "other"
            ]
        },
        "rel":{
            "title":"relation",
            "type":"string",
            "description":"The name of the relation to the resource instance.  Example: self.",
            "enum":[
                "self",
                "lov",
                "parent",
                "canonical",
                "child",
                "enclosure",
                "action",
                "custom"
            ]
        },
        "name":{
            "title":"name",
            "type":"string",
            "description":"The name of the link to the related resource."
        },
        "href":{
            "title":"hyperlink reference",
            "type":"string",
            "description":"The URI to the related resource."
        },
        "properties":{
            "type":"object",
            "properties":{
                "changeIndicator":{
                    "type":"string",
                    "description":"Change indicator or the ETag value of the resource instance."
                }
            }
        }
    }
}

Nested Schema : properties

Type: object

Show Source

• changeIndicator: string
  Change indicator or the ETag value of the resource instance.

{
    "type":"object",
    "properties":{
        "changeIndicator":{
            "type":"string",
            "description":"Change indicator or the ETag value of the resource instance."
        }
    }
}

Nested Schema : workOrderGroups-WorkOrderGroupDetail-item-response

Type: object

Show Source

• AssetDescription: string
  Read Only: true

  Maximum Length: 255

  Asset Description of the asset associated with the maintenance work order.
• AssetNumber: string
  Read Only: true

  Maximum Length: 255

  Asset Number of the asset associated with the maintenance work order.
• CreatedBy: string
  Read Only: true

  Maximum Length: 64

  Indicates the details of the user who created the work order group.
• CreationDate: string (date-time)
  Read Only: true

  Indicates the date and time when the work order group details were created.
• InventoryItemId: integer (int64)
  Title: Item

  Read Only: true

  Value that uniquely identifies the item, product, or assembly in the inventory organization.
• InventoryItemIdItemPEO: integer (int64)
  Title: Item Number

  Read Only: true

  Value that uniquely identifies the item, product, or assembly in the inventory organization.
• ItemNumber: string
  Title: Item

  Read Only: true

  Maximum Length: 300

  Number that identifies the item, which is an output of the work order.
• LastUpdateDate: string (date-time)
  Read Only: true

  Indicates the date and time of the most recent update to the work order group details.
• LastUpdatedBy: string
  Read Only: true

  Maximum Length: 64

  Indicates the user who made the most recent update to the work order group details.
• LastUpdateLogin: string
  Read Only: true

  Maximum Length: 32

  Indicates the session login of the user who last updated the work order group details.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• ObjectVersionNumber: integer (int32)
  Used to implement optimistic locking, this number increments each time the row is updated. It is then compared at the start and end of a transaction to detect if another session has updated the row since it was queried.
• ObjectVersionNumberStatusPEO: integer (int32)
  Read Only: true

  Number that identifies the object version that the work order status references.
• ObjectVersionNumberUnitOfMeasurePEO: integer (int32)
  Read Only: true

  Number that identifies the object version that the unit of measure references.
• ObjectVersionNumberWEO: integer (int32)
  Read Only: true

  Number that identifies the object version that the work order references.
• OrganizationId: integer (int64)
  Read Only: true

  The organization identifier representing the plant to which this work order group belongs.
• OrganizationIdItemPEO: integer (int64)
  Title: Organization

  Read Only: true

  Organization identifier that represents the plant to which this work order group belongs.
• PlannedCompletionDate: string (date-time)
  Title: Completion Date

  Read Only: true

  Planned date and time to finish the operation. The scheduling application sets this date. The planned completion date must not occur before the start date of the work order or after the finish date of the work order. This attribute is required.
• PlannedStartDate: string (date-time)
  Title: Start Date

  Read Only: true

  Planned date and time to start the operation. The scheduling application sets this date. The planned start date must not occur before the start date of the work order or after the finish date of the work order. This attribute is required.
• PlannedStartQuantity: number
  Title: Quantity

  Read Only: true

  Planned production quantity for the work order.
• UnitOfMeasure: string
  Title: UOM Name

  Read Only: true

  Maximum Length: 25

  Unit of measure for the component quantity.
• UOMCode: string
  Title: UOM

  Read Only: true

  Maximum Length: 3

  Abbreviation that identifies the unit of measure that the material requirement uses.
• UOMCodeUnitofMeasurePEO: string
  Title: UOM Code

  Read Only: true

  Maximum Length: 3

  Abbreviation that identifies the unit of measure that the material requirement uses.
• WoGroupDetailId: integer (int64)
  The unique identifier of a work order group detail record, generated automatically by the application.
• WoGroupId: integer (int64)
  Represents the work order group identifier, which is the foreign key to the WIE_WORK_ORDER_GROUPS_B table.
• WorkMethodCode: string
  Read Only: true

  Maximum Length: 30

  Abbreviation that identifies the unit of measure that the material requirement uses.
• WorkMethodId: integer (int64)
  Title: Work Method

  Read Only: true

  Represents the Work Method Identifier
• WorkOrderDescription: string
  Title: Description

  Read Only: true

  Maximum Length: 240

  Description of the work order.
• WorkOrderId: integer (int64)
  Represents the internal identifier of the work order, which is the foreign key to the WIE_WORK_ORDERS_B table.
• WorkOrderIdWEO: integer (int64)
  Read Only: true

  Value that uniquely identifies the work order. It is a primary key that the application generates when it creates the work order. This attribute is associated with a feature that requires opt in.
• WorkOrderNumber: string
  Title: Work Order

  Maximum Length: 120

  Number that identifies the work order. This number is unique in the manufacturing organization. The user can manually assign the number when the user creates the work order, or can allow the application to create a unique number from the numbering scheme defined by these plant parameters: Work Order Prefix or Work Order Starting Number.
• WorkOrderPriority: number
  Title: Priority

  Read Only: true

  Priority to use when determining when to run the work order in relation to other work orders.
• WorkOrderStatusId: integer (int64)
  Title: Status

  Read Only: true

  Value that uniquely identifies the work order status. A list of all the valid work order statuses can be retrieved using the workOrderStatuses resource.
• WorkOrderSubType: string
  Title: Subtype

  Read Only: true

  Maximum Length: 30

  Description of the work being performed. Values include Standard Production, Prototyping, or Repair.
• WorkOrderType: string
  Title: Type

  Read Only: true

  Maximum Length: 30

  Type of work order that the user selected when creating the work order.
• WorkOrderTypeMeaning: string
  Title: Work Order Type

  Read Only: true

  Maximum Length: 255

  Type of work order selected by the user during its creation.
• WoStatusCode: string
  Title: Status Code

  Read Only: true

  Maximum Length: 30

  Abbreviation that identifies the work order status.
• WoStatusId: integer (int64)
  Read Only: true

  Value that uniquely identifies the work order status. A list of all the valid work order statuses can be retrieved using the workOrderStatuses resource.
• WoStatusName: string
  Title: Work Order Status

  Read Only: true

  Maximum Length: 120

  Name of the work order status.
• WoSystemStatusCode: string
  Title: System Status Code

  Read Only: true

  Maximum Length: 30

  Abbreviation that identifies the system status mapped to the work order status by the application.

{
    "type":"object",
    "properties":{
        "AssetDescription":{
            "maxLength":255,
            "type":"string",
            "description":"Asset Description of the asset associated with the maintenance work order.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "AssetNumber":{
            "maxLength":255,
            "type":"string",
            "description":"Asset Number of the asset associated with the maintenance work order.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "CreatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"Indicates the details of the user who created the work order group.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "CreationDate":{
            "type":"string",
            "description":"Indicates the date and time when the work order group details were created.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "InventoryItemId":{
            "title":"Item",
            "type":"integer",
            "description":"Value that uniquely identifies the item, product, or assembly in the inventory organization.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "InventoryItemIdItemPEO":{
            "title":"Item Number",
            "type":"integer",
            "description":"Value that uniquely identifies the item, product, or assembly in the inventory organization.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "precision":18
            },
            "x-queryable":true
        },
        "ItemNumber":{
            "title":"Item",
            "maxLength":300,
            "type":"string",
            "description":"Number that identifies the item, which is an output of the work order.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "LastUpdateDate":{
            "type":"string",
            "description":"Indicates the date and time of the most recent update to the work order group details.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "LastUpdateLogin":{
            "maxLength":32,
            "type":"string",
            "description":"Indicates the session login of the user who last updated the work order group details.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "LastUpdatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"Indicates the user who made the most recent update to the work order group details.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "ObjectVersionNumber":{
            "type":"integer",
            "description":"Used to implement optimistic locking, this number increments each time the row is updated. It is then compared at the start and end of a transaction to detect if another session has updated the row since it was queried.",
            "format":"int32",
            "nullable":false,
            "x-hints":{
                "precision":9
            },
            "x-queryable":true
        },
        "ObjectVersionNumberStatusPEO":{
            "type":"integer",
            "description":"Number that identifies the object version that the work order status references.",
            "format":"int32",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "precision":9
            },
            "x-queryable":true
        },
        "ObjectVersionNumberUnitOfMeasurePEO":{
            "type":"integer",
            "description":"Number that identifies the object version that the unit of measure references.",
            "format":"int32",
            "nullable":false,
            "readOnly":true,
            "x-queryable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "precision":9
            }
        },
        "ObjectVersionNumberWEO":{
            "type":"integer",
            "description":"Number that identifies the object version that the work order references.",
            "format":"int32",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "precision":9
            },
            "x-queryable":true
        },
        "OrganizationId":{
            "type":"integer",
            "description":"The organization identifier representing the plant to which this work order group belongs.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "OrganizationIdItemPEO":{
            "title":"Organization",
            "type":"integer",
            "description":"Organization identifier that represents the plant to which this work order group belongs.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "precision":18
            },
            "x-queryable":true
        },
        "PlannedCompletionDate":{
            "title":"Completion Date",
            "type":"string",
            "description":"Planned date and time to finish the operation. The scheduling application sets this date. The planned completion date must not occur before the start date of the work order or after the finish date of the work order. This attribute is required.",
            "format":"date-time",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "PlannedStartDate":{
            "title":"Start Date",
            "type":"string",
            "description":"Planned date and time to start the operation. The scheduling application sets this date. The planned start date must not occur before the start date of the work order or after the finish date of the work order. This attribute is required.",
            "format":"date-time",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "PlannedStartQuantity":{
            "title":"Quantity",
            "type":"number",
            "description":"Planned production quantity for the work order.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "UOMCode":{
            "title":"UOM",
            "maxLength":3,
            "type":"string",
            "description":"Abbreviation that identifies the unit of measure that the material requirement uses.",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "UOMCodeUnitofMeasurePEO":{
            "title":"UOM Code",
            "maxLength":3,
            "type":"string",
            "description":"Abbreviation that identifies the unit of measure that the material requirement uses.",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "UnitOfMeasure":{
            "title":"UOM Name",
            "maxLength":25,
            "type":"string",
            "description":"Unit of measure for the component quantity.",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "controlType":"edit"
            },
            "x-queryable":true
        },
        "WoGroupDetailId":{
            "type":"integer",
            "description":"The unique identifier of a work order group detail record, generated automatically by the application.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18,
                "fnd:GLOBALLY_UNIQUE":"true"
            },
            "x-queryable":true
        },
        "WoGroupId":{
            "type":"integer",
            "description":"Represents the work order group identifier, which is the foreign key to the WIE_WORK_ORDER_GROUPS_B table.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "WoStatusCode":{
            "title":"Status Code",
            "maxLength":30,
            "type":"string",
            "description":"Abbreviation that identifies the work order status.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "WoStatusId":{
            "type":"integer",
            "description":"Value that uniquely identifies the work order status. A list of all the valid work order statuses can be retrieved using the workOrderStatuses resource.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "WoStatusName":{
            "title":"Work Order Status",
            "maxLength":120,
            "type":"string",
            "description":"Name of the work order status.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "WoSystemStatusCode":{
            "title":"System Status Code",
            "maxLength":30,
            "type":"string",
            "description":"Abbreviation that identifies the system status mapped to the work order status by the application.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "WorkMethodCode":{
            "maxLength":30,
            "type":"string",
            "description":"Abbreviation that identifies the unit of measure that the material requirement uses.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "WorkMethodId":{
            "title":"Work Method",
            "type":"integer",
            "description":"Represents the Work Method Identifier",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "help":{
                    "instruction":"Work Method"
                },
                "precision":18,
                "PAYLOADHINT":"Show"
            },
            "x-queryable":true
        },
        "WorkOrderDescription":{
            "title":"Description",
            "maxLength":240,
            "type":"string",
            "description":"Description of the work order.",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "help":{
                    "instruction":"Description"
                },
                "fnd:OA_TRANSLATABLE":"true"
            },
            "x-queryable":true
        },
        "WorkOrderId":{
            "type":"integer",
            "description":"Represents the internal identifier of the work order, which is the foreign key to the WIE_WORK_ORDERS_B table.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "WorkOrderIdWEO":{
            "type":"integer",
            "description":"Value that uniquely identifies the work order. It is a primary key that the application generates when it creates the work order. This attribute is associated with a feature that requires opt in.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "precision":18,
                "fnd:GLOBALLY_UNIQUE":"true"
            },
            "x-queryable":true
        },
        "WorkOrderNumber":{
            "title":"Work Order",
            "maxLength":120,
            "type":"string",
            "description":"Number that identifies the work order. This number is unique in the manufacturing organization. The user can manually assign the number when the user creates the work order, or can allow the application to create a unique number from the numbering scheme defined by these plant parameters: Work Order Prefix or Work Order Starting Number.",
            "nullable":true,
            "x-hints":{
                "controlType":"choice"
            },
            "x-queryable":true
        },
        "WorkOrderPriority":{
            "title":"Priority",
            "type":"number",
            "description":"Priority to use when determining when to run the work order in relation to other work orders.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "WorkOrderStatusId":{
            "title":"Status",
            "type":"integer",
            "description":"Value that uniquely identifies the work order status. A list of all the valid work order statuses can be retrieved using the workOrderStatuses resource.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "help":{
                    "instruction":"Status"
                },
                "precision":18
            },
            "x-queryable":true
        },
        "WorkOrderSubType":{
            "title":"Subtype",
            "maxLength":30,
            "type":"string",
            "description":"Description of the work being performed. Values include Standard Production, Prototyping, or Repair.",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "help":{
                    "instruction":"Subtype"
                }
            },
            "x-queryable":true
        },
        "WorkOrderType":{
            "title":"Type",
            "maxLength":30,
            "type":"string",
            "description":"Type of work order that the user selected when creating the work order.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "WorkOrderTypeMeaning":{
            "title":"Work Order Type",
            "maxLength":255,
            "type":"string",
            "description":"Type of work order selected by the user during its creation.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        }
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : workOrderGroups-WorkOrderGroupDFF-item-response

Type: object

Show Source

• __FLEX_Context: string
  Title: Context Segment

  Maximum Length: 80

  Descriptive flexfield context name for work order groups.
• __FLEX_Context_DisplayValue: string
  Title: Context Segment

  Display value of the descriptive flexfield context for work order groups.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• WoGroupId: integer (int64)
  Unique identifier for a work order group record, automatically generated by the application.

{
    "type":"object",
    "properties":{
        "WoGroupId":{
            "type":"integer",
            "description":"Unique identifier for a work order group record, automatically generated by the application.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true,
                "precision":18,
                "fnd:GLOBALLY_UNIQUE":"true"
            },
            "x-queryable":true
        },
        "__FLEX_Context":{
            "title":"Context Segment",
            "maxLength":80,
            "type":"string",
            "description":"Descriptive flexfield context name for work order groups.",
            "nullable":true,
            "x-hints":{
                "help":{
                    "instruction":"Context Segment"
                },
                "FND_ACFF_ValueSetInfo":"_FLEX_ContextValueSet_Internal#INDEPENDENT",
                "controlType":"choice",
                "FND_ACFF_AkaAttrName":"__FLEX_Context_DisplayValue",
                "includeInCompactView":true,
                "FND_ACFF_IsDiscriminator":"true",
                "FND_ACFF_JavaType":"java.lang.String",
                "FND_ACFF_MaximumLength":"1024",
                "FND_ACFF_PreferredDisplayType":"LOV"
            },
            "x-oj":{
                "transform":{
                    "path":"oj-sp/common-util/flex-util",
                    "name":"transformFlexUIHints"
                }
            },
            "x-queryable":true
        },
        "__FLEX_Context_DisplayValue":{
            "title":"Context Segment",
            "type":"string",
            "description":"Display value of the descriptive flexfield context for work order groups.",
            "nullable":true,
            "x-hints":{
                "updateable":"false",
                "help":{
                    "instruction":"Context Segment"
                },
                "DISPLAYHINT":"Hide",
                "FND_ACFF_IsReadOnly":"true",
                "FND_ACFF_AkaRealSegmentAttrName":"__FLEX_Context",
                "FND_ACFF_JavaType":"java.lang.String",
                "FND_ACFF_ListDisplayAttrName":"Name",
                "FND_ACFF_MaximumLength":"1024",
                "FND_ACFF_PreferredDisplayType":"LOV"
            },
            "x-oj":{
                "transform":{
                    "path":"oj-sp/common-util/flex-util",
                    "name":"transformFlexUIHints"
                }
            },
            "x-queryable":true
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        }
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Back to Top