Get all exceptions

get

/fscmRestApi/resources/11.13.18.05/productionExceptions

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: Find production exceptions using the Id of the production exception as the primary key.
      Finder Variables:
      • ExceptionId; integer; Primary key that uniquely identifies the production exception. Manufacturing generates this primary key when it creates a production exception. This attribute is required.
    • findByOpId: Find production exceptions using the Id of the work order operation as the primary key.
      Finder Variables:
      • bindOpId; integer; Primary key that uniquely identifies the work order operation. Manufacturing generates this primary key when it creates a work order operation. This attribute is required.
    • findByProjectNumberTaskNumber: Find work order operations and dispatch statuses according to the project and task number. This finder is associated with a feature that requires opt in.
      Finder Variables:
      • ProjectNumber; string; Number that identifies the project associated with the work order. This attribute is associated with a feature that requires opt in.
      • TaskNumber; string; Number that identifies the task associated with the work order. This attribute is associated with a feature that requires opt in.
    • findByWoId: Find production exceptions using the Id of the work order as the primary key.
      Finder Variables:
      • bindWoId; integer; Primary key that uniquely identifies the work order. Manufacturing generates this primary key when it creates a work order. This attribute is required.
  • 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:
    • ExceptionDescription; string; Description of the exception.
    • ExceptionId; integer; Value that uniquely identifies the exception. It is a primary key that the application generates when it creates a exception.
    • ExceptionNumber; string; Number that identifies the exception.
    • ExceptionType; string; Value that indicates the type of the exception.
    • ExpectedDowntimeInMinutes; integer; Value of the expected downtime for the production activity as a result of the exception specified in minutes.
    • ExpectedResolutionDate; string; Date when the exception is expected to be resolved.
    • InventoryItemId; number; Value that uniquely identifies the item for an exception of type component. It is a primary key that the application generates when it creates an item.
    • ItemDescription; string; Description of the item for an exception of type component.
    • ItemNumber; string; Value that identifies the item for an exception of type component.
    • ObjectVersionNumber; integer; Object version number of the exception.
    • OpenImpactedOperationCount; number; Number of work order operations impacted by the exception.
    • OrganizationId; integer; Value that uniquely identifies the inventory organization. It is a primary key that the application generates when it creates an inventory organization.
    • ReportedBy; string; Name of the user who reported the exception.
    • ReportedDate; string; Date when the exception was reported.
    • ResourceCode; string; Value that identifies the resource for an exception of type resource.
    • ResourceId; number; Value that identifies the resource for an exception of type resource. It is a primary key that the application generates when it creates a resource.
    • ResourceInstanceCode; string; Abbreviation that identifies the resource instance.
    • ResourceInstanceId; number; Value that uniquely identifies the resource instance. It is a primary key that the application generates when it creates a resource instance.
    • ResourceInstanceName; string; Name of the resource instance.
    • ResourceName; string; Name of the resource for an exception of type resource.
    • ResourceType; string; Type of production resource. Values include Labor or Equipment.
    • SeverityCode; string; Abbreviation that identifies the severity of the exception.
    • SeverityDescription; string; Description of the severity of the exception.
    • SeverityOrder; string; Value that identifies the order of severity of the exception.
    • SupportedEntityTypeId; integer; Number that identifies the exception type. It is the primary key.
    • WoExceptionStatus; string; Status of the production exception.
    • WoOperationId; integer; Value that identifies the primary impacted work order operation of the exception. It is a primary key that the application generates when it creates a work order operation.
    • WorkAreaCode; string; Value that identifies the work area for an exception of type work area.
    • WorkAreaDescription; string; Description of the work area for an exception of type work area.
    • WorkAreaId; number; Value that identifies the work area for an exception of type work area. It is a primary key that the application generates when it creates a work area.
    • WorkAreaName; string; Name of the work area for an exception of type work area.
    • WorkCenterCode; string; Value that identifies the work center for an exception of type work center.
    • WorkCenterDescription; string; Description of the work center for an exception of type work center.
    • WorkCenterId; integer; Value that identifies the work center for an exception of type work center. It is a primary key that the application generates when it creates a work center.
    • WorkCenterName; string; Name of the work center for an exception of type work center.
    • WorkOrderId; integer; Value that identifies the primary impacted work order of the exception. It is a primary key that the application generates when it creates a work order.
    • WorkflowStatusCode; string; Abbreviation that identifies the status of the exception.
    • WorkflowStatusId; integer; Value that uniquely identifies the status of the exception.
    • WorkflowStatusMeaning; string; Meaning of the status of the exception.
  • 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 : productionExceptions
