Get action not supported

get

/fscmRestApi/resources/11.13.18.05/materialTransactions

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
      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:
      • ErrorsExistFlag; boolean; Contains one of the following values: true or false. If true, then an error occurred while processing the material transaction. If false, then an error did not occur. The request payload should not have this attribute. However, the response payload includes this attribute. This attribute does not have a default value.
      • SourceSystemCode; string; Abbreviation that identifies the source system that interfaces the material transaction. Values include INTERNAL or EXTERNAL.
      • SourceSystemType; string; Type of source system that interfaces this material transaction. You must register this type in Oracle Manufacturing Cloud.
    • 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 : materialTransactions
    Type: object
    Show Source
    Nested Schema : Items
    Type: array
    Title: Items
    The items in the collection.
    Show Source
    Nested Schema : materialTransactions-item-response
    Type: object
    Show Source
    • Read Only: true
      Contains one of the following values: true or false. If true, then an error occurred while processing the material transaction. If false, then an error did not occur. The request payload should not have this attribute. However, the response payload includes this attribute. This attribute does not have a default value.
    • Links
    • Material Transaction Details
      Title: Material Transaction Details
      The Material Transaction Details resource manages the details of the following: - materials issued to or returned from both a discrete and a process manufacturing work order - outputs completed or returned from a process manufacturing work order - product transaction detail for Orderless transactions.
    • Title: Source System Code
      Maximum Length: 30
      Abbreviation that identifies the source system that interfaces the material transaction. Values include INTERNAL or EXTERNAL.
    • Title: Source System Type
      Maximum Length: 30
      Default Value: EXTERNAL
      Type of source system that interfaces this material transaction. You must register this type in Oracle Manufacturing Cloud.
    Nested Schema : Material Transaction Details
    Type: array
    Title: Material Transaction Details
    The Material Transaction Details resource manages the details of the following: - materials issued to or returned from both a discrete and a process manufacturing work order - outputs completed or returned from a process manufacturing work order - product transaction detail for Orderless transactions.
    Show Source
    Nested Schema : materialTransactions-MaterialTransactionDetail-item-response
    Type: object
    Show Source
    • Maximum Length: 80
      Work order assembly serial number for which the material transaction is performed. This attribute is required only if the work order operation is serial tracked.
    • Component Transaction Details
      Title: Component Transaction Details
      The Component Transaction Details resource manages the component that the application issued to an assembly in an orderless transaction.
    • Title: Country of Origin
      Maximum Length: 2
      Abbreviation that identifies the country of origin associated with the product.
    • Read Only: true
      Maximum Length: 255
      Name of the error message, if any, when processing the material 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, if any, when processing the material 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.
    • Maximum Length: 150
      Value that uniquely identifies a container or package of products that are completed in manufacturing and maintenance.
    • Title: Item
      Maximum Length: 300
      Item number for the material transaction.
    • Value that uniquely identifies the transaction. If the transaction completes successfully, then this attribute contains a value that identifies the transaction. If the transaction does not complete successfully, then this attribute contains 0 (zero), the ErrorsExistFlag attribute contains true, and the ErrorMessages and ErrorMessageNames attributes contain error details.
    • Title: Item Revision
      Maximum Length: 18
      Item revision number for the transacted item.
    • Links
    • Maximum Length: 800
      Locator where the material is issued from or returned to.
    • Flexfields for Orderless Transactions
      Title: Flexfields for Orderless Transactions
      The Flexfields for Orderless Transactions resource manages descriptive flexfields that contain details about the orderless transaction.
    • Title: Organization Code
      Maximum Length: 30
      Abbreviation that identifies the organization as a manufacturing plant. Review and update the value for this attribute using the Setup and Maintenance work area, and the Define Manufacturing Plants (Organizations) task.
    • Title: Output Type
      Maximum Length: 30
      Type of output item. Valid values are PRODUCT or BY-PRODUCT. A list of accepted values is defined in the lookup type ORA_WIS_WD_OUTPUT_MATERIAL.
    • Title: Purchase Order Line Number
      Value that uniquely identifies the line on the purchase order document. Use this attribute only if the plant is a contract manufacturing plant.
    • Title: Purchase Order Header Number
      Maximum Length: 30
      Number of the purchase order document. Use this attribute only if the plant is a contract manufacturing plant.
    • Title: Project Number
      Maximum Length: 25
      Number that identifies the project. This attribute is associated with a feature that requires opt in.
    • Title: Reason Code
      Maximum Length: 30
      Abbreviation that identifies the reason that you specify for the orderless scrap and orderless return from a scrap transaction.
    • Title: Secondary Transaction Quantity
      Secondary quantity transacted for the material. If the transaction type code is MATERIAL_NEGATIVE_ISSUE or MATERIAL_NEGATIVE_RETURN, then the secondary transaction quantity is negative. This attribute is associated with a feature that requires opt in.
    • Title: Sold-to Legal Entity Name
      Maximum Length: 240
      Value that represents the Sold to legal entity name as per the contract manufacturing purchase order. Use this attribute only if the plant is a contract manufacturing plant.
    • Title: Source Header Reference
      Maximum Length: 240
      Reference to the object header in the source system.
    • Title: Source Header Reference ID
      Value that uniquely identifies the object header in the source system.
    • Title: Source Line Reference
      Maximum Length: 240
      Reference to the object line in the source system.
    • Title: Source Line Reference ID
      Value that uniquely identifies the object line in the source system.
    • Title: Source System Code
      Maximum Length: 30
      Abbreviation that identifies the source system that started the material transaction. Source system code as defined in the Trading Community Model for external systems or the application product code for internal systems (Fusion applications). If the Source System Type is INTERNAL, the Source System Code value is WIE. If the Source System Type is EXTERNAL, then review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Trading Community Source Systems task.
    • Title: Subinventory Code
      Maximum Length: 18
      Abbreviation that identifies the subinventory where the material is issued from or returned to.
    • Title: Task Number
      Maximum Length: 100
      Number that identifies the task. This attribute is associated with a feature that requires opt in.
    • Title: Transaction Date
      Date time when the transaction was executed.
    • Flexfields for Item in Material Transactions
      Title: Flexfields for Item in Material Transactions
      A flexible data field that includes work order components, products, and output transactions.
    • Transaction Lots
      Title: Transaction Lots
      The Transaction Lots resource manages details of the lot of the component issued to or returned from the work order.
    • Title: Transaction Note
      Maximum Length: 4000
      Text instructions for the production supervisor for an orderless transaction.
    • Title: Transaction Quantity
      Quantity transacted for the material. If the transaction type code is MATERIAL_NEGATIVE_ISSUE or MATERIAL_NEGATIVE_RETURN, then the transaction quantity is negative.
    • 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 identifies the material transaction type. 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 when reporting the transacted quantity.
    • Title: Unit of Measure
      Maximum Length: 3
      Abbreviation that identifies the unit of measure to use when reporting the transacted quantity.
    • Title: Use Common Inventory
      Maximum Length: 1
      Contains one of the following values: true or false. If true, then material should be issued from or returned to the common inventory. If false, then material should be issued from or returned to the project associated with the work order. This attribute does not have a default value. This attribute is associated with a feature that requires opt in.
    • Title: Operation Sequence
      Sequence number of the operation as defined in the work order operations. This attribute takes only whole numbers as valid values.
    • Title: Work Definition
      Maximum Length: 30
      Abbreviation that identifies the work definition. Use this attribute only if the transaction type code is either ORDERLESS_COMPLETION, ORDERLESS_RETURN, ORDERLESS_RETURN_SCRAP, or ORDERLESS_SCRAP.
    • Title: Work Order
      Maximum Length: 120
      Number that uniquely identifies the work order within a plant. Do not populate this attribute if the TransactionTypeCode is either ORDERLESS_COMPLETION, ORDERLESS_RETURN, ORDERLESS_RETURN_SCRAP, or ORDERLESS_SCRAP.
    • Title: Subtype
      Maximum Length: 30
      Value that indicates the nature of work for an orderless transaction. Use this attribute only with an orderless transaction. A list of accepted values is defined in the lookup type ORA_WIE_WO_SUB_TYPE.
    • Title: Type
      Maximum Length: 30
      Value that indicates the nature of work for an orderless transaction. Use this attribute only with an orderless transaction.
    Nested Schema : Component Transaction Details
    Type: array
    Title: Component Transaction Details
    The Component Transaction Details resource manages the component that the application issued to an assembly in an orderless transaction.
    Show Source
    Nested Schema : Flexfields for Orderless Transactions
    Type: array
    Title: Flexfields for Orderless Transactions
    The Flexfields for Orderless Transactions resource manages descriptive flexfields that contain details about the orderless transaction.
    Show Source
    Nested Schema : Flexfields for Item in Material Transactions
    Type: array
    Title: Flexfields for Item in Material Transactions
    A flexible data field that includes work order components, products, and output transactions.
    Show Source
    Nested Schema : Transaction Lots
    Type: array
    Title: Transaction Lots
    The Transaction Lots resource manages 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 : materialTransactions-MaterialTransactionDetail-ComponentTransactionDetail-item-response
    Type: object
    Show Source
    • Lot Details for Component Transactions
      Title: Lot Details for Component Transactions
      The Lot Details for Component Transactions resource manages the component lot that the application issued to an assembly in an orderless transaction.
    • Serial Details for Component Transactions
      Title: Serial Details for Component Transactions
      The Serial Details for Component Transactions resource manages the component serial that the application issued to an assembly in an orderless transaction.
    • Title: Country of Origin
      Maximum Length: 2
      Abbreviation that identifies the country of origin associated to the product.
    • Read Only: true
      Maximum Length: 255
      Name of the error message, if any, when processing the component issue in an orderless 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, if any, when processing the component issue in an orderless 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 identifies the component of the assembly. Use this attribute only for an orderless transaction.
    • Read Only: true
      Value that uniquely identifies the transaction. If the transaction completes successfully, then this attribute contains a value that identifies the transaction. If the transaction does not complete successfully, then this attribute contains 0 (zero), the ErrorsExistFlag attribute contains true, and the ErrorMessages and ErrorMessageNames attributes contain error details.
    • Title: Item Revision
      Maximum Length: 18
      Revision of the component that the application issued for the assembly in an orderless transaction.
    • Links
    • Maximum Length: 800
      Locator that the application uses to issue the component to the assembly.
    • Title: Secondary Quantity
      Secondary quantity of the transacted material issued to the assembly in an orderless transaction. This attribute is associated with a feature that requires opt in.
    • Title: Subinventory Code
      Maximum Length: 18
      Abbreviation that identifies the subinventory that the application uses to issue the component to the assembly.
    • Title: Transaction Quantity
      Quantity of the transacted material issued to the assembly in an orderless transaction.
    • Title: Unit of Measure
      Maximum Length: 25
      Unit of measure to use when reporting the transacted quantity.
    • Title: Unit of Measure
      Maximum Length: 3
      Abbreviation that identifies the unit of measure for the transacted quantity.
    • Maximum Length: 1
      Contains one of the following values: true or false. If true, then material should be issued from or returned to the common inventory. If false, then material should be issued from or returned to the project associated with the work order. This attribute does not have a default value. This attribute is associated with a feature that requires opt in.
    • Title: Operation Sequence
      Operation sequence number of the work definition that the orderless transaction references. The application issues the component according to this sequence.
    Nested Schema : Lot Details for Component Transactions
    Type: array
    Title: Lot Details for Component Transactions
    The Lot Details for Component Transactions resource manages the component lot that the application issued to an assembly in an orderless transaction.
    Show Source
    Nested Schema : Serial Details for Component Transactions
    Type: array
    Title: Serial Details for Component Transactions
    The Serial Details for Component Transactions resource manages the component serial that the application issued to an assembly in an orderless transaction.
    Show Source
    Nested Schema : materialTransactions-MaterialTransactionDetail-ComponentTransactionDetail-ComponentTransactionLot-item-response
    Type: object
    Show Source
    • Read Only: true
      Maximum Length: 255
      Name of the error message, if any, when processing the component lot issue in an orderless 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, if any, when processing the component lot issue in an orderless 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.
    • Links
    • Title: Lot Number
      Maximum Length: 80
      Lot number of the component that the application issued to the assembly in an orderless transaction.
    • Title: Secondary Transaction Quantity
      Secondary quantity of the material lot issued to the assembly in an orderless transaction. This attribute is associated with a feature that requires opt in.
    • Title: Transaction Quantity
      Quantity of the material lot issued to the assembly in an orderless transaction.
    Nested Schema : materialTransactions-MaterialTransactionDetail-ComponentTransactionDetail-ComponentTransactionSerial-item-response
    Type: object
    Show Source
    • Read Only: true
      Maximum Length: 255
      Name of the error message, if any, when processing the component serial issue in an orderless 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, if any, when processing the component serial issue in an orderless 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.
    • Links
    • Title: Lot Number
      Maximum Length: 18
      Lot number of the serial for the component that the application issued to the assembly in an orderless transaction. This attribute is optional.
    • Title: Serial Number
      Maximum Length: 80
      Starting serial number that identifies the component that the application issued to the assembly in an orderless transaction.
    • Title: To Serial Number
      Maximum Length: 80
      Ending serial number that identifies the component that the application issued to the assembly in an orderless transaction. This attribute is optional.
    Nested Schema : materialTransactions-MaterialTransactionDetail-OrderlessTransactionDFF-item-response
    Type: object
    Show Source
    • Title: Context Segment
      Maximum Length: 80
      Descriptive flexfield context name for orderless transactions.
    • Title: Context Segment
    • This is a transient attribute. The value of this attribute will always be null. Ignore this attribute.
    • Value that uniquely identifies the material transaction detail that a descriptive flexfield references. This attribute should not be included in the request payload. The value of this attribute in the response payload includes the primary key of the material transaction detail.
    • Links
    Nested Schema : materialTransactions-MaterialTransactionDetail-TransactionItemDFF-item-response
    Type: object
    Show Source
    • Title: Context
      Maximum Length: 30
      Descriptive flexfield context name for items in the transactions.
    • Title: Context
      Descriptive flexfield context display value for items in the transactions.
    • This is a transient attribute. The value of this attribute is always null. Ignore this attribute.
    • Value that uniquely identifies the item of the transaction that a descriptive flexfield references. This attribute shouldn't be included in the request payload. The value of this attribute in the response payload includes the primary key of the item of the transaction.
    • Links
    Nested Schema : materialTransactions-MaterialTransactionDetail-TransactionLot-item-response
    Type: object
    Show Source
    • Read Only: true
      Maximum Length: 255
      Name of the error message, if any, 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 message, if any, 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 Expiration Date
      Date when the component of this lot expires. This attribute is required only for a new lot and is applicable only for orderless completions.
    • Title: Hold Until Date
      Date when the hold expires for the lot number. This attribute is associated with a feature that requires opt in.
    • Title: Lot Number
      Maximum Length: 80
      Lot number of the material (component) issued for the work order. This attribute is needed only if material is lot controlled.
    • Title: Lot Origination Date
      Date when the lot originated. This attribute is required only if the item is lot controlled and transaction type code is ORDERLESS_COMPLETION.
    • Title: Parent Lot Number
      Maximum Length: 80
      Number that identifies the parent lot of the lot number used for the work order material. This attribute is applicable if the material is lot controlled. This attribute is associated with a feature that requires opt in.
    • Title: Secondary Transaction Quantity
      Secondary quantity of the material lot transacted for the work order. This attribute is associated with a feature that requires opt in.
    • Flexfields for Material Transaction Lots
      Title: Flexfields for Material Transaction Lots
      The Flexfields for Material Transaction Lots resource manages descriptive flexfields for process manufacturing work order output transactions. It doesn???t manage descriptive flexfields for work order component transactions.
    • Title: Transaction Quantity
      Quantity of the material lot transacted for the work order.
    Nested Schema : Flexfields for Material Transaction Lots
    Type: array
    Title: Flexfields for Material Transaction Lots
    The Flexfields for Material Transaction Lots resource manages descriptive flexfields for process manufacturing work order output transactions. It doesn???t manage descriptive flexfields for work order component transactions.
    Show Source
    Nested Schema : materialTransactions-MaterialTransactionDetail-TransactionLot-TransactionLotDFF-item-response
    Type: object
    Show Source
    Nested Schema : materialTransactions-MaterialTransactionDetail-TransactionSerial-item-response
    Type: object
    Show Source
    • Read Only: true
      Maximum Length: 255
      Name of the error message, if any, 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 message, if any, 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
      Lot number of the serial of the component that the application issued for the work order. This attribute is optional.
    • Title: Serial Number
      Maximum Length: 80
      Starting serial number that identifies the component that the application issued for the work order.
    • Title: To Serial Number
      Maximum Length: 80
      Ending serial number that identifies the component that the application issued for the work order.
    • Flexfields for Material Transaction Serials
      Title: Flexfields for Material Transaction Serials
      The Flexfields for Material Transaction Serials resource manages descriptive flexfields that contain details about the transaction serial.
    Nested Schema : Flexfields for Material Transaction Serials
    Type: array
    Title: Flexfields for Material Transaction Serials
    The Flexfields for Material Transaction Serials resource manages descriptive flexfields that contain details about the transaction serial.
    Show Source
    Nested Schema : materialTransactions-MaterialTransactionDetail-TransactionSerial-TransactionSerialDFF-item-response
    Type: object
    Show Source
    • Title: Context Value
      Maximum Length: 30
      Descriptive flexfield context name for transactions serials.
    • Title: Context Value
      Descriptive flexfield context display value for transactions serials.
    • This is a transient attribute. The value of this attribute will always be null. Ignore this attribute.
    • Value that uniquely identifies the transaction lot that a descriptive flexfield references. This attribute should not be included in the request payload. The value of this attribute in the response payload includes the primary key of the transaction lot.
    • Links
    Back to Top