1. REST API for Oracle Supply Chain Management Cloud
  2. Tasks
  3. Manufacturing
  4. Work Order Material Transactions

Create transactions

post

/fscmRestApi/resources/11.13.18.05/materialTransactions

Request

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.
Supported Media Types
Request Body - application/json ()
Root Schema : schema
Type: object
Show Source
  • 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 : schema
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.
  • 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.
  • 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-post-request
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.
  • Title: Item
    Maximum Length: 300
    Number that identifies the component of the assembly. Use this attribute only for an orderless transaction.
  • Title: Item Revision
    Maximum Length: 18
    Revision of the component that the application issued for the assembly in an orderless transaction.
  • 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 : schema
Type: object
Show Source
  • 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 : schema
Type: object
Show Source
  • 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-post-request
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.
Nested Schema : materialTransactions-MaterialTransactionDetail-TransactionItemDFF-item-post-request
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.
Nested Schema : schema
Type: object
Show Source
  • 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 : schema
Type: object
Show Source
  • Title: Context Value
    Maximum Length: 30
    Descriptive flexfield context name for transaction lots.
  • Title: Context Value
    Descriptive flexfield display value for transaction lots.
  • This is a transient attribute. The value of this attribute will always be null. Ignore this attribute.
  • Value that identifies the transaction lot that a descriptive flexfield references. This attribute is a primary key. It is recommended that you not include this attribute in the request payload.
Nested Schema : schema
Type: object
Show Source
  • 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-post-request
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.
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-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
Links
MaterialTransactionDetail
Parameters:
  • materialTransactionsUniqID: $request.path.materialTransactionsUniqID
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.
Back to Top

Examples

This example describes how to create one material transaction on one work order operation.

Example cURL Command

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

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

Example 1 Request Body

The following example includes the contents of the request body in JSON format. You replace the request payload in the cURL command with the contents of the Example Request Body. The request payload specifies attribute values that the command will use in the record that it creates. 

{
  "SourceSystemCode" : "FUSION_MOBILE",
  "SourceSystemType" : "EXTERNAL",
  "MaterialTransactionDetail" : [ {
     "InventoryItemNumber" : "SB32982",
     "OrganizationCode" : "M1",
     "SubinventoryCode" : "Stores",
     "TransactionDate" : "2016-06-07T11:12:30-07:00",
     "TransactionQuantity" : 1,
     "TransactionTypeCode" : "MATERIAL_ISSUE",
     "TransactionUnitOfMeasure" : "Each",
     "WoOperationSequenceNumber" : 10,
     "WorkOrderNumber" : "M11120"
  } ]
}

Example 1 Response Body

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

{
  "SourceSystemCode" : "FUSION_MOBILE",
  "SourceSystemType" : "EXTERNAL",
  "ErrorsExistFlag" : "false",
  "MaterialTransactionDetail" : [ {
    "InvTransactionId" : 300100046214462,
    "SourceSystemCode" : null,
    "OrganizationCode" : "M1",
    "WorkOrderNumber" : "M11120",
    "AssemblySerialNumber" : null,
    "WoOperationSequenceNumber" : 10,
    "TransactionDate" : "2016-06-07T11:12:30-07:00",
    "TransactionTypeCode" : "MATERIAL_ISSUE",
    "InventoryItemNumber" : "SB32982",
    "ItemRevision" : null,
    "TransactionQuantity" : 1,
    "TransactionUnitOfMeasure" : "Each",
    "SubinventoryCode" : "Stores",
    "Locator" : null,
    "WorkDefinitionCode" : null,
    "WorkOrderType" : null,
    "WorkOrderSubType" : null,
    "SourceHeaderReference" : null,
    "SourceHeaderReferenceId" : null,
    "SourceLineReference" : null,
    "SourceLineReferenceId" : null,
    "ReasonCode" : null,
    "TransactionNote" : null,
    "POLineNumber" : null,
    "PONumber" : null,
    "SoldToLegalEntityName" : null,
    "ErrorMessages" : "",
    "ErrorMessageNames" : "",
    ...
  } ]
}

Example 2 Request Body

