1. REST API for Oracle Fusion Cloud SCM
  2. Tasks
  3. Inventory Management
  4. Inventory Transactions (Deprecated)
  5. Transaction Lines

GET action not supported

get

/fscmRestApi/resources/11.13.18.05/inventoryTransactions/{inventoryTransactionsUniqID}/child/transactionLines

Request

Path Parameters
  • This is the hash key of the attributes which make up the composite key for the Inventory Transactions (Deprecated) resource and used to uniquely identify an instance of Inventory Transactions (Deprecated). The client should not generate the hash key value. Instead, the client should query on the Inventory Transactions (Deprecated) collection resource in order to navigate to a specific instance of Inventory Transactions (Deprecated) to get the hash key.
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: Find transaction lines.
      Finder Variables:
      • UniqueTransactionId; integer; Value that uniquely identifies the transaction line.
  • 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:
    • AgingOnsetDate; string; Date when the inventory aging starts for the consigned item.
    • DistributionAccountId; integer; Value that uniquely identifies the distribution account.
    • InventoryItemId; integer; Value that uniquely identifies the item.
    • Item; string; Name of the item.
    • LocationType; string; Type of ship-to location.
    • Locator; string; Name of the locator.
    • LocatorId; integer; Value that uniquely identifies the locator.
    • OrganizationId; integer; Value that uniquely identifies the organization.
    • OrganizationName; string; Name of the organization.
    • OwningOrganizationId; integer; Value that uniquely identifies the owning organization.
    • OwningOrganizationName; string; Name of the owning organization.
    • OwningTpType; string; Type of owning party.
    • PrimaryQuantity; number; Transaction quantity in the primary unit of measure.
    • ProcurementBU; string; Procurement business unit for a consigned item.
    • ReasonId; integer; Value that uniquely identifies the transaction reason.
    • ReasonName; string; Name of the transaction reason.
    • Revision; string; Revision of the item.
    • SecondaryTransactionQuantity; number; Secondary transaction quantity.
    • ShipmentNumber; string; Value that uniquely identifies the shipment.
    • SourceHeaderId; integer; Value that uniquely identifies the transaction source header.
    • SourceLineId; integer; Value that uniquely identifies the transaction source line.
    • Subinventory; string; Name of the subinventory.
    • TransactionAction; string; Name of the transaction action.
    • TransactionActionId; string; Value that uniquely identifies the transaction action.
    • TransactionDate; string; Date when the transaction occurred.
    • TransactionHeaderId; integer; Value that uniquely identifies the transaction header.
    • TransactionQuantity; number; Transaction quantity.
    • TransactionSourceId; integer; Value that uniquely identifies the transaction source.
    • TransactionSourceName; string; Name of the transaction source.
    • TransactionSourceTypeId; integer; Value that uniquely identifies the transaction source type.
    • TransactionSourceTypeName; string; Name of the transaction source type.
    • TransactionType; string; Name of the transaction type.
    • TransactionTypeId; integer; Value that uniquely identifies the transaction type.
    • TransactionUOM; string; Abbreviation that identifies the unit of measure for the transaction.
    • TransactionUnitOfMeasure; string; Unit of measure for the transaction.
    • TransferLocator; integer; Destination locator identifier for a transfer transaction.
    • TransferLocatorName; string; Name of the destination locator for a transfer transaction.
    • TransferOrganizationId; integer; Value that uniquely identifies the destination organization for transfer transactions.
    • TransferOrganizationName; string; Name of the transfer organization.
    • TransferOwningOrganizationId; integer; Value that uniquely identifies the transfer owning organization.
    • TransferOwningOrganizationName; string; Name of the transfer owning organization.
    • TransferOwningTpType; string; Type of the transfer owning party.
    • TransferSubinventory; string; Name of the destination subinventory for a transfer transaction.
    • UniqueTransactionId; integer; Value that uniquely identifies the transaction line.
    • VendorName; string; Supplier name for the consigned item.
    • VendorNumber; string; Supplier number for the consigned item.
  • 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 : inventoryTransactions-transactionLines
