Get one item

get

/fscmRestApi/resources/11.13.18.05/itemsLOV/{itemsLOVUniqID}

Request

Path Parameters
  • This is the hash key of the attributes which make up the composite key for the Items List of Values resource and used to uniquely identify an instance of Items List of Values. The client should not generate the hash key value. Instead, the client should query on the Items List of Values collection resource in order to navigate to a specific instance of Items List of Values 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
  • 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
  • The resource item payload will be filtered in order to contain only data (no links section, for example).
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 : itemsLOV-item-response
Type: object
Show Source
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then maintainable assets can be defined for the item. If false, then maintainable assets can't be defined for the item. The default value is false.
  • Read Only: true
    Maximum Length: 30
    Approval status of the item. A list of accepted values is defined in the lookup type EGP_APPROVAL_STATUS. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, the item is built for sales order demand and a final assembly work order is created based on sales order details. If false, then the assembly work order isn't created for the item. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item is classified as an asset item. If false, then the item isn't classified as an asset item. The default value is false. For a list of attribute value interdependencies, refer to Interdependent Item Attributes: Explained at: https://www.oracle.com/pls/topic/lookup?ctx=cloud&id=FAPIM287169.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item is created automatically. If false, then the item isn't created automatically. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then enable the item for back-to-back ordering. If false, then don't enable the item for back-to-back ordering. The default value is false. For a list of attribute value interdependencies, refer to Interdependent Item Attributes.
  • Value that uniquely identifies the model to use when creating an assemble-to-order configuration. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
  • Value that indicates the type of bill of material that the item can have. Values include standard, model, and planning. A list of accepted values is defined in the lookup type EGP_BOM_ITEM_TYPE. Review the value for this attribute using the Manage Standard Lookups task in the Setup and Maintenance work area. The default value is 4. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then if the parent lot is specified, use lot control on the item during the transaction. If false, then don't use lot control on the item during the transaction. The default value is false.
  • Maximum Length: 64
    Name of the user who created the item.
  • Maximum Length: 30
    Contains one of the following values: true or false. If true, then create a depreciable inventory asset for the item when using the installed base. If false, then don't track. The default value is false. For a list of attribute value interdependencies, refer to Interdependent Item Attributes: Explained at: https://www.oracle.com/pls/topic/lookup?ctx=cloud&id=FAPIM287169.
  • Read Only: true
    Date when the user created the item.
  • Cross-Reference Relationships
    Title: Cross-Reference Relationships
    The Cross-Reference Relationships resource manages the relationship between an internal item and item cross-references.
  • Read Only: true
    Maximum Length: 120
    Abbreviation that identifies the lifecycle phase of the item. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Lifecycle Phases task.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item can be ordered by external customers at this time. If false, then the item can't be ordered by external customers at this time. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
  • Maximum Length: 1
    Value that indicates whether to allow an item to be ordered by external customers. Contains one of the following values: true or false. If true, then the item can be ordered by external customers. If false, then the item can't be ordered by external customers. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item is scheduled for automatic cycle count. If false, then the item isn't cycle counted. The default value is false.
  • Maximum Length: 150
    Internal value that indicates the default grade for the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Lot Grades task. The default value is Null.
  • Read Only: true
    Maximum Length: 255
    Value that indicates default grade for the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Lot Grades task. The default value is Null.
  • Maximum Length: 30
    Value that indicates how the conversion between the primary and secondary units of measure is handled. Valid values are Default, Fixed, and No Default. You can provide the value of Defaulting Control depending on the value of the Tracking Unit of Measure attribute. If the tracking unit of measure is Primary and Secondary, then the Defaulting Control can be provided. Otherwise, the Defaulting Control can't be provided.
  • Internal value that indicates the default lot status for the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Material Statuses task. The default value is Null.
  • Read Only: true
    Maximum Length: 255
    Value that indicates the default lot status for the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Material Statuses task. The default value is Null.
  • Value that indicates how to calculate the lead time based on Date, Model, or Unit Number. A list of accepted values is defined in the lookup type EGP_BOM_EFFEC_CTRL. Review the value for this attribute using the Manage Standard Lookups task in the Setup and Maintenance work area. The default value is 1. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item is enabled for genealogy tracking. If false, then the item isn't enabled for genealogy tracking. The default value is false.
  • Maximum Length: 1
    Contains one of the following values: True or False. If True, then the asset can be enabled for Internet of Things (IoT). If False, then the asset can't be enabled for IoT. The default value is False.
  • Maximum Length: 32
    Internal value that indicates the default action to be taken for this item when the lot expires or the lot fails a quality check. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Lot Expiration Actions task. The default value is Null.
  • Number of days the application adds to the expiration date before taking action on the lot.
  • Read Only: true
    Maximum Length: 255
    Value that indicates the default action to be taken for this item when the lot expires or the lot fails a quality check. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Lot Expiration Actions task. The default value is Null.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item is grade-controlled in addition to being lot-controlled. If false, then the item isn't grade-controlled. The default value is false.
  • GTIN Relationships
    Title: GTIN Relationships
    The GTIN Relationships resource manages the relationship between an internal item and GTIN.
  • Number of days to add to the lot creation date, which determines when you can release the lot.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item can be ordered by internal customers. If false, then the item can't be ordered by internal customers. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item can be stocked and transacted. If false, then the item can't be stocked and transacted. The default value is false.
  • Read Only: true
    Maximum Length: 10
    Abbreviation that identifies the item status. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Statuses task.
  • Item Categories
    Title: Item Categories
    The association of a category to a catalog or a child category to a parent category, such as the association of the Televisions category to the Summer catalog or to the Electronics category.
  • Title: Item Class
    Read Only: true
    Maximum Length: 250
    Name of the item class. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Classes task.
  • Read Only: true
    Value that uniquely identifies the item class.
  • Read Only: true
    Value that uniquely identifies the definition organization associated with the item.
  • Read Only: true
    Maximum Length: 240
    Description of the part, item, product, or service.
  • ItemDFF
    The Descriptive Flexfield for Items List of Values resource gets the descriptive flexfields associated with the item object.
  • Read Only: true
    Value that uniquely identifies the part, item, product, or service.
  • Read Only: true
    Maximum Length: 300
    Name or number of the part, item, product, or service.
  • Read Only: true
    Maximum Length: 255
    Value that identifies the item status. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Statuses task.
  • Read Only: true
    Maximum Length: 30
    Type of the item. A list of accepted values is defined in the lookup type EGP_ITEM_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
  • Read Only: true
    Maximum Length: 1000
    Value that represents a string of characters used for searching using keywords.
  • Read Only: true
    Date and time when the user most recently updated the item.
  • Maximum Length: 64
    User who most recently updated the item.
  • Links
  • Value that indicates the ability to use lot numbers during material transactions for tracking of batches of Item. A list of accepted values is defined in the lookup type EGP_LOT_CONTROL_CODE_TYPE. Review the value for this attribute using the Manage Standard Lookups task in the Setup and Maintenance work area.
  • Value that indicates how long items in a lot remain available. A list of accepted values is defined in the lookup type EGP_SHELF_LIFE_CODE_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is 1.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then allow the application to merge multiple lots into one lot for an item that lots control. If false, then don't allow this merge. The default value is false.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the lot-controlled item can be split into many lots. If false, then the lot-controlled item can't be split into many lots. The default value is false.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then item lot is status-controlled at the lot level. If false, then item lot isn't status-controlled. The default value is false.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then item lots can be translated. If false, then item lots can't be translated. The default value is false.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then transactions can be performed on the item. If false, then transactions can't be performed on the item. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
  • Number of days to add to the lot creation date to determine the lot maturity date.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then allow orders in fractions of an item. If false, then don't allow orders in fractions of an item. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
  • Read Only: true
    Maximum Length: 18
    Abbreviation that identifies the organization. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task.
  • Read Only: true
    Value that uniquely identifies the organization. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item can be added to an outside processing purchase order. If false, then the item can't be added to an outside processing purchase order. The default value is false.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then items can be picked from the finished goods inventory. If false, then items can't be picked from the finished goods inventory. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
  • Read Only: true
    Maximum Length: 255
    Value that indicates the type of planning that's used for the item. A list of accepted values is defined in the lookup type EGP_MATERIAL_PLANNING. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is set to Not Planned.
  • Maximum Length: 4000
    Indicates the attachment URL for the primary image of the item.
  • Read Only: true
    Maximum Length: 3
    Abbreviation that identifies the unit of measure that's used to determine pricing for an item. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Unit of Measures task.
  • Related Item Relationships
    Title: Related Item Relationships
    The Related Item Relationships resource manages relationship between two items.
  • Value that uniquely identifies the scheduled process that created the item.
  • Contains one of the following values: True or False. If True, then restrict the transactions of the item from the locator. If False, then don't restrict the transactions of the item from the locator. The default value is True.
  • Contains one of the following values: True or False. If True, then restrict the transactions of the item from the subinventory. If False, then don't restrict the transactions of the item from the subinventory. The default value is True. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
  • Number of days after the creation date before retesting the lot.
  • Contains one of the following values: true or false. If true, then the item is under revision control and it includes inventory attributes. If false, then the item isn't under revision control and it includes inventory attributes. The default value is False. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
  • Maximum Length: 30
    Value that indicates the sales product type. Domain values include Goods, Subscription, Coverage, and Training. A list of accepted values is defined in the lookup type QSC_SALES_PRODUCT_TYPE. Review the value for this attribute using the Manage Standard Lookups task in the Setup and Maintenance work area. The default value is Goods. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
  • Maximum Length: 3
    Secondary unit of measure of the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Units of Measures task.
  • Read Only: true
    Maximum Length: 255
    Value that indicates the number assigned to each unit of an item and is used to track the item. A list of accepted values is defined in the lookup type EGP_SERIAL_NUMBER_CONTROL_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is 1. For a list of attribute value interdependencies, refer to Interdependent Item Attributes.
  • Value that identifies the number assigned to each unit of an item and is used to track the item. A list of accepted values is defined in the lookup type EGP_SERIAL_NUMBER_CONTROL_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is 1.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then transactions on the item is restricted to the subinventory. If false, then transactions on the item isn't restricted to the subinventory. The default value is false.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item is eligible to be covered in a service contract. If false, then the item isn't eligible to be covered in a service contract. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
  • Number of days that each lot is active.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the application can ship the item to the customer. If false, then the application can't ship the item, for example, if the item is a service agreement. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
  • Spoke System Item Relationships
    Title: Spoke System Item Relationships
    The Spoke System Item Relationships resource manages the relationship between an internal item and spoke system item.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item can be stocked in inventory. If false, then the item can't be stocked in inventory. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
  • Value that indicates the physical area in a subinventory where you store material, such as a row, aisle, bin, or shelf. A list of accepted values is defined in the lookup type EGP_LOCATOR_CONTROL_CODE_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is 1.
  • Maximum Length: 30
    Unit of measure of the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Units of Measures task.
  • Trading Partner Item Relationships
    Title: Trading Partner Item Relationships
    The Trading Partner Item Relationships resource manages the trading partner item relationships that are relationships between internal items and trading partner items.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then transactions can be performed on the item. If false, then transactions can't be performed on the item. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
  • Maximum Length: 1
    Contains one of the following values: true or false. If true, then the item can be ordered on an internal requisition. If false, then item can't be ordered based on an internal requisition. The default value is false. For a list of attribute value interdependencies, see the topic Interdependent Item Attributes in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.
  • Read Only: true
    Maximum Length: 255
    Type of the item. A list of accepted values is defined in the lookup type EGP_ITEM_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