The following example includes the contents of the request body in JSON format. You replace the request payload in the cURL command with the contents of the Example Request Body. The request payload specifies attribute values that the command will use in the record that it creates. The example demonstrates the usage of transaction item flexfields. 

{
    "SourceSystemCode": "FUSION_MOBILE",
    "SourceSystemType": "EXTERNAL",
    "MaterialTransactionDetail": [
        {
            "InventoryItemNumber": "MFG-PL-COMP1",
            "OrganizationCode": "M1",
            "SubinventoryCode": "Stores",
            "TransactionQuantity": 1,
            "TransactionTypeCode": "MATERIAL_ISSUE",
            "TransactionUnitOfMeasure": "Each",
            "WoOperationSequenceNumber": 10,
            "WorkOrderNumber": "M1-1223",
            "TransactionItemDFF": [
                {
                    "_Global__Segment2": "Matissue",
                    "_Patient__Account": "211-48-0987",
                    "_BI_2DGlobSeg_2DMatStat": "Matissue",
                    "vishsrtest1": "Matissue"
                }
            ]
        }
    ]
}

Example 2 Response Body

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

{
    "SourceSystemCode": "FUSION_MOBILE",
    "SourceSystemType": "EXTERNAL",
    "ErrorsExistFlag": "false",
    "MaterialTransactionDetail": [
        {
            "InvTransactionId": 0,
            "SourceSystemCode": null,
            "OrganizationCode": "M1",
            "WorkOrderNumber": "M1-1223",
            "AssemblySerialNumber": null,
            "WoOperationSequenceNumber": 10,
            "TransactionDate": "2024-04-25T09:43:42.305+00:00",
            "TransactionTypeCode": "MATERIAL_ISSUE",
            "InventoryItemNumber": "MFG-PL-COMP1",
            "ItemRevision": null,
            "TransactionQuantity": 1,
            "TransactionUOMCode": null,
            "TransactionUnitOfMeasure": "Each",
            "SecondaryTransactionQuantity": null,
            "SubinventoryCode": "Stores",
            "Locator": null,
            "WorkDefinitionCode": null,
            "WorkOrderType": "STANDARD",
            "WorkOrderSubType": null,
            "SourceHeaderReference": null,
            "SourceHeaderReferenceId": null,
            "SourceLineReference": null,
            "SourceLineReferenceId": null,
            "ReasonCode": null,
            "TransactionNote": null,
            "POLineNumber": null,
            "PONumber": null,
            "SoldToLegalEntityName": null,
            "ErrorMessages": "",
            "ErrorMessageNames": "",
            "OutputTypeCode": null,
            "ProjectNumber": null,
            "TaskNumber": null,
            "UseCommonInventoryFlag": null,
            "CountryOfOriginCode": null,
            "TransactionItemDFF": [
                {
                    "InterfaceRowId": 300100597707340,
                    "Discriminator": "REST",
                    "_Patient__Account": "211-48-0987",
                    "_Global__Segment2": "Matissue",
                    "_BI_2DGlobSeg_2DMatStat": "Matissue",
                    "vishsrtest1": "Matissue",
                    "test1": null,
                    "__FLEX_Context": null,
                    "__FLEX_Context_DisplayValue": null,
                    "links": [
                        {
                            "rel": "self",
                            "href": "https://servername/fscmRestApi/resources/version/materialTransactions/300100597707339/child/MaterialTransactionDetail/300100597707340/child/TransactionItemDFF/300100597707340",
                            "name": "TransactionItemDFF",
                            "kind": "item",
                            "properties": {
                                "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
                            }
                        },
                        {
                            "rel": "canonical",
                            "href": "https://servername/fscmRestApi/resources/version/materialTransactions/300100597707339/child/MaterialTransactionDetail/300100597707340/child/TransactionItemDFF/300100597707340",
                            "name": "TransactionItemDFF",
                            "kind": "item"
                        },
                        {
                            "rel": "parent",
                            "href": "https://servername/fscmRestApi/resources/version/materialTransactions/300100597707339/child/MaterialTransactionDetail/300100597707340",
                            "name": "MaterialTransactionDetail",
                            "kind": "item"
                        },
                        {
                            "rel": "lov",
                            "href": "https://servername/fscmRestApi/resources/version/materialTransactions/300100597707339/child/MaterialTransactionDetail/300100597707340/child/TransactionItemDFF/300100597707340/lov/LVVO__Patient__Account",
                            "name": "LVVO__Patient__Account",
                            "kind": "collection"
                        },
                        {
                            "rel": "lov",
                            "href": "https://servername/fscmRestApi/resources/version/materialTransactions/300100597707339/child/MaterialTransactionDetail/300100597707340/child/TransactionItemDFF/300100597707340/lov/LVVO___FLEX_Context",
                            "name": "LVVO___FLEX_Context",
                            "kind": "collection"
                        },
                        {
                            "rel": "lov",
                            "href": "https://servername/fscmRestApi/resources/version/materialTransactions/300100597707339/child/MaterialTransactionDetail/300100597707340/child/TransactionItemDFF/300100597707340/lov/LVVO_V___FLEX_Context",
                            "name": "LVVO_V___FLEX_Context",
                            "kind": "collection"
                        }
                    ]
                }
            ],
            "links": [
                {
                    "rel": "self",
                    "href": "https://servername/fscmRestApi/resources/version/materialTransactions/300100597707339/child/MaterialTransactionDetail/300100597707340",
                    "name": "MaterialTransactionDetail",
                    "kind": "item",
                    "properties": {
                        "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
                    }
                },
                {
                    "rel": "canonical",
                    "href": "https://servername/fscmRestApi/resources/version/materialTransactions/300100597707339/child/MaterialTransactionDetail/300100597707340",
                    "name": "MaterialTransactionDetail",
                    "kind": "item"
                },
                {
                    "rel": "parent",
                    "href": "https://servername/fscmRestApi/resources/version/materialTransactions/300100597707339",
                    "name": "materialTransactions",
                    "kind": "item"
                },
                {
                    "rel": "child",
                    "href": "https://servername/fscmRestApi/resources/version/materialTransactions/300100597707339/child/MaterialTransactionDetail/300100597707340/child/ComponentTransactionDetail",
                    "name": "ComponentTransactionDetail",
                    "kind": "collection"
                },
                {
                    "rel": "child",
                    "href": "https://servername/fscmRestApi/resources/version/materialTransactions/300100597707339/child/MaterialTransactionDetail/300100597707340/child/OrderlessTransactionDFF",
                    "name": "OrderlessTransactionDFF",
                    "kind": "collection"
                },
                {
                    "rel": "child",
                    "href": "https://servername/fscmRestApi/resources/version/materialTransactions/300100597707339/child/MaterialTransactionDetail/300100597707340/child/TransactionItemDFF",
                    "name": "TransactionItemDFF",
                    "kind": "collection"
                },
                {
                    "rel": "child",
                    "href": "https://servername/fscmRestApi/resources/version/materialTransactions/300100597707339/child/MaterialTransactionDetail/300100597707340/child/TransactionLot",
                    "name": "TransactionLot",
                    "kind": "collection"
                },
                {
                    "rel": "child",
                    "href": "https://servername/fscmRestApi/resources/version/materialTransactions/300100597707339/child/MaterialTransactionDetail/300100597707340/child/TransactionSerial",
                    "name": "TransactionSerial",
                    "kind": "collection"
                }
            ]
        }
    ],
    "links": [
        {
            "rel": "self",
            "href": "https://servername/fscmRestApi/resources/version/materialTransactions/300100597707339",
            "name": "materialTransactions",
            "kind": "item",
            "properties": {
                "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
            }
        },
        {
            "rel": "canonical",
            "href": "https://servername/fscmRestApi/resources/version/materialTransactions/300100597707339",
            "name": "materialTransactions",
            "kind": "item",
            "properties": {
                "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
            }
        },
        {
            "rel": "child",
            "href": "https://servername/fscmRestApi/resources/version/materialTransactions/300100597707339/child/MaterialTransactionDetail",
            "name": "MaterialTransactionDetail",
            "kind": "collection"
        }
    ]
}
Back to Top