Type: object
Show Source
Nested Schema : Items
Type: array
Title: Items
The items in the collection.
Show Source
Nested Schema : inventoryTransactions-transactionLines-item-response
Type: object
Show Source
Nested Schema : Lots That Control Items
Type: array
Title: Lots That Control Items
The Lots That Control Items resource manages details about the lot. Use it when only the lot controls the item.
Show Source
Nested Schema : Lots That Share Control
Type: array
Title: Lots That Share Control
The Lots That Share Control resource manages details about the lots that control the item. Use it when lots and serials control the item.
Show Source
Nested Schema : Serials That Control Items
Type: array
Title: Serials That Control Items
The Serials That Control Items resource manages details about the serial. Use it when only the serial controls the item.
Show Source
Nested Schema : Flexfields for Transaction Lines
Type: array
Title: Flexfields for Transaction Lines
The Flexfields for Transaction Lines resource manages the descriptive flexfield that modifies transaction lines.
Show Source
Nested Schema : inventoryTransactions-transactionLines-lotItemLots-item-response
Type: object
Show Source
Nested Schema : Flexfields for Lot Attributes
Type: array
Title: Flexfields for Lot Attributes
The Flexfields for Lot Attributes resource manages the descriptive flexfields in inventory transactions when an item is lot controlled.
Show Source
Nested Schema : Flexfields for Lots
Type: array
Title: Flexfields for Lots
The Flexfields for Lots resource manages the descriptive flexfields in inventory transactions when an item is lot controlled.
Show Source
Nested Schema : inventoryTransactions-transactionLines-lotItemLots-lotItemLotAttributesDFF-item-response
Type: object
Show Source
  • Title: Context Value
    Maximum Length: 30
    Descriptive flexfield context name for an attribute of the lot. Applies when the item is lot controlled.
  • Title: Context Value
    Descriptive flexfield context display value for an attribute of the lot. Applies when the item is lot controlled.
  • Links
  • Maximum Length: 80
    Number that identifies the lot of the inventory item that references an attribute of the lot. Applies when the item is lot controlled.
  • Value that uniquely identifies the interface transaction line that references an attribute of the lot. Applies when the item is lot controlled.
Nested Schema : inventoryTransactions-transactionLines-lotItemLots-lotItemLotsDFF-item-response
Type: object
Show Source
  • Title: Context Value
    Maximum Length: 30
    Descriptive flexfield context name for lots. Applies when the item is both lot and serial controlled.
  • Title: Context Value
    Descriptive flexfield context display value for lots. Applies when the item is both lot and serial controlled.
  • Links
  • Maximum Length: 80
    Number that identifies the lot of the inventory item that references the lot. Applies when the item is both lot and serial controlled.
  • Value that uniquely identifies the interface transaction line that references the lot. Applies when the item is both lot and serial controlled.
Nested Schema : inventoryTransactions-transactionLines-lotSerialItemLots-item-response
Type: object
Show Source
Nested Schema : Flexfields for Lot Attributes That Share Control
Type: array
Title: Flexfields for Lot Attributes That Share Control
The Flexfields for Lot Attributes That Share Control resource manages the descriptive flexfields in inventory transactions when an item is both lot and serial controlled.
Show Source
Nested Schema : Flexfields for Lots That Share Control
Type: array
Title: Flexfields for Lots That Share Control
The Flexfields for Lots That Share Control resource manages the descriptive flexfields in inventory transactions when an item is both lot and serial controlled.
Show Source
Nested Schema : Serials That Share Control
Type: array
Title: Serials That Share Control
The Serials That Share Control resource manages details about the serials that control the item. Use it when lots and serials control the item.
Show Source
Nested Schema : inventoryTransactions-transactionLines-lotSerialItemLots-lotSerialItemLotAttributesDFF-item-response
Type: object
Show Source
  • Title: Context Value
    Maximum Length: 30
    Descriptive flexfield context name for an attribute of the lot. Applies when the item is lot controlled.
  • Title: Context Value
    Descriptive flexfield context display value for an attribute of the lot. Applies when the item is lot controlled.
  • Links
  • Maximum Length: 80
    Number that identifies the lot of the inventory item that references an attribute of the lot. Applies when the item is lot controlled.
  • Value that uniquely identifies the interface transaction line that references an attribute of the lot. Applies when the item is lot controlled.
Nested Schema : inventoryTransactions-transactionLines-lotSerialItemLots-lotSerialItemLotsDFF-item-response
Type: object
Show Source
  • Title: Context Value
    Maximum Length: 30
    Descriptive flexfield context name for lots. Applies when the item is both lot and serial controlled.
  • Title: Context Value
    Descriptive flexfield context display value for lots. Applies when the item is both lot and serial controlled.
  • Links
  • Maximum Length: 80
    Number that identifies the lot of the inventory item that references the lot. Applies when the item is both lot and serial controlled.
  • Value that uniquely identifies the interface transaction line that references the lot. Applies when the item is both lot and serial controlled.
