GET action not supported

get

/fscmRestApi/resources/11.13.18.05/maintenanceMaterialTransactions/{InterfaceBatchId}/child/MaterialTransactionDetail

Request

Path Parameters
Query Parameters
  • This parameter specifies dependencies which are fields that are set before and rolled back after generating the response. Generally they are used to preview the effects of an attribute change. The fields specified in this parameter are always set in the resource instance in question. When a child resource collection is requested and the parameter is set, the fields will be set in the parent resource instance before generating the resource collection payload. The value of this query parameter is a set of dependency fields. Example: dependency=ProductId=2

    Format: <attr1>=<val1>,<attr2>=<value2>
  • 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
      Finder Variables:
    • 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:
      • AssemblyAssetId; integer; Work order asset identifier for which, the material transactions are performed.
      • AssemblyAssetNumber; string; Work order asset number for which, the material transactions are performed.
      • AssemblySerialNumber; string; Serial number that identifies the assembly where fulfillment issues the components. However, this is not applicable for maintenance work orders.
      • CountryOfOriginCode; string; Abbreviation that identifies the country of origin associated with the item. If an inventory attribute exception exists for the item then this attribute isn???t applicable for the transaction.
      • ErrorMessageNames; string; Name of the error messages that occurred when processing the item transaction. Each text string in the ErrorMessages attribute corresponds to one error message name in the ErrorMessageNames attribute. A comma ( , ) separates each message name.
      • ErrorMessages; string; Text of the error message that occurred when processing the item transaction. Each text string in the ErrorMessages attribute corresponds to one error message name in the ErrorMessageNames attribute. A double dollar sign ($$) separates each message.
      • InvTransactionId; integer; Value that uniquely identifies the respective transaction in the inventory application. If the transaction is successful, the value will be a number, else the value will be 0. This attribute value is included in the response payload.
      • InventoryItemNumber; string; Number that uniquely identifies the item that is transacted against the maintenance work order.
      • ItemRevision; string; Revision of the item that is transacted.
      • Locator; string; Locator where fulfillment issues the item from or returns the item to. It is applicable when a locator controlled item is transacted.
      • OrganizationCode; string; Abbreviation that identifies the maintenance organization where the material transaction is performed. The user who performs the transaction should have access to the maintenance organization and the item transacted should be assigned to the maintenance organization.
      • ParentAssetId; integer; Value that uniquely identifies the parent asset. For a removal (negative material issue) transaction, this attribute indicates the identifier of the actual parent of the removed asset. For an install (material issue) transaction, this attribute indicates the identifier of the to-be parent asset. Use this attribute only when the material transaction is used for asset removal or install. If this value is not provided, then the work order asset is used as the parent asset.
      • ParentAssetNumber; string; Number that uniquely identifies the parent asset. For a removal (negative material issue) transaction, this attribute indicates the actual parent of the removed asset. For an install (material issue) transaction, this attribute indicates the to-be parent asset. Use this attribute only when the material transaction is used for asset removal or install. If this value is not provided, then the work order asset is used as the parent asset.
      • ParentInventoryItemId; integer; Value that uniquely identifies the item referenced in the parent asset. For a removal (negative material issue) transaction, this attribute indicates the identifier associated with the actual parent of the removed asset. For an install (material issue) transaction, this attribute indicates the value associated with the to-be parent asset. Use this attribute only when the material transaction is used for asset removal or install. If this value is not provided, then the work order asset is used as the parent asset.
      • ParentInventoryItemNumber; string; Number that uniquely identifies the item referenced in the parent asset. For a removal (negative material issue) transaction, this attribute indicates the item associated with the actual parent of the removed asset. For an install (material issue) transaction, this attribute indicates the value associated with the to-be parent asset. Use this attribute only when the material transaction is used for asset removal or install. If this value is not provided, then the work order asset is used as the parent asset.
      • ParentSerialNumber; string; Number that identifies the serial number of the parent asset. For a removal (negative material issue) transaction, this attribute indicates the serial number of the actual parent of the removed asset. For an install (material issue) transaction, this attribute indicates the serial number of the to-be parent asset. Use this attribute only when the material transaction is used for asset removal or install. If this value is not provided, then the work order asset is used as the parent asset.
      • ProjectNumber; string; Number that identifies the project. This attribute is associated with a feature that requires opt in.
      • RepairTransactionCode; string; Abbreviation that uniquely identifies the repair transaction from the condition event.
      • SecondaryTransactionQuantity; number; Secondary quantity of product that the asset references. If item is not defined as as dual unit of measure item or if conversion for the secondary unit of measure is set to fixed, this quantity is not required. If dual UOM conversion is set to default, this quantity will override the default quantity. If conversion is no default, this quantity is required. The default value of secondary unit of measure is from setup.
      • SecondaryUnitOfMeasure; string; Abbreviation that identifies the asset secondary quantity unit of measure. The secondary unit of measure is not required to create an asset. If provided it must be the same as the asset item secondary unit of measure. If not provided the value of the asset item secondary unit of measure is used by default.
      • SourceHeaderReference; string; Reference to the object header in the source application.
      • SourceHeaderReferenceId; integer; Value that uniquely identifies the object header in the source application.
      • SourceLineReference; string; Reference to the object line in the source application.
      • SourceLineReferenceId; integer; Value that uniquely identifies the object line in the source application.
      • SourceSystemCode; string; Abbreviation that identifies the source application that started this operation transaction. This code must be registered in Oracle Manufacturing Cloud. The application validates this value against the WIE_SOURCE_SYSTEMS_V database view.
      • SubinventoryCode; string; Abbreviation that identifies the subinventory from or to which the item transaction is done. For an issue transaction, the item from the subinventory will be issued. For a return transaction, the item will be transacted to the subinventory.
      • TaskNumber; string; Number that identifies the task. This attribute is associated with a feature that requires opt in.
      • TransactedAsset; integer; Abbreviation that identifies the transacted asset.
      • TransactionDate; string; Date and time when the transaction is performed. The valid date range is from the work order released date till the system date. Future date is not valid and the default value is the system date.
      • TransactionGroupCode; string; Abbreviation that identifies the transaction group.
      • TransactionQuantity; number; Quantity of the item transacted against the maintenance work order.
      • TransactionTypeCode; string; Abbreviation that describes the type of material transactions supported for a maintenance work order. Valid values for a maintenance work order are MATERIAL_RETURN, MATERIAL_ISSUE, MATERIAL_NEGATIVE_ISSUE, and MATERIAL_NEGATIVE_RETURN. A list of accepted values is defined in the lookup type ORA_WIE_MTL_TXN_TYPE.
      • TransactionUnitOfMeasure; string; Unit of measure to use during the item transaction. The primary unit of measure in the item definition should be used for the transaction.
      • UseCommonInventoryFlag; boolean; Contains one of the following values: Y or N. If Y, then true. If N, then false. This attribute does not have a default value. This attribute is applicable only for work order component issue or reverse. If populated with any value for a work order without a project and task, it will be ignored. If populated for product completions or reverse or orderless transactions, it will be ignored.
      • WoOperationSequenceNumber; number; Number that uniquely identifies the operation within the maintenance work orders. Material is transacted against operation in the maintenance work order.
      • WorkOrderNumber; string; Number that uniquely identifies the maintenance work order. The material transaction is performed against this maintenance work order.
    • 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 : maintenanceMaterialTransactions-MaterialTransactionDetail
    Type: object
    Show Source
    Nested Schema : Items
    Type: array
    Title: Items
    The items in the collection.
    Show Source
    Nested Schema : maintenanceMaterialTransactions-MaterialTransactionDetail-item-response
    Type: object
    Show Source
    • Work order asset identifier for which, the material transactions are performed.
    • Maximum Length: 80
      Work order asset number for which, the material transactions are performed.
    • Maximum Length: 80
      Serial number that identifies the assembly where fulfillment issues the components. However, this is not applicable for maintenance work orders.
    • Title: Country of Origin
      Maximum Length: 2
      Abbreviation that identifies the country of origin associated with the item. If an inventory attribute exception exists for the item then this attribute isn???t applicable for the transaction.
    • Read Only: true
      Maximum Length: 255
      Name of the error messages that occurred when processing the item transaction. Each text string in the ErrorMessages attribute corresponds to one error message name in the ErrorMessageNames attribute. A comma ( , ) separates each message name.
    • Read Only: true
      Maximum Length: 2000
      Text of the error message that occurred when processing the item transaction. Each text string in the ErrorMessages attribute corresponds to one error message name in the ErrorMessageNames attribute. A double dollar sign ($$) separates each message.
    • Title: Item
      Maximum Length: 300
      Number that uniquely identifies the item that is transacted against the maintenance work order.
    • Value that uniquely identifies the respective transaction in the inventory application. If the transaction is successful, the value will be a number, else the value will be 0. This attribute value is included in the response payload.
    • Title: Item Revision
      Maximum Length: 18
      Revision of the item that is transacted.
    • Links
    • Maximum Length: 800
      Locator where fulfillment issues the item from or returns the item to. It is applicable when a locator controlled item is transacted.
    • Title: Organization Code
      Maximum Length: 30
      Abbreviation that identifies the maintenance organization where the material transaction is performed. The user who performs the transaction should have access to the maintenance organization and the item transacted should be assigned to the maintenance organization.
    • Value that uniquely identifies the parent asset. For a removal (negative material issue) transaction, this attribute indicates the identifier of the actual parent of the removed asset. For an install (material issue) transaction, this attribute indicates the identifier of the to-be parent asset. Use this attribute only when the material transaction is used for asset removal or install. If this value is not provided, then the work order asset is used as the parent asset.
    • Maximum Length: 255
      Number that uniquely identifies the parent asset. For a removal (negative material issue) transaction, this attribute indicates the actual parent of the removed asset. For an install (material issue) transaction, this attribute indicates the to-be parent asset. Use this attribute only when the material transaction is used for asset removal or install. If this value is not provided, then the work order asset is used as the parent asset.
    • Value that uniquely identifies the item referenced in the parent asset. For a removal (negative material issue) transaction, this attribute indicates the identifier associated with the actual parent of the removed asset. For an install (material issue) transaction, this attribute indicates the value associated with the to-be parent asset. Use this attribute only when the material transaction is used for asset removal or install. If this value is not provided, then the work order asset is used as the parent asset.
    • Maximum Length: 255
      Number that uniquely identifies the item referenced in the parent asset. For a removal (negative material issue) transaction, this attribute indicates the item associated with the actual parent of the removed asset. For an install (material issue) transaction, this attribute indicates the value associated with the to-be parent asset. Use this attribute only when the material transaction is used for asset removal or install. If this value is not provided, then the work order asset is used as the parent asset.
    • Maximum Length: 80
      Number that identifies the serial number of the parent asset. For a removal (negative material issue) transaction, this attribute indicates the serial number of the actual parent of the removed asset. For an install (material issue) transaction, this attribute indicates the serial number of the to-be parent asset. Use this attribute only when the material transaction is used for asset removal or install. If this value is not provided, then the work order asset is used as the parent asset.
    • Title: Project Number
      Maximum Length: 25
      Number that identifies the project. This attribute is associated with a feature that requires opt in.
    • Maximum Length: 30
      Abbreviation that uniquely identifies the repair transaction from the condition event.
    • Title: Secondary Transaction Quantity
      Secondary quantity of product that the asset references. If item is not defined as as dual unit of measure item or if conversion for the secondary unit of measure is set to fixed, this quantity is not required. If dual UOM conversion is set to default, this quantity will override the default quantity. If conversion is no default, this quantity is required. The default value of secondary unit of measure is from setup.
    • Title: Secondary Unit of Measure
      Maximum Length: 25
      Abbreviation that identifies the asset secondary quantity unit of measure. The secondary unit of measure is not required to create an asset. If provided it must be the same as the asset item secondary unit of measure. If not provided the value of the asset item secondary unit of measure is used by default.
    • Title: Source Header Reference
      Maximum Length: 240
      Reference to the object header in the source application.
    • Title: Source Header Reference ID
      Value that uniquely identifies the object header in the source application.
    • Title: Source Line Reference
      Maximum Length: 240
      Reference to the object line in the source application.
    • Title: Source Line Reference ID
      Value that uniquely identifies the object line in the source application.
    • Title: Source System Code
      Maximum Length: 30
      Abbreviation that identifies the source application that started this operation transaction. This code must be registered in Oracle Manufacturing Cloud. The application validates this value against the WIE_SOURCE_SYSTEMS_V database view.
    • Title: Subinventory Code
      Maximum Length: 18
      Abbreviation that identifies the subinventory from or to which the item transaction is done. For an issue transaction, the item from the subinventory will be issued. For a return transaction, the item will be transacted to the subinventory.
    • Title: Task Number
      Maximum Length: 100
      Number that identifies the task. This attribute is associated with a feature that requires opt in.
    • Abbreviation that identifies the transacted asset.
    • Title: Transaction Date
      Date and time when the transaction is performed. The valid date range is from the work order released date till the system date. Future date is not valid and the default value is the system date.
    • Maximum Length: 100
      Abbreviation that identifies the transaction group.
    • Transaction Lots
      Title: Transaction Lots
      The Transaction Lots resource manages the details of the lot of the component issued to or returned from the work order.
    • Title: Transaction Quantity
      Quantity of the item transacted against the maintenance work order.
    • Transaction Serials
      Title: Transaction Serials
      The Transaction Serials resource manages details of the serial of the component issued to or returned from the work order.
    • Title: Transaction Type Code
      Maximum Length: 30
      Abbreviation that describes the type of material transactions supported for a maintenance work order. Valid values for a maintenance work order are MATERIAL_RETURN, MATERIAL_ISSUE, MATERIAL_NEGATIVE_ISSUE, and MATERIAL_NEGATIVE_RETURN. A list of accepted values is defined in the lookup type ORA_WIE_MTL_TXN_TYPE.
    • Title: Unit of Measure
      Maximum Length: 25
      Unit of measure to use during the item transaction. The primary unit of measure in the item definition should be used for the transaction.
    • Title: Use Common Inventory
      Maximum Length: 1
      Contains one of the following values: Y or N. If Y, then true. If N, then false. This attribute does not have a default value. This attribute is applicable only for work order component issue or reverse. If populated with any value for a work order without a project and task, it will be ignored. If populated for product completions or reverse or orderless transactions, it will be ignored.
    • Title: Operation Sequence
      Number that uniquely identifies the operation within the maintenance work orders. Material is transacted against operation in the maintenance work order.
    • Title: Work Order
      Maximum Length: 120
      Number that uniquely identifies the maintenance work order. The material transaction is performed against this maintenance work order.
    Nested Schema : Transaction Lots
    Type: array
    Title: Transaction Lots
    The Transaction Lots resource manages the details of the lot of the component issued to or returned from the work order.
    Show Source
    Nested Schema : Transaction Serials
    Type: array
    Title: Transaction Serials
    The Transaction Serials resource manages details of the serial of the component issued to or returned from the work order.
    Show Source
    Nested Schema : maintenanceMaterialTransactions-MaterialTransactionDetail-TransactionLot-item-response
    Type: object
    Show Source
    • Read Only: true
      Maximum Length: 255
      Name of the error messages that occurred when processing the transaction lot. Each text string in the ErrorMessages attribute corresponds to one error message name in the ErrorMessageNames attribute. A comma ( , ) separates each message name.
    • Read Only: true
      Maximum Length: 2000
      Text of the error messages that occurred when processing this transaction lot. Each text string in the ErrorMessages attribute corresponds to one error message name in the ErrorMessageNames attribute. A double dollar sign ($$) separates each message.
    • Links
    • Title: Lot Number
      Maximum Length: 80
      Number that identifies the lot number of the component item being issued or returned from a maintenance work order.
    • Title: Secondary Transaction Quantity
      Secondary quantity of the lot transaction of the component item transacted against the maintenance work order. If item is not defined as a dual unit of measure item or if conversion for the secondary unit of measure is set to fix, then this quantity is not required. If dual unit of measure conversion is set to default, then this quantity will override the defaulted quantity. If conversion is set to no default, then this quantity is required. The default value of secondary unit of measure is based on the setup.
    • Flexfields for Transaction Lots
      Title: Flexfields for Transaction Lots
      The Flexfields for Transaction Lots resource manages descriptive flexfields that contain details about the lot component transaction.
    • Title: Transaction Quantity
      Lot quantity of the component item transacted against the maintenance work order.
    Nested Schema : Flexfields for Transaction Lots
    Type: array
    Title: Flexfields for Transaction Lots
    The Flexfields for Transaction Lots resource manages descriptive flexfields that contain details about the lot component transaction.
    Show Source
    Nested Schema : maintenanceMaterialTransactions-MaterialTransactionDetail-TransactionLot-TransactionLotDFF-item-response
    Type: object
    Show Source
    • Title: Context Value
      Maximum Length: 30
      Descriptive flexfield context name for the lot component transaction.
    • Title: Context Value
    • This is a transient attribute. The value of this attribute will always be null. Ignore this attribute.
    • Value that uniquely identifies the lot component transaction that references a descriptive flexfield. It is recommended that you not include this attribute in the request payload. The response payload contains the primary key of the lot component transaction that references the descriptive flexfield.
    • Links
    Nested Schema : maintenanceMaterialTransactions-MaterialTransactionDetail-TransactionSerial-item-response
    Type: object
    Show Source
    • Read Only: true
      Maximum Length: 255
      Names of the error messages that occurred when processing the transaction serial. Each text string in the ErrorMessages attribute corresponds to one error message name in the ErrorMessageNames attribute. A comma ( , ) separates each message name.
    • Read Only: true
      Maximum Length: 2000
      Text of the error messages that occurred when processing this transaction serial. Each text string in the ErrorMessages attribute corresponds to one error message name in the ErrorMessageNames attribute. A double dollar sign ($$) separates each message.
    • Links
    • Title: Lot Number
      Maximum Length: 18
      Number that identifies the lot number of the serial controlled component item being issued or returned from a maintenance work order.
    • Title: Serial Number
      Maximum Length: 80
      Number that identifies the serial number of the component item being issued or returned from a maintenance work order.
    • Title: To Serial Number
      Maximum Length: 80
      Number that indicates the last serial number of the component items being issued or returned from a maintenance work order.
    • Flexfields for Transaction Serials
      Title: Flexfields for Transaction Serials
      The Flexfields for Transaction Serials resource manages descriptive flexfields that contain details about the serial component transaction.
    Nested Schema : Flexfields for Transaction Serials
    Type: array
    Title: Flexfields for Transaction Serials
    The Flexfields for Transaction Serials resource manages descriptive flexfields that contain details about the serial component transaction.
    Show Source
    Nested Schema : maintenanceMaterialTransactions-MaterialTransactionDetail-TransactionSerial-TransactionSerialDFF-item-response
    Type: object
    Show Source
    • Title: Context Value
      Maximum Length: 30
      Descriptive flexfield context name for the serial component transaction.
    • Title: Context Value
    • This is a transient attribute. The value of this attribute will always be null. Ignore this attribute.
    • Primary key of the serial component transaction that references a descriptive flexfield. It is recommended that you not include this attribute in the request payload. The response payload contains the primary key of the serial component transaction that references the descriptive flexfield.
    • Links
    Back to Top