1. REST API for Oracle Fusion Cloud SCMREST API for Oracle Fusion Cloud SCM
  2. Use Cases
  3. Manufacturing
  4. Create, Update, and Query Production Exceptions

Create, Update, and Query Production Exceptions

You can use REST API to create and update manufacturing production exceptions to report problems that occur on the shop floor that might cause an exception for a work order.

Let's discuss these scenarios briefly.

  • Create a manufacturing production exception.

  • Update description and other attributes of the production exception.

  • Get the list of manufacturing production exceptions.

The Quality Issues Rest API is used to do the following:

  • Create a manufacturing production exception.
  • Update a manufacturing production exception.

Create a New Production Exception

In this scenario, you create a quality issue for manufacturing production exception.

The quality issue types for manufacturing source are shown in the table. The quality issue type code determines the exception type of the production exception logged.

Manufacturing Quality Issue Source Manufacturing Quality Issue Type Code
ORA_MANUFACTURING ORA_ENQ_COMPONENT
ORA_MANUFACTURING ORA_ENQ_RESOURCE
ORA_MANUFACTURING ORA_ENQ_WORK_CENTER
ORA_MANUFACTURING ORA_ENQ_WORK_AREA
ORA_MANUFACTURING ORA_ENQ_MISCELLANEOUS

The quality issue severity can be of these types:

Manufacturing Quality Issue Source Manufacturing Quality Issue Type Code
ORA_LOW Low Severity
ORA_MEDIUM Medium Severity
ORA_HIGH High Severity
ORA_CRITICAL Critical Severity

The Affected Objects resource identifies these aspects:

  • The entity in manufacturing on which the production exception is being logged.
  • One or more impacted work order operations.

The Affected Objects Definition includes:

  • Supported Entity Code: This identifies the type of object that caused a quality issue or that the quality issue affects. The supported entity code should correlate with quality issue type code when it identifies the exception type being logged.
  • Context ID: This value uniquely identifies the context of the object represented by Supported Entity.

The Context ID values for Supported Entity Code can be as follows:

Supported Entity Code Context ID
ORA_WORK_OPERATION Value of work order operation ID
ORA_RESOURCE Value of the resource ID
ORA_COMPONENT Value of the item ID
ORA_WORK_AREA Value of the Work Area ID
ORA_WORK_CENTER Value of Work Center ID

Example URL

Use this resource URL format:

POST

curl -u username:password -X POST -H "Content-Type:application/vnd.oracle.adf.resourceitem+json" -d 'request payload' "https://servername/fscmRestApi/resources/version/qualityIssues"

Example Request

Here's an example of the request body in JSON format:
{
"Name" : "Machine Downtime Issue",
"Source" : "ORA_MANUFACTURING",
"QualityTypeCode" : "ORA_ENQ_RESOURCE",
"Severity" : "ORA_HIGH",
"Downtime" : 10,
"OrganizationCode" : "M1",
"ReportedDate" : "2021-07-16T12:00:00",
"ReportedBy" : "MFG_QA",
"AffectedObjects" :
 [
{
"SupportedEntityCode" : "ORA_RESOURCE",
"ContextId" : 300100071643667
},
{
"SupportedEntityCode" : "ORA_WORK_OPERATION",
"ContextId" : 300100544413836
},
{
"SupportedEntityCode" : "ORA_WORK_OPERATION",
"ContextId" : 300100166209483
}
]
}

Example Response

Here's an example of the response body in JSON format.