Nested Schema : Cross-Reference Relationships
Type: array
Title: Cross-Reference Relationships
The Cross-Reference Relationships resource manages the relationship between an internal item and item cross-references.
Show Source
Nested Schema : GTIN Relationships
Type: array
Title: GTIN Relationships
The GTIN Relationships resource manages the relationship between an internal item and GTIN.
Show Source
Nested Schema : Item Categories
Type: array
Title: Item Categories
The association of a category to a catalog or a child category to a parent category, such as the association of the Televisions category to the Summer catalog or to the Electronics category.
Show Source
Nested Schema : ItemDFF
Type: array
The Descriptive Flexfield for Items List of Values resource gets the descriptive flexfields associated with the item object.
Show Source
Nested Schema : Related Item Relationships
Type: array
Title: Related Item Relationships
The Related Item Relationships resource manages relationship between two items.
Show Source
Nested Schema : Spoke System Item Relationships
Type: array
Title: Spoke System Item Relationships
The Spoke System Item Relationships resource manages the relationship between an internal item and spoke system item.
Show Source
Nested Schema : Trading Partner Item Relationships
Type: array
Title: Trading Partner Item Relationships
The Trading Partner Item Relationships resource manages the trading partner item relationships that are relationships between internal items and trading partner items.
Show Source
Nested Schema : itemsLOV-CrossReferenceRelationships-item-response
Type: object
Show Source
Nested Schema : itemsLOV-GTINRelationships-item-response
Type: object
Show Source
Nested Schema : itemsLOV-ItemCategories-item-response
Type: object
Show Source
Nested Schema : itemsLOV-ItemDFF-item-response
Type: object
Show Source
Nested Schema : itemsLOV-RelatedItemRelationships-item-response
Type: object
Show Source
Nested Schema : itemsLOV-SpokeSystemItemRelationships-item-response
Type: object
Show Source
Nested Schema : itemsLOV-TradingPartnerItemRelationships-item-response
Type: object
Show Source
Back to Top