Get one item
get
/fscmRestApi/resources/11.13.18.05/itemsLOV
Request
Query Parameters
-
expand: string
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).
-
fields: string
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 -
finder: string
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 Get all items
Finder Variables- ItemId; integer; 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.
- OrganizationId; integer; Find items according to the specified primary key criteria.
- PrimaryKey Get all items
-
limit: integer
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.
-
links: string
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 -
offset: integer
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.
-
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
-
orderBy: string
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
-
q: string
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:- AllowMaintenanceAssetFlag; boolean; 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.
- ApprovalStatus; string; 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.
- AssembleToOrderFlag; boolean; 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 Using Product Master Data Management guide.
- AssetTrackedFlag; boolean; 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.
- AutoCreatedConfigurationFlag; boolean; 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 Using Product Master Data Management guide.
- BOMItemType; number; 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.
- BackToBackEnabledFlag; boolean; 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.
- BaseItemId; integer; 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 Using Product Master Data Management guide.
- CreateFixedAsset; string; 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.
- CreatedBy; string; Name of the user who created the item.
- CreationDate; string; Date when the user created the item.
- CurrentPhaseCode; string; 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.
- CustomerOrderEnabledFlag; boolean; 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 Using Product Master Data Management guide.
- CustomerOrderFlag; boolean; 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 Using Product Master Data Management guide.
- EffectivityControl; number; 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 Using Product Master Data Management guide.
- EnableGenealogyTrackingFlag; boolean; 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.
- EnableIotFlag; boolean; 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.
- InternallyTransferableFlag; boolean; 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 Using Product Master Data Management guide.
- InventoryItemStatusCode; string; 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.
- ItemClass; string; 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.
- ItemClassId; integer; Value that uniquely identifies the item class.
- ItemDefinitionOrgId; integer; Value that uniquely identifies the definition organization associated with the item.
- ItemDescription; string; Description of the part, item, product, or service.
- ItemId; integer; Value that uniquely identifies the part, item, product, or service.
- ItemNumber; string; Name or number of the part, item, product, or service.
- ItemStatusValue; string; 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.
- ItemType; string; 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.
- Keyword; string; Value that represents a string of characters used for searching using keywords.
- LastUpdateDate; string; Date and time when the user most recently updated the item.
- LastUpdatedBy; string; User who most recently updated the item.
- LotControlCode; number; 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.
- MaterialTransactionEnabledFlag; boolean; 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 Using Product Master Data Management guide.
- OrderManagementIndivisibleFlag; boolean; 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 Using Product Master Data Management guide
- OrganizationCode; string; Abbreviation that identifies the organization. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task.
- OrganizationId; integer; 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.
- OutsideProcessServiceFlag; boolean; 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.
- PickComponentsFlag; boolean; 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 Using Product Master Data Management guide.
- PlanningMethodValue; string; 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.
- PrimaryImageURL; string; Indicates the attachment URL for the primary image of the item.
- PrimaryUOMCode; string; 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.
- RequestId; integer; Value that uniquely identifies the scheduled process that created the item.
- RestrictSubinventoriesFlag; boolean; 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 Using Product Master Data Management guide.
- RevisionQuantityControlFlag; boolean; 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 Using Product Master Data Management guide.
- SalesProductType; string; 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 Using Product Master Data Management guide.
- SerialGenerationValue; string; 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.
- SerialNumberControlCode; number; 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.
- ServiceableProductFlag; boolean; 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 Using Product Master Data Management guide.
- ShippableFlag; boolean; 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 Using Product Master Data Management guide.
- StockEnabledFlag; boolean; 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 Using Product Master Data Management guide.
- TransactionEnabledFlag; boolean; 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 Using Product Master Data Management guide.
- TransferOrdersEnabledFlag; boolean; 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 Using Product Master Data Management guide.
- UserItemTypeValue; string; 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.
-
totalResults: boolean
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
-
Metadata-Context:
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".
-
REST-Framework-Version:
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 TopResponse
Supported Media Types
- application/json
Default Response
The following table describes the default response for this task.
Headers
-
Metadata-Context(required):
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".
-
REST-Framework-Version(required):
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.
Root Schema : itemsLOV
Type:
Show Source
object
-
count(required): integer
The number of resource instances returned in the current range.
-
hasMore(required): boolean
Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
-
items: array
Items
Title:
Items
The items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
Links
The link relations associated with the resource instance. -
offset(required): integer
The offset value used in the current page.
-
totalResults: integer
The estimated row count when "?totalResults=true", otherwise the count is not included.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : itemsLOV-item-response
Type:
Show Source
object
-
AllowMaintenanceAssetFlag: boolean
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. -
ApprovalStatus: string
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. -
AssembleToOrderFlag: boolean
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 Using Product Master Data Management guide. -
AssetTrackedFlag: boolean
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. -
AutoCreatedConfigurationFlag: boolean
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 Using Product Master Data Management guide. -
BackToBackEnabledFlag: boolean
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. -
BaseItemId: integer
(int64)
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 Using Product Master Data Management guide.
-
BOMItemType: number
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.
-
CreatedBy: string
Maximum Length:
64
Name of the user who created the item. -
CreateFixedAsset: string
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. -
CreationDate: string
(date-time)
Read Only:
true
Date when the user created the item. -
CrossReferenceRelationships: array
Cross-Reference Relationships
Title:
Cross-Reference Relationships
The Cross-Reference Relationships resource manages the relationship between an internal item and item cross-references. -
CurrentPhaseCode: string
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. -
CustomerOrderEnabledFlag: boolean
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 Using Product Master Data Management guide. -
CustomerOrderFlag: boolean
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 Using Product Master Data Management guide. -
EffectivityControl: number
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 Using Product Master Data Management guide.
-
EnableGenealogyTrackingFlag: boolean
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. -
EnableIotFlag: boolean
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. -
GTINRelationships: array
GTIN Relationships
Title:
GTIN Relationships
The GTIN Relationships resource manages the relationship between an internal item and GTIN. -
InternallyTransferableFlag: boolean
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 Using Product Master Data Management guide. -
InventoryItemStatusCode: string
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. -
ItemCategories: array
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. -
ItemClass: string
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. -
ItemClassId: integer
(int64)
Read Only:
true
Value that uniquely identifies the item class. -
ItemDefinitionOrgId: integer
(int64)
Read Only:
true
Value that uniquely identifies the definition organization associated with the item. -
ItemDescription: string
Read Only:
true
Maximum Length:240
Description of the part, item, product, or service. -
ItemDFF: array
ItemDFF
The Descriptive Flexfield for Items List of Values resource gets the descriptive flexfields associated with the item object.
-
ItemId: integer
(int64)
Read Only:
true
Value that uniquely identifies the part, item, product, or service. -
ItemNumber: string
Read Only:
true
Maximum Length:300
Name or number of the part, item, product, or service. -
ItemStatusValue: string
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. -
ItemType: string
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. -
Keyword: string
Read Only:
true
Maximum Length:1000
Value that represents a string of characters used for searching using keywords. -
LastUpdateDate: string
(date-time)
Read Only:
true
Date and time when the user most recently updated the item. -
LastUpdatedBy: string
Maximum Length:
64
User who most recently updated the item. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
LotControlCode: number
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.
-
MaterialTransactionEnabledFlag: boolean
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 Using Product Master Data Management guide. -
OrderManagementIndivisibleFlag: boolean
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 Using Product Master Data Management guide -
OrganizationCode: string
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. -
OrganizationId: integer
(int64)
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. -
OutsideProcessServiceFlag: boolean
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. -
PickComponentsFlag: boolean
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 Using Product Master Data Management guide. -
PlanningMethodValue: string
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. -
PrimaryImageURL: string
Maximum Length:
4000
Indicates the attachment URL for the primary image of the item. -
PrimaryUOMCode: string
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. -
RelatedItemRelationships: array
Related Item Relationships
Title:
Related Item Relationships
The Related Item Relationships resource manages relationship between two items. -
RequestId: integer
(int64)
Value that uniquely identifies the scheduled process that created the item.
-
RestrictSubinventoriesFlag: boolean
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 Using Product Master Data Management guide.
-
RevisionQuantityControlFlag: boolean
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 Using Product Master Data Management guide.
-
SalesProductType: string
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 Using Product Master Data Management guide. -
SerialGenerationValue: string
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. -
SerialNumberControlCode: number
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.
-
ServiceableProductFlag: boolean
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 Using Product Master Data Management guide. -
ShippableFlag: boolean
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 Using Product Master Data Management guide. -
SpokeSystemItemRelationships: array
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. -
StockEnabledFlag: boolean
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 Using Product Master Data Management guide. -
TradingPartnerItemRelationships: array
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. -
TransactionEnabledFlag: boolean
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 Using Product Master Data Management guide. -
TransferOrdersEnabledFlag: boolean
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 Using Product Master Data Management guide. -
UserItemTypeValue: string
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 : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
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:
Show Source
object
-
ApplicableOrganizationCode: string
Maximum Length:
18
Abbreviation that identifies the organization. -
ApplicableOrganizationId: integer
(int64)
Value that uniquely identifies the organization.
-
ApplyToAllOrganizationFlag: boolean
Title:
Organization Independent
Maximum Length:1
Default Value:true
Contains one of the following values: true or false. If true, then the cross-reference is applicable to all the organizations. If false, then it's not. The default value is true. -
CreatedBy: string
Read Only:
true
Maximum Length:64
User who created the cross-reference relationship. -
CreationDateTime: string
(date-time)
Read Only:
true
Date and time when the user created the cross-reference relationship. -
CrossReference: string
Title:
Value
Maximum Length:255
Value that identifies the cross-reference. -
CrossReferenceType: string
Maximum Length:
80
Type of the cross-reference. A list of accepted values is defined in the lookup type EGP_ITEM_XREF_TYPES. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. There is no default value. -
InventoryItemId: integer
Value that uniquely identifies an item.
-
Item: string
Maximum Length:
300
Name or number of the part, item, product, or service. -
ItemRelationshipId: integer
(int64)
Value that uniquely identifies the cross-reference relationship.
-
LastUpdateDateTime: string
(date-time)
Read Only:
true
Date when the user most recently updated the cross-reference relationship. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
User who most recently updated the cross-reference relationship. -
LastUpdateLogin: string
Read Only:
true
Maximum Length:32
Login that the user used when updating the cross-reference relationship. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
MasterOrganizationCode: string
Maximum Length:
18
Abbreviation that identifies the master organization of the item for which the cross-reference relationship is defined. -
MasterOrganizationId: integer
Value that uniquely identifies the master organization of the item for which the cross-reference relationship is defined.
-
RelationshipDescription: string
Title:
Description
Maximum Length:240
Description of the cross-reference relationship.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object
-
href: string
Title:
hyperlink reference
The URI to the related resource. -
kind: string
Title:
kind
Allowed Values:[ "collection", "item", "describe", "other" ]
The kind of the related resource. -
name: string
Title:
name
The name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relation
Allowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]
The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object
-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Nested Schema : itemsLOV-GTINRelationships-item-response
Type:
Show Source
object
-
CreatedBy: string
Read Only:
true
Maximum Length:64
User who created the GTIN relationship. -
CreationDateTime: string
(date-time)
Read Only:
true
Date and time when the user created the GTIN relationship. -
EPCGTINSerial: number
Title:
EPC or GTIN Serial
Value that identifies the electronic product code or the GTIN serial number. -
GTIN: string
Title:
GTIN
Maximum Length:255
Number that identifies the global trade item. -
InventoryItemId: integer
Value that uniquely identifies an item.
-
Item: string
Maximum Length:
300
Name or number of the part, item, product, or service. -
ItemRelationshipId: integer
(int64)
Value that uniquely identifies the GTIN relationship.
-
LastUpdateDateTime: string
(date-time)
Read Only:
true
Date when the user most recently updated the GTIN relationship. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
User who most recently updated the GTIN relationship. -
LastUpdateLogin: string
Read Only:
true
Maximum Length:32
Login that the user used when updating the GTIN relationship. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
OrganizationCode: string
Maximum Length:
18
Abbreviation that identifies the organization. -
OrganizationId: integer
Value that uniquely identifies the organization.
-
PartyName: string
Title:
Name
Maximum Length:360
Name of the party. -
PartyType: string
Maximum Length:
255
Type of the party. -
RegistryId: string
Title:
Registry ID
Maximum Length:30
Value that uniquely identifies the party. -
RelationshipDescription: string
Title:
GTIN Description
Maximum Length:240
Description of the GTIN relationship. -
RevisionCode: string
Title:
Revision Code
Maximum Length:18
Abbreviation that identifies the revision of the item. -
UOM: string
Title:
UOM Name
Maximum Length:25
Unit of measure for the GTIN relationship.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : itemsLOV-ItemCategories-item-response
Type:
Show Source
object
-
AltItemCatCode: string
Maximum Length:
40
Abbreviation that identifies the item catalog. -
CategoryCode: string
Maximum Length:
255
A unique code that represents a component of the catalog used for classification of items. -
CategoryId: integer
(int64)
Title:
Category
Value that uniquely identifies the category. -
CategoryName: string
Name of the category.
-
CreatedBy: string
Read Only:
true
Maximum Length:64
User who created the item category assignment. -
CreationDateTime: string
(date-time)
Read Only:
true
Date and time of the creation of the item catalog category assignment. -
EndDate: string
(date)
Date when the item association ends. The end date can't be specified for functional area catalogs, except for the catalog assigned to the service logistics functional area.
-
InventoryItemId: integer
(int64)
Read Only:
true
Value that uniquely identifies the part, item, product, or service. -
ItemCatalog: string
Name of the item catalog.
-
ItemCategoryAssignmentId: integer
(int64)
Value that uniquely identifies the item category assignment.
-
ItemCategoryHierarchyCode: string
Read Only:
true
Value that represents category hierarchy using category codes. -
ItemCategoryHierarchyName: string
Read Only:
true
Value that represents category hierarchy using category names. -
ItemCategoryId: integer
(int64)
Title:
Catalog
Value that uniquely identifies the category -
ItemId: integer
(int64)
Value that uniquely identifies the part, item, product, or service.
-
LastUpdateDateTime: string
(date-time)
Read Only:
true
Date and time when the user most recently updated the item-category association. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
User who most recently updated the item-category association. -
LastUpdateLogin: string
Read Only:
true
Maximum Length:32
Login that the user used when updating the item-category association.. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
ObjectVersionNumber: integer
(int32)
This value is set to value of 1 when the item is created and incremented every time the item is updated.
-
OrganizationId: integer
(int64)
Read Only:
true
A unique identifier for an organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting. -
OrganizationId1: integer
(int64)
A unique identifier for an organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting.
-
RequestId: integer
(int64)
The request ID generated at import. Its use case is to verify the import. The items are published based on RequestID.
-
SequenceNumber: integer
(int32)
Value that indicates the sequence number of the item category assignments.
-
StartDate: string
(date)
Date when the item association begins. The start date can't be specified for functional area catalogs, except for the catalog assigned to the service logistics functional area.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : itemsLOV-ItemDFF-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Context
Maximum Length:30
-
__FLEX_Context_DisplayValue: string
Title:
Context
-
InventoryItemId: integer
(int64)
Title:
Item
-
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
OrganizationId: integer
(int64)
Title:
Organization
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : itemsLOV-RelatedItemRelationships-item-response
Type:
Show Source
object
-
CreatedBy: string
Read Only:
true
Maximum Length:64
User who created the related item relationship. -
CreationDateTime: string
(date-time)
Read Only:
true
Date and time when the user created the related item relationship. -
EndDateTime: string
(date-time)
Title:
End Date
Date when the related item relationship becomes ineffective. -
FromInventoryItemId: integer
Value that uniquely identifies the from item in the related item relationship.
-
FromItem: string
Maximum Length:
255
Value that identifies the from item in the related item relationship. -
FromItemApprovalStatus: string
Read Only:
true
Maximum Length:255
Approval status of the from item in the related item relationship. -
FromItemClass: string
Read Only:
true
Maximum Length:255
Item class of the from item in the related item relationship. -
FromItemDescription: string
Read Only:
true
Maximum Length:240
Description of the from item in the related item relationship. -
FromItemLifecyclePhase: string
Read Only:
true
Maximum Length:255
Lifecycle phase of the from item in the related item relationship. -
FromItemPrimaryUOM: string
Read Only:
true
Maximum Length:255
Primary unit of measure of the from item in the related item relationship. -
FromItemStatus: string
Read Only:
true
Maximum Length:255
Status of the from item in the related item relationship. -
ItemRelationshipId: integer
(int64)
Value that uniquely identifies the related item relationship.
-
LastUpdateDateTime: string
(date-time)
Read Only:
true
Date when the user most recently updated the related item relationship. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
User who most recently updated the related item relationship. -
LastUpdateLogin: string
Read Only:
true
Maximum Length:32
Login that the user used when updating the related item relationship. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
MasterControlledFlag: boolean
Title:
Controlled At
Maximum Length:1
Default Value:true
Contains one of the following values: true or false. If true, then the relationship is master controlled. If false, the relationship is organization controlled. The default value is true. -
OrganizationCode: string
Maximum Length:
255
Abbreviation that identifies the organization. -
OrganizationId: integer
Value that uniquely identifies the organization.
-
PlanningEnabledFlag: boolean
Title:
Planning Enabled
Maximum Length:1
Contains one of the following values: true or false. If true, then planning is enabled for the relationship. If false, planning isn't enabled. The default value is false. -
Rank: integer
(int64)
Title:
Rank
Rank of the related item relationship. -
ReciprocalFlag: boolean
Title:
Reciprocal
Maximum Length:1
Contains one of the following values: true or false. If true, then the relationship is mutual. If false, the relationship isn't mutual. The default value is false. -
RelationshipDescription: string
Maximum Length:
240
Description of the related item relationship. -
RelationshipType: string
Maximum Length:
255
Type of the related item relationship. A list of accepted values is defined in the lookup type EGP_RELATIONSHIP_TYPES. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is Null. -
StartDateTime: string
(date-time)
Date when the related item relationship becomes effective.
-
ToInventoryItemId: integer
Value that uniquely identifies the to item in the related item relationship.
-
ToItem: string
Maximum Length:
255
Value that identifies the to item in the related item relationship. -
ToItemApprovalStatus: string
Read Only:
true
Maximum Length:255
Approval status of the to item in the related item relationship. -
ToItemClass: string
Read Only:
true
Maximum Length:255
Item class of the to item in the related item relationship. -
ToItemDescription: string
Read Only:
true
Maximum Length:240
Description of the to item in the related item relationship. -
ToItemLifecyclePhase: string
Read Only:
true
Maximum Length:255
Lifecycle phase of the to item in the related item relationship. -
ToItemPrimaryUOM: string
Read Only:
true
Maximum Length:255
Primary unit of measure of the to item in the related item relationship. -
ToItemStatus: string
Read Only:
true
Maximum Length:255
Status of the to item in the related item relationship.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : itemsLOV-SpokeSystemItemRelationships-item-response
Type:
Show Source
object
-
CreatedBy: string
Read Only:
true
Maximum Length:64
User who created the spoke system item relationship. -
CreationDateTime: string
(date-time)
Read Only:
true
Date and time when the user created the spoke system item relationship. -
EndDateTime: string
(date-time)
Date when the spoke system item relationship becomes ineffective.
-
InventoryItemId: integer
Value that uniquely identifies an item.
-
Item: string
Maximum Length:
300
Name or number of the part, item, product, or service. -
ItemRelationshipId: integer
(int64)
Value that uniquely identifies the spoke system item relationship.
-
LastUpdateDateTime: string
(date-time)
Read Only:
true
Date and time when the user most recently updated the spoke system item relationship. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
User who most recently updated the spoke system item relationship. -
LastUpdateLogin: string
Read Only:
true
Maximum Length:32
Login that the user used when updating the spoke system item relationship. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
OrganizationCode: string
Maximum Length:
18
Abbreviation that identifies the organization. -
OrganizationId: integer
Value that uniquely identifies the organization.
-
RelationshipDescription: string
Title:
Spoke System Item Description
Maximum Length:240
Description of the spoke system item relationship. -
SpokeSystemCode: string
Maximum Length:
255
Abbreviation that identifies the spoke system. -
SpokeSystemId: integer
Title:
Spoke System
Value that uniquely identifies the spoke system. -
SpokeSystemItem: string
Title:
Spoke System Item
Maximum Length:255
Name or number of the spoke system item. -
StartDateTime: string
(date-time)
Date and time when the spoke system item relationship becomes effective.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : itemsLOV-TradingPartnerItemRelationships-item-response
Type:
Show Source
object
-
CompetitorItemRelationshipType: string
Maximum Length:
255
Type of competitor for the item relationship. -
CreatedBy: string
Read Only:
true
Maximum Length:64
User who created the trading partner item relationship. -
CreationDateTime: string
(date-time)
Read Only:
true
Date and time when the user created the trading partner item relationship. -
CustomerItemRelationshipRank: integer
Title:
Rank
Rank used within the customer item relationship. -
EndDateTime: string
(date-time)
Date when the trading partner item relationship becomes ineffective.
-
InventoryItemId: integer
Value that uniquely identifies an item.
-
Item: string
Maximum Length:
255
Name or number of the part, item, product, or service. -
ItemRelationshipId: integer
(int64)
Value that uniquely identifies the trading partner item relationship.
-
LastUpdateDateTime: string
(date-time)
Read Only:
true
Date when the user most recently updated the trading partner item relationship. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
User who most recently updated the trading partner item relationship. -
LastUpdateLogin: string
Read Only:
true
Maximum Length:32
Login that the user used when updating the trading partner item relationship. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
OrganizationCode: string
Maximum Length:
255
Abbreviation that identifies the organization. -
OrganizationId: integer
Value that uniquely identifies the organization.
-
RegistryId: string
Maximum Length:
255
Value that uniquely identifies the party. -
RelationshipDescription: string
Maximum Length:
240
Description of the trading partner item relationship. -
RelationshipStatus: string
Maximum Length:
255
Status of the trading partner item relationship. -
StartDateTime: string
(date-time)
Date when the trading partner item relationship becomes effective.
-
TradingPartnerId: string
Maximum Length:
255
Value that uniquely identifies the trading partner. -
TradingPartnerItemId: integer
(int64)
Value that uniquely identifies the trading partner item.
-
TradingPartnerItemNumber: string
Maximum Length:
255
Number that identifies a trading partner item, such as supplier item, customer item, competitor item, and manufacturer part number. -
TradingPartnerName: string
Maximum Length:
255
Name of the trading partner. -
TradingPartnerType: string
Maximum Length:
255
Type of the trading partner.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source