{
  "IssueId" : 300100544455809,
  "IssueNumber" : "28",
  "Name" : "Machine Downtime Issue",
  "QualityTypeId" : 1220,
  "QualityTypeCode" : "ORA_ENQ_RESOURCE",
  "QualityTypeName" : "Manufacturing - Resource",
  "Severity" : "ORA_HIGH",
  "SeverityName" : "High",
  "Downtime" : 10,
  "Source" : "ORA_MANUFACTURING",
  "SourceName" : "Manufacturing",
  "OrganizationId" : 207,
  "OrganizationCode" : "M1",
  "OrganizationName" : "Seattle Manufacturing",
  "CustomerId" : null,
  "SupplierId" : null,
  "Disposition" : null,
  "DispositionName" : null,
  "DispositionComment" : null,
  "CreationDate" : "2021-08-25T10:03:58+00:00",
  "LastUpdateDate" : "2021-08-25T10:04:02.820+00:00",
  "ExpectedResolutionDate" : null,
  "WorkflowStatusId" : 101,
  "WorkflowStatusCode" : "ORA_ISSUE_EXCEP_OPEN",
  "WorkflowStatusName" : "Open",
  "WorkflowTemplateId" : 2008,
  "WorkflowTemplateCode" : null,
  "WorkflowTemplateName" : null,
  "CreatedBy" : "MFG_QA",
  "AssignedTo" : null,
  "ReportedDate" : "2021-07-16T12:00:00+00:00",
  "ReportedBy" : "MFG_QA",
  "LastUpdatedBy" : "MFG_QA",
  "AffectedObjects" : [ {
    "AffectedObjectId" : 300100544455848,
    "Description" : null,
    "ImpactType" : "ORA_PRIMARY",
    "ImpactTypeName" : "Primary",
    "ObjectId" : 300100544455809,
    "Status" : "ORA_OPEN",
    "StatusName" : "Open",
    "SupportedEntityId" : 1003,
    "SupportedEntityCode" : "ORA_RESOURCE",
    "SupportedEntityName" : "LABOR",
    "ContextId" : 300100071643667,
    "ContextCode" : "MFGPACKINGLABOUR-Costed",
    "SubContextId" : null,
    "SubContextCode" : "M1",
    "SubContextTwoId" : null,
    "SubContextTwoCode" : null,
    "SubContextThreeId" : null,
    "SubContextFourId" : null,
    "SubContextFiveId" : null,
    "SubContextSixId" : null,
    "CreatedBy" : "MFG_QA",
    "CreationDate" : "2021-08-25T10:04:02.249+00:00",
    "LastUpdateDate" : "2021-08-25T10:04:02.759+00:00",
    "LastUpdatedBy" : "MFG_QA",
    "links" : [ {
      "rel" : "self",
      "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809/child/AffectedObjects/300100544455848",
      "name" : "AffectedObjects",
      "kind" : "item",
      "properties" : {
        "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
      }
    }, {
      "rel" : "canonical",
      "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809/child/AffectedObjects/300100544455848",
      "name" : "AffectedObjects",
      "kind" : "item"
    }, {
      "rel" : "parent",
      "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809",
      "name" : "qualityIssues",
      "kind" : "item"
    } ]
  }, {
    "AffectedObjectId" : 300100544455849,
    "Description" : null,
    "ImpactType" : "ORA_PRIMARY",
    "ImpactTypeName" : "Primary",
    "ObjectId" : 300100544455809,
    "Status" : "ORA_OPEN",
    "StatusName" : "Open",
    "SupportedEntityId" : 1002,
    "SupportedEntityCode" : "ORA_WORK_OPERATION",
    "SupportedEntityName" : "IN_HOUSE",
    "ContextId" : 300100544413836,
    "ContextCode" : "NV25AUG - 10",
    "SubContextId" : null,
    "SubContextCode" : null,
    "SubContextTwoId" : null,
    "SubContextTwoCode" : null,
    "SubContextThreeId" : null,
    "SubContextFourId" : null,
    "SubContextFiveId" : null,
    "SubContextSixId" : null,
    "CreatedBy" : "MFG_QA",
    "CreationDate" : "2021-08-25T10:04:02.630+00:00",
    "LastUpdateDate" : "2021-08-25T10:04:02.761+00:00",
    "LastUpdatedBy" : "MFG_QA",
    "links" : [ {
      "rel" : "self",
      "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809/child/AffectedObjects/300100544455849",
      "name" : "AffectedObjects",
      "kind" : "item",
      "properties" : {
        "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
      }
    }, {
      "rel" : "canonical",
      "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809/child/AffectedObjects/300100544455849",
      "name" : "AffectedObjects",
      "kind" : "item"
    }, {
      "rel" : "parent",
      "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809",
      "name" : "qualityIssues",
      "kind" : "item"
    } ]
  }, {
    "AffectedObjectId" : 300100544455850,
    "Description" : null,
    "ImpactType" : "ORA_PRIMARY",
    "ImpactTypeName" : "Primary",
    "ObjectId" : 300100544455809,
    "Status" : "ORA_OPEN",
    "StatusName" : "Open",
    "SupportedEntityId" : 1002,
    "SupportedEntityCode" : "ORA_WORK_OPERATION",
    "SupportedEntityName" : "IN_HOUSE",
    "ContextId" : 300100166209483,
    "ContextCode" : "M1-1143 - 50",
    "SubContextId" : null,
    "SubContextCode" : null,
    "SubContextTwoId" : null,
    "SubContextTwoCode" : null,
    "SubContextThreeId" : null,
    "SubContextFourId" : null,
    "SubContextFiveId" : null,
    "SubContextSixId" : null,
    "CreatedBy" : "MFG_QA",
    "CreationDate" : "2021-08-25T10:04:02.668+00:00",
    "LastUpdateDate" : "2021-08-25T10:04:02.763+00:00",
    "LastUpdatedBy" : "MFG_QA",
    "links" : [ {
      "rel" : "self",
      "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809/child/AffectedObjects/300100544455850",
      "name" : "AffectedObjects",
      "kind" : "item",
      "properties" : {
        "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
      }
    }, {
      "rel" : "canonical",
      "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809/child/AffectedObjects/300100544455850",
      "name" : "AffectedObjects",
      "kind" : "item"
    }, {
      "rel" : "parent",
      "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809",
      "name" : "qualityIssues",
      "kind" : "item"
    } ]
  } ],
  "links" : [ {
    "rel" : "self",
    "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809",
    "name" : "qualityIssues",
    "kind" : "item",
    "properties" : {
      "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
    }
  }, {
    "rel" : "canonical",
    "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809",
    "name" : "qualityIssues",
    "kind" : "item"
  }, {
    "rel" : "child",
    "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809/child/AffectedObjects",
    "name" : "AffectedObjects",
    "kind" : "collection"
  }, {
    "rel" : "child",
    "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809/child/Attachments",
    "name" : "Attachments",
    "kind" : "collection"
  }, {
    "rel" : "child",
    "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809/child/Relationships",
    "name" : "Relationships",
    "kind" : "collection"
  }, {
    "rel" : "child",
    "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809/child/Security",
    "name" : "Security",
    "kind" : "collection"
  }, {
    "rel" : "child",
    "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809/child/WorkflowApprovers",
    "name" : "WorkflowApprovers",
    "kind" : "collection"
  }, {
    "rel" : "enclosure",
    "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809/enclosure/Description",
    "name" : "Description",
    "kind" : "other"
  } ]
}