Nested Schema : inventoryTransactions-transactionLines-lotSerialItemLots-lotSerialItemSerials-item-response
Type: object
Show Source
Nested Schema : Flexfields for Serials That Share Control
Type: array
Title: Flexfields for Serials That Share Control
The Flexfields for Serials That Share Control resource manages the descriptive flexfields in inventory transactions when an item is both lot and serial controlled.
Show Source
Nested Schema : Flexfields for Serial Attributes That Share Control
Type: array
Title: Flexfields for Serial Attributes That Share Control
The Flexfields for Serial Attributes That Share Control resource manages the descriptive flexfields in inventory transactions when an item is both lot and serial controlled.
Show Source
Nested Schema : inventoryTransactions-transactionLines-lotSerialItemLots-lotSerialItemSerials-lotSerialItemSerialAttributesDFF-item-response
Type: object
Show Source
  • Title: Context Value
    Maximum Length: 30
    Descriptive flexfield context name for an attribute of the serial. Applies when the item is both lot and serial controlled.
  • Title: Context Value
    Descriptive flexfield context display value for an attribute of the serial. Applies when the item is both lot and serial controlled.
  • Maximum Length: 80
    Starting serial number in a range of serial numbers that references an attribute of the serial. Applies when the item is both lot and serial controlled.
  • Links
  • Value that uniquely identifies the interface transaction line that references the attribute of the serial. Applies when the item is both lot and serial controlled.
Nested Schema : inventoryTransactions-transactionLines-lotSerialItemLots-lotSerialItemSerials-lotSerialItemSerialsDFF-item-response
Type: object
Show Source
  • Title: Context Value
    Maximum Length: 30
    Descriptive flexfield context name for serials. Applies when the item is both lot and serial controlled.
  • Title: Context Value
    Descriptive flexfield context name for serials. Applies when the item is both lot and serial controlled.
  • Maximum Length: 80
    Starting serial number in a range of serial numbers that references the serial. Applies when the item is both lot and serial controlled.
  • Links
  • Value that uniquely identifies the interface transaction line that references the serial. Applies when the item is both lot and serial controlled.
Nested Schema : inventoryTransactions-transactionLines-serialItemSerials-item-response
Type: object
Show Source
Nested Schema : Flexfields for Serial Attributes
Type: array
Title: Flexfields for Serial Attributes
The Flexfields for Serial Attributes resource manages the descriptive flexfields in inventory transactions when an item is serial controlled.
Show Source
Nested Schema : Flexfields for Serials
Type: array
Title: Flexfields for Serials
The Flexfields for Serials resource manages the descriptive flexfields in inventory transactions when an item is serial controlled.
Show Source
Nested Schema : inventoryTransactions-transactionLines-serialItemSerials-serialItemSerialAttributesDFF-item-response
Type: object
Show Source
  • Title: Context Value
    Maximum Length: 30
    Descriptive flexfield context name for an attribute of the serial. Applies when the item is both lot and serial controlled.
  • Title: Context Value
    Descriptive flexfield context display value for an attribute of the serial. Applies when the item is both lot and serial controlled.
  • Maximum Length: 80
    Starting serial number in a range of serial numbers that references an attribute of the serial. Applies when the item is both lot and serial controlled.
  • Links
  • Value that uniquely identifies the interface transaction line that references the attribute of the serial. Applies when the item is both lot and serial controlled.
Nested Schema : inventoryTransactions-transactionLines-serialItemSerials-serialItemSerialsDFF-item-response
Type: object
Show Source
  • Title: Context Value
    Maximum Length: 30
    Descriptive flexfield context name for serials. Applies when the item is both lot and serial controlled.
  • Title: Context Value
    Descriptive flexfield context name for serials. Applies when the item is both lot and serial controlled.
  • Maximum Length: 80
    Starting serial number in a range of serial numbers that references the serial. Applies when the item is both lot and serial controlled.
  • Links
  • Value that uniquely identifies the interface transaction line that references the serial. Applies when the item is both lot and serial controlled.
Nested Schema : inventoryTransactions-transactionLines-transactionLinesDFF-item-response
Type: object
Show Source
Back to Top