Type: object
Show Source
Nested Schema : Items
Type: array
Title: Items
The items in the collection.
Show Source
Nested Schema : productionExceptions-item-response
Type: object
Show Source
Nested Schema : Impacted Operations
Type: array
Title: Impacted Operations
The Impacted Operations resource manages the work order operations that an exception impacts.
Show Source
Nested Schema : productionExceptions-ImpactedOperation-item-response
Type: object
Show Source
  • Read Only: true
    Value that identifies the impacted work order operation of the exception. It is a primary key that the application generates when a work order operation is added as an impacted operation to the exception.
  • Read Only: true
    Maximum Length: 240
    Description of the work order item that is impacted.
  • Read Only: true
    Value that uniquely identifies the exception. It is a primary key that the application generates when it creates a exception.
  • Read Only: true
    Maximum Length: 300
    Value of the work order item that is impacted.
  • Links
  • Read Only: true
    Object version number of the work order operation that is impacted.
  • Read Only: true
    Maximum Length: 120
    Name of the impacted work order operation.
  • Read Only: true
    Date when the impacted work order operation is expected to finish.
  • Read Only: true
    Date when the impacted work order operation is expected to start.
  • Read Only: true
    Sequence number of the impacted operation in the work order.
  • Read Only: true
    Value that uniquely identifies the project associated with the work order. This attribute is associated with a feature that requires opt in.
  • Title: Project Number
    Read Only: true
    Maximum Length: 25
    Number that identifies the project associated with the work order. This attribute is associated with a feature that requires opt in.
  • Read Only: true
    Date when the application reported the impacted work order operation.
  • Read Only: true
    Maximum Length: 30
    Abbreviation of the work order operation that is impacted.
  • Read Only: true
    Maximum Length: 120
    Name of the work order operation that is impacted.
  • Read Only: true
    Maximum Length: 30
    Abbreviation that identifies the status of the operation of the impacted work order.
  • Read Only: true
    Maximum Length: 80
    Description of the status of the operation of the impacted work order.
  • Read Only: true
    Value that identifies the exception type. It is the primary key.
  • Read Only: true
    Value that uniquely identifies the task associated with the work order. This attribute is associated with a feature that requires opt in.
  • Title: Task Number
    Read Only: true
    Maximum Length: 100
    Number that identifies the task associated with the work order. This attribute is associated with a feature that requires opt in.
  • Read Only: true
    Value that identifies the work order operation that is impacted. It is a primary key that the application generates when it creates a work order operation.
  • Read Only: true
    Number that identifies the sequence for the work order operation. This value determines the sequence to use when displaying the operations in the user interface.
  • Read Only: true
    Value that uniquely identifies the impacted work order of the exception. It is a primary key that the application generates when it creates a work order.
  • Read Only: true
    Maximum Length: 120
    Value that identifies the impacted work order of the exception.
Back to Top

Examples

This example describes how to get all production exceptions.

Example cURL Command

Use the following cURL command to submit a request on the REST resource:

curl -u username:password "https://servername/manufacturingApi/resources/version/productionExceptions"

Example Response Body

The following example includes the contents of the response body in JSON format:

"{
  ""items"" : [ {
    ""ExceptionId"" : 300100098612251,
    ""ExceptionNumber"" : ""56"",
    ""ExceptionType"" : ""Resource"",
    ""SeverityCode"" : ""ORA_CRITICAL"",
    ""SeverityOrder"" : ""1"",
    ""SeverityDescription"" : ""Critical"",
    ""ReportedBy"" : null,
    ""ReportedDate"" : null,
    ""ExpectedDowntimeInMinutes"" : null,
    ""ExpectedResolutionDate"" : null,
    ""ExceptionDescription"" : null,
    ""OrganizationId"" : 207,
    ""WorkflowStatusId"" : 101,
    ""WorkflowStatusCode"" : ""ORA_MFG_OPEN"",
    ""WorkflowStatusMeaning"" : ""Open"",
    ""SupportedEntityTypeId"" : 1003,
    ""ItemNumber"" : null,
    ""InventoryItemId"" : null,
    ""ItemDescription"" : null,
    ""ResourceId"" : 300100075229783,
    ""ResourceCode"" : ""RC-TAB-ROBOT1"",
    ""ResourceName"" : ""RC-TAB-ROBOT1"",
    ""WorkAreaId"" : null,
    ""WorkAreaCode"" : null,
    ""WorkAreaName"" : null,
    ""WorkAreaDescription"" : null,
    ""WorkCenterId"" : null,
    ""WorkCenterCode"" : null,
    ""WorkCenterName"" : null,
    ""WorkCenterDescription"" : null,
    ""OpenImpactedOperationCount"" : 1,
    ""WoExceptionStatus"" : null,
    ""ObjectVersionNumber"" : 1,
    ""WorkOrderId"" : null,
    ""WoOperationId"" : null
  }, {
...
  } ],
...
}"

Example cURL Commands

Use the following cURL commands to meet example query requirements.

Requirement

cURL Command

Query all active locators where the material status allows the application to perform an inventory transaction at the locator level. For example, query all the active locators that allow a subinventory transfer.

curl -u <username:password> -H "Content-Type:application/vnd.oracle.adf.resourceitem+json" "https://servername/logisticsApi/resources/version/activeLocators?onlyData=true&finder=findRestrictedLocators;bindTransactionTypeId=2"

Query all active locators that an item restricts for an item across organizations that allows the application to perform an inventory transaction at the locator level. For example, query all the active locators that allow a subinventory transfer, restricted for item, and where the Inventory Item Id is 648.

curl -u username:password -H "Content-Type:application/vnd.oracle.adf.resourceitem+json" "https://servername/logisticsApi/resources/version/activeLocators?onlyData=true&finder=findRestrictedLocators;bindTransactionTypeId=2,bindItemId=648"

Query all active stock locators.

curl -u username:password -H "Content-Type:application/vnd.oracle.adf.resourceitem+json" "https://servername/logisticsApi/resources/version/activeLocators?onlyData=true"

Query for an active stock locator in all organizations when you know the locator, such as VC1.1.1.

curl -u username:password -H "Content-Type:application/vnd.oracle.adf.resourceitem+json" "https://servername/logisticsApi/resources/version/activeLocators?onlyData=true&q=Locator=VC1.1.1"

Query all active stock locators when you know the organization Id, such as 207.

curl -u username:password -H "Content-Type:application/vnd.oracle.adf.resourceitem+json" "https://servername/logisticsApi/resources/version/activeLocators?onlyData=true&q=OrganizationId=207"

Query all active locators that start with a string, such as SAN.

curl -u username:password -H "Content-Type:application/vnd.oracle.adf.resourceitem+json" "https://servernamelogisticsApi/resources/version/activeLocators?onlyData=true&q=Locator LIKE SAN%"

Query all active locators where the description contains a string, such as Storage.

curl -u username:password -H "Content-Type:application/vnd.oracle.adf.resourceitem+json" "https://servername/logisticsApi/resources/version/activeLocators?onlyData=true&q=Description LIKE %Storage%"

Query all locators that will be disabled on or after a date, such as 2015-12-31.

curl -u username:password -H "Content-Type:application/vnd.oracle.adf.resourceitem+json" "https://servername/logisticsApi/resources/version/activeLocators?onlyData=true&q=DisableDate>=2015-12-31"

Query all active locators in an organization, such as W1, and that contain a value for the picking order.

Back to Top