Update the Production Exception Description

Production Exception Description can be provided during update of quality issue. It cannot be provided when quality issued is created.

Example URL

Use this resource URL format.

PATCH

curl -u username:password -X PATCH -H "Content-Type:application/vnd.oracle.adf.resourceitem+json" -d 'request payload' "https://servername/fscmRestApi/resources/version/qualityIssues/{IssueId}/enclosure/Description"

Example Request

Request payload

Manufacturing Production Exception for M1 Organization

Example Response

None

Update Production Exception

In this scenario, you update a manufacturing production exception

Example URL

Use this resource URL format.

PATCH
curl -u username:password -X PATCH -H "Content-Type:application/vnd.oracle.adf.resourceitem+json" -d 'request payload' "https://servername/fscmRestApi/resources/version/qualityIssues/IssueId"

Example Request

Here's an example of the request body in JSON format:

{
  "Severity" : " ORA_CRITICAL"
}

Example Response

Here's an example of the response body in JSON format:

{
  "IssueId" : 300100544455809,
  "IssueNumber" : "28",
  "Name" : "Machine Downtime Issue",
  "QualityTypeId" : 1220,
  "QualityTypeCode" : "ORA_ENQ_RESOURCE",
  "QualityTypeName" : "Manufacturing - Resource",
  "Severity" : "ORA_CRITICAL",
  "SeverityName" : "Critical",
  "Downtime" : 10,
  "Source" : "ORA_MANUFACTURING",
  "SourceName" : "Manufacturing",
  "OrganizationId" : 207,
  "OrganizationCode" : "M1",
  "OrganizationName" : "Seattle Manufacturing",
  "CustomerId" : null,
  "SupplierId" : null,
  "Disposition" : null,
  "DispositionName" : null,
  "DispositionComment" : null,
  "CreationDate" : "2021-08-25T10:03:58+00:00",
  "LastUpdateDate" : "2021-08-25T10:11:11+00:00",
  "ExpectedResolutionDate" : null,
  "WorkflowStatusId" : 101,
  "WorkflowStatusCode" : "ORA_ISSUE_EXCEP_OPEN",
  "WorkflowStatusName" : "Open",
  "WorkflowTemplateId" : 2008,
  "WorkflowTemplateCode" : null,
  "WorkflowTemplateName" : null,
  "CreatedBy" : "MFG_QA",
  "AssignedTo" : null,
  "ReportedDate" : "2021-07-16T12:00:00+00:00",
  "ReportedBy" : "MFG_QA",
  "LastUpdatedBy" : "MFG_QA",
  "links" : [ {
    "rel" : "self",
    "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809",
    "name" : "qualityIssues",
    "kind" : "item",
    "properties" : {
      "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000278"
    }
  }, {
    "rel" : "canonical",
    "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809",
    "name" : "qualityIssues",
    "kind" : "item"
  }, {
    "rel" : "child",
    "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809/child/AffectedObjects",
    "name" : "AffectedObjects",
    "kind" : "collection"
  }, {
    "rel" : "child",
    "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809/child/Attachments",
    "name" : "Attachments",
    "kind" : "collection"
  }, {
    "rel" : "child",
    "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809/child/Relationships",
    "name" : "Relationships",
    "kind" : "collection"
  }, {
    "rel" : "child",
    "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809/child/Security",
    "name" : "Security",
    "kind" : "collection"
  }, {
    "rel" : "child",
    "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809/child/WorkflowApprovers",
    "name" : "WorkflowApprovers",
    "kind" : "collection"
  }, {
    "rel" : "enclosure",
    "href" : "https://servername/fscmRestApi/resources/version/qualityIssues/300100544455809/enclosure/Description",
    "name" : "Description",
    "kind" : "other"
  } ]
}

Get Manufacturing Production Exceptions

In this scenario, you retrieve the manufacturing production exceptions using the production exceptions rest resource.

Example URL

Use this resource URL format.

PATCH
curl -u username:password -X GET -H "Content-Type:application/vnd.oracle.adf.resourceitem+json" -d 'request payload' "https://servername/fscmRestApi/resources/version/productionExceptions"

Example Response

Here's an example of the response body in JSON format.

{
  "items" : [ {
    "ExceptionId" : 300100541652411,
    "ExceptionNumber" : "23",
    "ExceptionType" : "Component",
    "SeverityCode" : "ORA_HIGH",
    "SeverityOrder" : "2",
    "SeverityDescription" : "High",
    "ReportedBy" : "MFG_QA",
    "ReportedDate" : "2021-04-14T06:10:28+00:00",
    "ExpectedDowntimeInMinutes" : 0,
    "ExpectedResolutionDate" : null,
    "ExceptionDescription" : "Process Exception",
    "OrganizationId" : 300100168101959,
    "WorkflowStatusId" : 101,
    "WorkflowStatusCode" : "ORA_MFG_OPEN",
    "WorkflowStatusMeaning" : "Open",
    "SupportedEntityTypeId" : 1004,
    "ItemNumber" : "R2104_Fixed_Comp1",
    "InventoryItemId" : 300100541198471,
    "ItemDescription" : "R2104_Fixed_Comp1",
    "ResourceId" : null,
    "ResourceCode" : null,
    "ResourceName" : null,
    "ResourceType" : null,
    "ResourceInstanceId" : null,
    "ResourceInstanceCode" : null,
    "ResourceInstanceName" : null,
    "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,
    "links" : [ {
      "rel" : "self",
      "href" : "https://servername/fscmRestApi/resources/version/productionExceptions/300100541652411",
      "name" : "productionExceptions",
      "kind" : "item"
    }, {
      "rel" : "canonical",
      "href" : "https://servername/fscmRestApi/resources/version/productionExceptions/300100541652411",
      "name" : "productionExceptions",
      "kind" : "item"
    }, {
      "rel" : "child",
      "href" : "https://servername/fscmRestApi/resources/version/productionExceptions/300100541652411/child/ImpactedOperation",
      "name" : "ImpactedOperation",
      "kind" : "collection"
    } ]
  }, 
  {
    "ExceptionId" : 300100127997989,
    "ExceptionNumber" : "11",
    "ExceptionType" : "Component",
    "SeverityCode" : "ORA_LOW",
    "SeverityOrder" : "4",
    "SeverityDescription" : "Low",
    "ReportedBy" : "MFG_QA",
    "ReportedDate" : "2018-01-16T11:01:19+00:00",
    "ExpectedDowntimeInMinutes" : 0,
    "ExpectedResolutionDate" : null,
    "ExceptionDescription" : "MFG CDRM Component5 Production Exception for Closure from Mobile device.",
    "OrganizationId" : 300100112002363,
    "WorkflowStatusId" : 101,
    "WorkflowStatusCode" : "ORA_MFG_OPEN",
    "WorkflowStatusMeaning" : "Open",
    "SupportedEntityTypeId" : 1004,
    "ItemNumber" : "MFG-PL-COMP5",
    "InventoryItemId" : 300100089882385,
    "ItemDescription" : "Plain Component with Supply Type of Supplier",
    "ResourceId" : null,
    "ResourceCode" : null,
    "ResourceName" : null,
    "ResourceType" : null,
    "ResourceInstanceId" : null,
    "ResourceInstanceCode" : null,
    "ResourceInstanceName" : null,
    "WorkAreaId" : null,
    "WorkAreaCode" : null,
    "WorkAreaName" : null,
    "WorkAreaDescription" : null,
    "WorkCenterId" : null,
    "WorkCenterCode" : null,
    "WorkCenterName" : null,
    "WorkCenterDescription" : null,
    "OpenImpactedOperationCount" : 3,
    "WoExceptionStatus" : null,
    "ObjectVersionNumber" : 1,
    "WorkOrderId" : null,
    "WoOperationId" : null,
    "links" : [ {
      "rel" : "self",
      "href" : "https://servername/fscmRestApi/resources/version/productionExceptions/300100127997989",
      "name" : "productionExceptions",
      "kind" : "item"
    }, {
      "rel" : "canonical",
      "href" : "https://servername/fscmRestApi/resources/version/productionExceptions/300100127997989",
      "name" : "productionExceptions",
      "kind" : "item"
    }, {
      "rel" : "child",
      "href" : "https://servername/fscmRestApi/resources/version/productionExceptions/300100127997989/child/ImpactedOperation",
      "name" : "ImpactedOperation",
      "kind" : "collection"
    } ]
  }
  ]}