Get all structures
get
/fscmRestApi/resources/11.13.18.05/itemStructures
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:- AltKey: Find item structures according to the alternate key.
Finder Variables:- AlternateBOMDesignator; string; Value that identifies the alternate designator.
- ItemId; string; Value that uniquely identifies the item.
- OrganizationId; string; Value that uniquely identifies the organization.
- PrimaryKey: Find item structures according to the primary key.
Finder Variables:- BillSequenceId; integer; Value that uniquely identifies the structure. This is a read-only field that you can modify only if the resource is already modified.
- AltKey: Find item structures according to the alternate key.
-
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:- AlternateBOMDesignator; string; Alternate designator for the item structure.
- BillSequenceId; integer; Value that uniquely identifies the structure. This attribute is read-only, which can be modified only if the resource is already modified.
- ChangeNotice; string; Change order notice to which the service operation added all the structure component changes. This attribute is read-only.
- CommonBillSequenceId; integer; Value that uniquely identifies the common bill of materials.
- CommonItemNumber; string; Number that identifies the item for the common structure. This attribute is read-only.
- CommonOrganizationCode; string; Name of the organization for the common structure. This attribute is read-only.
- CreatedBy; string; User who created the structure.
- CreationDateTime; string; Date and time when the structure was created.
- Description; string; Description of the structure.
- EffectivityControl; integer; Value that indicates the way effectivity is controlled within a structure. Valid values include Date, Unit Number, or Serial Number.
- EffectivityControlValue; string; Value that indicates the method used to control effectivity in a structure. Values include Date, Unit Number, or Serial Number.
- ItemId; string; Value that uniquely identifies the part, item, product, or service.
- ItemNumber; string; Number that identifies a part, material, product, or service. This attribute is read-only, which can be modified for the create operation.
- LastUpdateDateTime; string; Date and time when the structure was most recently updated.
- LastUpdateLogin; string; Login of the user who most recently updated the item structure.
- LastUpdatedBy; string; User who most recently updated the structure.
- OrganizationCode; string; Abbreviation that identifies the name of an organizing unit in the internal or external organization structure of your enterprise. Organization structure provides the framework for performing legal reporting, financial control, and management reporting. This attribute is read-only, which can be modified for the create operation.
- OrganizationId; string; Value that uniquely identifies the organization.
- OriginalSystemReference; string; Value that indicates the authoring application responsible for managing the record. If it is empty, the record is managed by the user from the standard user interface.
- RequestId; integer; Request ID generated at import. Its use case is to verify import. The items are published based on the RequestID.
- SourceItemNumber; string; Number that identifies the source application item from which the structure is created. This attribute is read-only.
- SourceOrganizationCode; string; Abbreviation that identifies the source organization from which the structure is created. This attribute is read-only.
- StructureName; string; Name of the structure. This attribute is read-only, which can be modified for the create operation.
-
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: string
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: string
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:
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.
Root Schema : itemStructures
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:
ItemsThe items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
LinksThe 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:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : itemStructures-item-response
Type:
Show Source
object-
AlternateBOMDesignator: string
Title:
NameMaximum Length:80Alternate designator for the item structure. -
BillSequenceId: integer
Read Only:
trueValue that uniquely identifies the structure. This attribute is read-only, which can be modified only if the resource is already modified. -
ChangeNotice: string
Read Only:
trueChange order notice to which the service operation added all the structure component changes. This attribute is read-only. -
CommonBillSequenceId: integer
Value that uniquely identifies the common bill of materials.
-
CommonItemNumber: string
Title:
ItemRead Only:trueMaximum Length:300Number that identifies the item for the common structure. This attribute is read-only. -
CommonOrganizationCode: string
Read Only:
trueMaximum Length:18Name of the organization for the common structure. This attribute is read-only. -
Component: array
Components
Title:
ComponentsThe Components resource manages the details of a component within a structure. -
CreatedBy: string
Read Only:
trueMaximum Length:64User who created the structure. -
CreationDateTime: string
(date-time)
Read Only:
trueDate and time when the structure was created. -
Description: string
Title:
DescriptionMaximum Length:240Description of the structure. -
EffectivityControl: integer
Title:
Effectivity ControlValue that indicates the way effectivity is controlled within a structure. Valid values include Date, Unit Number, or Serial Number. -
EffectivityControlValue: string
Value that indicates the method used to control effectivity in a structure. Values include Date, Unit Number, or Serial Number.
-
Expansion: array
Expansions of Item Structures
Title:
Expansions of Item StructuresThe Expansions of Item Structures resource breaks apart each assembly or subassembly into it's component parts. -
ItemId: string
Maximum Length:
240Value that uniquely identifies the part, item, product, or service. -
ItemNumber: string
Number that identifies a part, material, product, or service. This attribute is read-only, which can be modified for the create operation.
-
LastUpdateDateTime: string
(date-time)
Read Only:
trueDate and time when the structure was most recently updated. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User who most recently updated the structure. -
LastUpdateLogin: string
Read Only:
trueMaximum Length:32Login of the user who most recently updated the item structure. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
OrganizationCode: string
Abbreviation that identifies the name of an organizing unit in the internal or external organization structure of your enterprise. Organization structure provides the framework for performing legal reporting, financial control, and management reporting. This attribute is read-only, which can be modified for the create operation.
-
OrganizationId: string
Maximum Length:
240Value that uniquely identifies the organization. -
OriginalSystemReference: string
Maximum Length:
50Value that indicates the authoring application responsible for managing the record. If it is empty, the record is managed by the user from the standard user interface. -
RequestId: integer
(int64)
Read Only:
trueRequest ID generated at import. Its use case is to verify import. The items are published based on the RequestID. -
SourceItemNumber: string
Title:
ItemRead Only:trueMaximum Length:300Number that identifies the source application item from which the structure is created. This attribute is read-only. -
SourceOrganizationCode: string
Read Only:
trueMaximum Length:18Abbreviation that identifies the source organization from which the structure is created. This attribute is read-only. -
StructureAttachments: array
Item Structure Attachments List of Values
Title:
Item Structure Attachments List of ValuesThe list of values includes details of the attachments for the structure header. For example, attachment document ID and last upload date. -
StructureDFF: array
Flexfields for Item Structures
Title:
Flexfields for Item StructuresThe Flexfields for Item Structures resource gets the descriptive flexfields associated with the item structure. -
StructureName: string
Name of the structure. This attribute is read-only, which can be modified for the create operation.
Nested Schema : Components
Type:
arrayTitle:
ComponentsThe Components resource manages the details of a component within a structure.
Show Source
Nested Schema : Expansions of Item Structures
Type:
arrayTitle:
Expansions of Item StructuresThe Expansions of Item Structures resource breaks apart each assembly or subassembly into it's component parts.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Item Structure Attachments List of Values
Type:
arrayTitle:
Item Structure Attachments List of ValuesThe list of values includes details of the attachments for the structure header. For example, attachment document ID and last upload date.
Show Source
Nested Schema : Flexfields for Item Structures
Type:
arrayTitle:
Flexfields for Item StructuresThe Flexfields for Item Structures resource gets the descriptive flexfields associated with the item structure.
Show Source
Nested Schema : itemStructures-Component-item-response
Type:
Show Source
object-
AbsoluteYield: number
Title:
Absolute YieldRead Only:trueRepresents the absolute yield of a component. This value equals to quantity times yield. -
AcdType: integer
Title:
Change ActionRead Only:trueDefault Value:1Identifies whether the component is being added, modified, or deleted in a change line. -
ACDTypeValue: string
Read Only:
trueMaximum Length:255Value that indicates if the substitute component is being added, modified, or deleted through a change line. -
AutoRequestMaterialFlag: boolean
Title:
Automatically Request MaterialMaximum Length:1Default Value:trueContains one of the following values: true or false. If true, then a move order is automatically created for a material in a work order release. If false, then a move order is not automatically created. The default value is true. -
BasisType: integer
Title:
BasisDefault Value:1Value that indicates if the option class quantity can be overridden by sales order. Valid values include None (can override) or Option Class (cannot override). -
BasisValue: string
Value that determines if the option class quantity can be overridden by the sales order. Valid values include None or Option Class.
-
BillSequenceId: integer
Value that uniquely identifies the structure.
-
ChangeId: integer
Identifies the change order to which the pending component has been added.
-
ChangeLineId: integer
Read Only:
trueDefault Value:-1Value that uniquely identifies the revised change line to which pending component is added. -
ChangeNotice: string
Read Only:
trueMaximum Length:255Change order notice to which the pending component is added. -
CheckATPFlag: boolean
Title:
Check ATPDefault Value:falseContains one of the following values: true or false. If true, then check the following when placing the demand: available to promise and capable to promise. If false, then do not check. The default value is true. -
Comments: string
Title:
CommentsMaximum Length:4000Comments about a component. -
CompAlternateBomDesignator: string
Title:
Formula NameMaximum Length:80Indicates the context formula for an ingredient. -
CompletionType: string
Title:
Completion TypeMaximum Length:30Indicates how the output item will be reported during work execution. -
CompletionTypeValue: string
Maximum Length:
255Value used by the manufacturer to define the completion type of products. The values are Automatic, Manual, or None. -
ComponentDFF: array
Flexfields for Components
Title:
Flexfields for ComponentsThe Flexfields for Components resource gets the descriptive flexfields associated with the component. -
ComponentItemClass: string
Read Only:
trueMaximum Length:255Class of the component item. This attribute is read-only and is not required for an update operation. -
ComponentItemId: string
Maximum Length:
240Value that uniquely identifies the item associated with the component. -
ComponentItemNumber: string
Number that indicates the item of a component. This attribute is read-only, which can be modified for the create operation.
-
ComponentSequenceId: integer
Value that uniquely identifies the component in a structure. This attribute is read-only and is not required for an update operation.
-
ComponentType: string
Title:
Material TypeMaximum Length:30Default Value:INPUTIndicates the type of material for the formula. -
ComponentTypeValue: string
Maximum Length:
255Indicates the type of material. The values include Ingredient or Product. -
ContributeToYield: string
Title:
Contribute to YieldMaximum Length:30Indicates whether the ingredient quantity should contribute to the yield. -
ContributeToYieldValue: string
Maximum Length:
255Value used by the manufacturer to define the contribution to the yield of ingredients. The values include Yes, No, or None. -
CreatedBy: string
Read Only:
trueMaximum Length:64User who created the component. -
CreationDateTime: string
(date-time)
Read Only:
trueDate and time when the structure was created. -
EndDateTime: string
(date-time)
Title:
End DateDate and time when a component in a structure ends. -
EnforceIntegerRequirementsValue: string
Value that is used by planning to generate the demand in integer quantities. Values include Round Up, Round Down, or None.
-
EnforceIntRequirements: number
Title:
Enforce Integer RequirementDefault Value:0Value that is used by Oracle Supply Planning Cloud to generate the demand in integer quantities. Valid values include Round Up, Round Down, or None. -
FindNumber: integer
Title:
Find NumberDefault Value:1Number used to locate a specific instance of an item in a structure. -
FromNumber: string
Title:
From End Item Unit NumberMaximum Length:30Number that indicates the item unit or serial from which the component is effective. It is valid only for unit or serial effective structures. Whether the value is unit or serial number depends on when the component is effective. -
ImplementationDateTime: string
(date-time)
Title:
Effective DateRead Only:trueDate and time when the component was implemented in production. It displays NULL for pending components. You can use this value to differentiate between pending and production components. -
IncludeOnShipDocsFlag: boolean
Title:
Include on Shipping DocumentsDefault Value:falseContains one of the following values: true or false. If true, then the component is displayed on shipping documentation. If false, then the component is not displayed. The default value is true. -
InstantiabilityCode: string
Title:
InstantiabilityMaximum Length:30Abbreviation that identifies the whether a component item is instantiable in an item structure. -
InstantiabilityValue: string
Value that indicates whether a component item is instantiable in an item structure.
-
ItemSequenceNumber: number
Title:
Item SequenceNumber that defines the sequence of components in a structure. -
LastUpdateDateTime: string
(date-time)
Read Only:
trueDate and time when the structure was most recently updated. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User who most recently updated the component. -
LastUpdateLogin: string
Read Only:
trueMaximum Length:32Login of the user who most recently updated the component. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
MaximumQuantity: number
Title:
Maximum QuantityValue that indicates the maximum order quantity. -
MinimumQuantity: number
Title:
Minimum QuantityValue that indicates the minimum order quantity. -
MutuallyExclusiveFlag: boolean
Title:
Mutually ExclusiveDefault Value:falseContains one of the following values: true or false. If true, then one or more options under this option class can be selected. If false, then you cannot select any options. The default value is true. -
OldComponentSequenceId: integer
Read Only:
trueReference to the production row when the component is modified in a change line. -
OptionalFlag: boolean
Title:
OptionalDefault Value:falseContains one of the following values: true or false. If true, then the component is optional for a structure. If false, then the component is not optional. The default value is true. -
OrganizationId: string
Maximum Length:
240Value that uniquely identifies the organization. -
PlanningPercent: number
Title:
Planning PercentDefault Value:100Distribution percentage for a component. It is used by forecast planning. -
PrimaryUOMCode: string
Maximum Length:
30Primary unit of measure for the item quantities. -
PrimaryUOMCodeValue: string
Maximum Length:
255Value that indicates the unit of measure of a component in a bill of materials. This may be different from the unit of measure of the item. For example, wooden panels used in the making of a table. The unit of measure of the wooden panel can be Box; however, when used as the component of a table, the unit of measurement can be Each. -
PrimaryUOMValue: string
Read Only:
trueMaximum Length:255Value in the primary unit of measure for the item quantities. -
ProductType: string
Title:
Product TypeMaximum Length:30Indicates the type of product for the formula output. -
ProductTypeValue: string
Maximum Length:
255Indicates the product type. The values include Primary, Co-Product, or By-Product. There's only one primary product in a formula. -
Quantity: number
Title:
QuantityDefault Value:1Quantity of component item that is used. -
QuantityRelatedFlag: boolean
Title:
Quantity RelatedDefault Value:falseValue that indicates whether a component is quantity related or not. If enabled, the application validates whether the specified quantity matches the number of reference designators on the component. -
ReferenceDesignator: array
Reference Designators
Title:
Reference DesignatorsThe Reference Designators resource manages the details of a reference designator. -
ReplacedBy: string
Maximum Length:
255Item number of the replacement component. -
ReplacedByFindNumber: integer
New find number value of the replacement component.
-
Replaces: string
Read Only:
trueMaximum Length:255Item number of the component that's being replaced. -
RequiredForRevenueFlag: boolean
Title:
Required for RevenueDefault Value:falseContains one of the following values: true or false. If true, then the component is required to recognize revenue before you ship the order. If false, then the component is not required. The default value is true. -
RequiredToShipFlag: boolean
Title:
Required to ShipDefault Value:falseContains one of the following values: true or false. If true, then the component is required to be shipped. If false, then the component is not required. The default value is true. -
SalesOrderBasisValue: string
Value that indicates to override the default quantity for the option class when a sales order is entered for components belonging to BOM Item Type option class. The option class quantities affect the mandatory standard components.
-
ShowInSales: number
Value that indicates if the component is visible in the sales application. Valid values include Yes, Hide Self, and Hide Self and Descendants.
-
ShowInSalesValue: string
Value that indicates if the component is visible in the sales application. Values include Yes, Hide Self, and Hide Self and Descendants.
-
SoBasis: number
Title:
Sales Order BasisDefault Value:2Value that indicates the basis to override the default quantity for the option class when a sales order is entered (the default), for components of the BOM Item Type option class. The option class quantities affect the mandatory standard components assigned to the option class. -
StartDateTime: string
(date-time)
Title:
Start DateDate and time when a component in a structure begins. -
SubstituteComponent: array
Substitute Components
Title:
Substitute ComponentsThe Substitute Components resource manages the details of a substitute component. -
SuggestedOperationSequence: integer
Title:
Suggested Operation SequenceSequence number suggested by a design engineer for a specific component operation in a manufacturing work definition. Example values are 10, 20, 30, and so on. -
SupplyType: string
Type of supply for components.
-
ToNumber: string
Title:
To End Item Unit NumberMaximum Length:30Number that identifies the item unit or serial up to which the component is effective. It is valid only for unit or serial effective structures. Whether the value is unit or serial number depends on when the component is effective. -
UsePlaceholderFlag: boolean
Title:
Use PlaceholderA flag indicating if this Option Class item data should be loaded into configurator models. -
WhereUsed: array
Where Used for Item Structures
Title:
Where Used for Item StructuresThe Where Used for Item Structures resource gets the items in which this structure is used. -
WipSupplyType: integer
Title:
Supply TypeType of supply for components. -
Yield: number
Title:
YieldDefault Value:1Value that indicates the planned or actual output of a process. Values include loss, increase, or no change in the planned or actual output quantity.
Nested Schema : Flexfields for Components
Type:
arrayTitle:
Flexfields for ComponentsThe Flexfields for Components resource gets the descriptive flexfields associated with the component.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Reference Designators
Type:
arrayTitle:
Reference DesignatorsThe Reference Designators resource manages the details of a reference designator.
Show Source
Nested Schema : Substitute Components
Type:
arrayTitle:
Substitute ComponentsThe Substitute Components resource manages the details of a substitute component.
Show Source
Nested Schema : Where Used for Item Structures
Type:
arrayTitle:
Where Used for Item StructuresThe Where Used for Item Structures resource gets the items in which this structure is used.
Show Source
Nested Schema : itemStructures-Component-ComponentDFF-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
ContextMaximum Length:30Descriptive flexfield context that references the component. -
__FLEX_Context_DisplayValue: string
Title:
ContextContext -
ComponentSequenceId: integer
Value that uniquely identifies the component in a structure. This attribute is read-only and is not required for an update operation.
-
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object-
href: string
Title:
hyperlink referenceThe URI to the related resource. -
kind: string
Title:
kindAllowed Values:[ "collection", "item", "describe", "other" ]The kind of the related resource. -
name: string
Title:
nameThe name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relationAllowed 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 : itemStructures-Component-ReferenceDesignator-item-response
Type:
Show Source
object-
ACDType: integer
Default Value:
1Value that indicates if the reference designator is being added, modified, or deleted through a change line. -
ACDTypeValue: string
Read Only:
trueMaximum Length:255Value that indicates if the substitute component is being added, modified, or deleted through a change line. -
ChangeLineId: integer
(int64)
Default Value:
-1Value that uniquely identifies the change line corresponding to the reference designator. -
ChangeNotice: string
Maximum Length:
10Change order notice to which the service operation added all the structure component changes. This attribute is used when the Needs Approval rule is run. -
CreationDateTime: string
(date-time)
Read Only:
trueDate and time when the structure was created. -
Description: string
Title:
DescriptionMaximum Length:240Description for the reference designator. -
LastUpdateDateTime: string
(date-time)
Read Only:
trueDate and time when the structure was most recently updated. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
ReferenceDesignator: string
Title:
Reference DesignatorMaximum Length:15Name of the reference designator. -
ReferenceDesignatorDFF: array
Flexfields for Reference Designators
Title:
Flexfields for Reference DesignatorsThe Flexfields for Reference Designators resource gets the descriptive flexfields associated with the reference designator. -
ReferenceDesignatorSequenceId: integer
(int64)
Value that uniquely identifies the reference designator. This attribute is read-only and is not required for an update operation.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Flexfields for Reference Designators
Type:
arrayTitle:
Flexfields for Reference DesignatorsThe Flexfields for Reference Designators resource gets the descriptive flexfields associated with the reference designator.
Show Source
Nested Schema : itemStructures-Component-ReferenceDesignator-ReferenceDesignatorDFF-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
ContextMaximum Length:30Descriptive flexfield context that references the reference designator. -
__FLEX_Context_DisplayValue: string
Title:
ContextContext -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
RefDesigSequenceId: integer
(int64)
Value that uniquely identifies the reference designator. This attribute is read-only and is not required for an update operation.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : itemStructures-Component-SubstituteComponent-item-response
Type:
Show Source
object-
ACDType: integer
Title:
Change ActionDefault Value:1Value that indicates if the substitute component is being added, modified, or deleted through a change line. -
ACDTypeValue: string
Maximum Length:
255Value that indicates if the substitute component is being added, modified, or deleted through a change line. -
ChangeNotice: string
Title:
Change NoticeMaximum Length:10Change order notice to which the service operation added all the structure component changes. This attribute is used when Needs Approval rule is run. -
CreationDateTime: string
(date-time)
Read Only:
trueDate and time when the structure was last created. -
EnforceIntegerRequirementsValue: string
Maximum Length:
255Generates the demand with quantity specified in integers. Used in supply chain planning. The values include Round Up, Round Down, or None. -
LastUpdateDateTime: string
(date-time)
Read Only:
trueDate and time when the structure was most recently updated. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
PrimaryUOMValue: string
Maximum Length:
255Primary unit of measure specified for the substitute component. -
Priority: integer
Priority specified for the substitute component.
-
Quantity: number
Title:
QuantityQuantity of the substitute component. -
SubstituteComponentDFF: array
Flexfields for Substitute Components
Title:
Flexfields for Substitute ComponentsThe Flexfields for Substitute Components resource gets the descriptive flexfields associated with the substitute component. -
SubstituteComponentId: integer
Value that uniquely identifies the item associated as the substitute component.
-
SubstituteComponentItemNumber: string
Maximum Length:
255Item number of the substitute component. -
SubstituteComponentSequenceId: integer
(int64)
Value that uniquely identifies the substitute component in a structure. This attribute is read-only and is not required for an update operation.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Flexfields for Substitute Components
Type:
arrayTitle:
Flexfields for Substitute ComponentsThe Flexfields for Substitute Components resource gets the descriptive flexfields associated with the substitute component.
Show Source
Nested Schema : itemStructures-Component-SubstituteComponent-SubstituteComponentDFF-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
ContextMaximum Length:30Descriptive flexfield context that references the substitute component. -
__FLEX_Context_DisplayValue: string
Title:
ContextContext -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
SubCompSequenceId: integer
(int64)
Value that uniquely identifies the substitute component in a structure. This attribute is read-only and is not required for an update operation.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : itemStructures-Component-WhereUsed-item-response
Type:
Show Source
object-
BasisValue: string
Maximum Length:
80Value that indicates how the component quantity is consumed in an assembly. Values include item and lot. -
ComponentBillSequenceId: integer
(int64)
Value that uniquely identifies the parent structure.
-
ComponentItemDescription: string
Maximum Length:
240Description of the item of a component. -
ComponentItemNumber: string
Maximum Length:
300Number that indicates the item of a component. -
ComponentPath: string
Maximum Length:
4000Value that represents the hierarchical path of a component item to the root item in a structure. -
ComponentSequenceId: integer
(int64)
Value that uniquely identifies the component in a structure.
-
EffectivityControlValue: string
Value that indicates the method used to control effectivity in a structure. Values include Date, Unit Number, or Serial Number.
-
EndDateTime: string
(date-time)
Date and time when a component in a structure ends.
-
FromSerialNumber: string
Maximum Length:
30Number that indicates the item serial from which the component is effective in a structure. It is valid only for serial effective structures. -
FromUnitNumber: string
Maximum Length:
30Number that indicates the item unit or serial from which the component is effective. It is valid only for unit effective structures. -
ItemClassName: string
Maximum Length:
250Name in metadata that is common to all items that share the category. -
ItemStatusValue: string
Maximum Length:
240Value that defines codes used to control the transaction activity of an item. For example, an item in active status can be customer-order enabled. -
ItemTypeValue: string
Maximum Length:
80Value that indicates grouping of all items of a particular category that share the same set of item attributes, used as a high-level grouping for processes. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
OrganizationCode: string
Abbreviation that identifies the name of an organizing unit in the internal or external organization structure of your enterprise. Organization structure provides the framework for performing legal reporting, financial control, and management reporting. This attribute is read-only, which can be modified for the create operation.
-
ParentBillSequenceId: integer
(int64)
Value that uniquely identifies the parent structure.
-
ParentItemNumber: string
Number that uniquely identifies the parent identifier for a part, material, product, or service.
-
Quantity: number
Quantity of a component in a structure.
-
StartDateTime: string
(date-time)
Date and time when a component in a structure begins.
-
StructureName: string
Name of the structure. This attribute is read-only, which can be modified for the create operation.
-
TopItemFlag: boolean
Maximum Length:
1Contains one of the following values: true or false. If true, then the item is the top item where this component is used. If false, then the item is not the top item where this component is used. The default value is false. -
ToSerialNumber: string
Maximum Length:
30Number that identifies the item serial up to which the component is effective in a structure. -
ToUnitNumber: string
Maximum Length:
30Number that identifies the item unit up to which the component is effective.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : itemStructures-Expansion-item-response
Type:
Show Source
object-
ATPCode: string
Read Only:
trueValue that indicates to check the following information when placing a demand: available to promise and capable to promise. -
ATPComponentFlag: boolean
Title:
Available to PromiseMaximum Length:1Value that indicates to include, in available to promise checking, additional components in the bill of material for ATO and PTO items. -
ATPComponentsCode: string
Read Only:
trueValue that indicates to check additional components in the bill of material of assemble-to-order and pick-to-order items when running the available to promise checks. -
ATPFlag: boolean
Title:
Available to PromiseMaximum Length:1Value that indicates to check available to promise and or capable to promise information when placing demand. -
AutoRequestMaterialFlag: boolean
Title:
Automatically Request MaterialMaximum Length:1Contains one of the following values: true or false. If true, then a move order is automatically created for a material in a work order release. If false, then a move order is not automatically created. The default value is true. -
BasisType: number
Title:
BasisValue that indicates that the option class quantity can be overridden by a sales order. Valid values include None, can override, or Option Class, can't override. -
BasisValue: string
Value that identifes that the option class quantity can be overridden by a sales order. Valid values include None or Option Class.
-
CheckATPFlag: boolean
Title:
Check ATPContains one of the following values: true or false. If true, then check the following when placing the demand: available to promise and capable to promise. If false, then do not check. The default value is true. -
Comments: string
Title:
CommentsMaximum Length:240Comments about a component. -
CommonComponentSequenceId: number
Value that uniquely identifies a component in a structure.
-
ComponentItemId: string
Maximum Length:
240Value that uniquely identifies the item associated with the component. -
ComponentItemNumber: string
Maximum Length:
40Number that identifies the item of a component. -
ComponentPath: string
Maximum Length:
4000Value that identifies the hierarchical path of a component item to the root item in a structure. -
ComponentSequenceId: number
Value that uniquely identifies a component in a structure.
-
ComponentSequencePath: string
Title:
PathMaximum Length:32767Value that identifies the hierarchical path or linage of a component item to the root item in a structure using the component sequence IDs. -
ComponentStructureItemTypeValue: string
Value that identifies whether the component sub-assembly is date effective or is model or unit effetive.
-
ComponentUOMCodeValue: string
Maximum Length:
255Value that identifies the component's own unit of measurement as used in a bill of materials. This may be different from the item's own unit of measurement. An example would be Wooden Panels used in the construction of a piece of furniure e.g. a Table. The wooden panel's unit of measurement may be "Box" , but it may have a unit of measurement "Each" when used as component of a table. -
CustomerOrderEnabledFlag: boolean
Title:
Customer Orders EnabledMaximum Length:1Value that indicates that an item is currently customer orderable. -
CustomerOrderFlag: boolean
Title:
Customer OrderedMaximum Length:1Value that indicates that an item can be ordered by external customers. -
EndDateTime: string
(date)
Title:
End DateDate and time when a component in a structure ends. -
EnforceIntegerRequirementsValue: string
Value that is used by Oracle Supply Planning to generate the demand in integer quantities. Valid values include Round Up, Round Down, or None.
-
EnforceIntRequirements: number
Title:
Enforce Integer RequirementValue that is used by Oracle Supply Planning to generate the demand in integer quantities. Valid values include Round Up, Round Down, or None. -
ExpandModelFlag: boolean
Read Only:
trueValue that identifies how model subassemblies are handled. If the the value is true, then the model subassemblies will be exploded. -
ExpandOption: integer
Read Only:
trueValue that identifies the expansion operation. The value include, 1 (All), 2 (Current), or 3 (Current and Future). The default option is 2 (Current). -
ExpansionDateTime: string
(date-time)
Read Only:
trueValue that identifies the structure expansion operation for date effective structures. -
ExpansionType: integer
Read Only:
trueValue that identifies the expansion type. The value include, 1 Optional, 2 Included, or 3 Both. The default value is 3 Both. -
ExtendedQuantity: number
Value that identifies the calculated total quantity of the component used in the whole explosion.
-
FindNumber: integer
Title:
Find NumberRead Only:trueAn attribute value that holds find number for the component. -
FromNumber: string
Title:
From End Item Unit NumberMaximum Length:30Number that identifies the item unit or serial from which the component is effective. It is valid only for unit or serial effective structures. Whether the value is unit or serial number depends on when the component is effective. -
FromSerialNumber: string
Read Only:
trueMaximum Length:30Number that identifies the item serial from which the component is effective in a structure. It's valid only for serial effective structures. -
FromUnitNumber: string
Read Only:
trueMaximum Length:30Number that identifies the item unit from which the component is effective. It is valid only for unit effective structures. -
ImplementationDate: string
(date)
Title:
Effective DateDate and time when the component was implemented in production. It displays NULL for pending components. You can use this value to differentiate between pending and production components. -
ImplementationOnlyFlag: boolean
Read Only:
trueValue that identifies how unimplemented components are handled. If the the value is true, then the unimplemented components will be left out of the explosion process. -
IncludeOnShipDocsFlag: boolean
Title:
Include on Shipping DocumentsContains one of the following values: true or false. If true, then the component is displayed on shipping documentation. If false, then the component is not displayed. The default value is true. -
InstantiabilityCode: string
Maximum Length:
30Abbreviation that identifies whether a component item is instantiable in an item structure. -
InstantiabilityValue: string
Value that indicates that a component item is instantiable in an item structure.
-
InternalOrderEnabledFlag: boolean
Title:
Transfer Orders EnabledMaximum Length:1Value indicating that an item can be ordered on an internal requisition. -
InternalOrderFlag: boolean
Title:
Internally TransferableMaximum Length:1Value indicating that an Item can be ordered internally. -
InverseQuantity: number
Value that identifies the inverse of an exact or specified quantity defined for a structure component.
-
ItemClassName: string
Name in metadata that is common to all items that share the category.
-
ItemSequenceNumber: number
Title:
Item SequenceNumber that idenfitifies the sequence of components in a structure. -
ItemStatus: string
Maximum Length:
30Value that identifies the codes used to control the transaction activity of an item. For example, an item in active status can be customer-order enabled. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
MaximumQuantity: number
Title:
Maximum QuantityValue that identifies the maximum order quantity. -
MinimumQuantity: number
Title:
Minimum QuantityValue that identifies the minimum order quantity. -
MutuallyExclusiveFlag: boolean
Title:
Mutually ExclusiveContains one of the following values: true or false. If true, then one or more options under this option class can be selected. If false, then you cannot select any options. The default value is true. -
OptionalFlag: boolean
Title:
OptionalContains one of the following values: true or false. If true, then the component is optional for a structure. If false, then the component is not optional. The default value is true. -
OrganizationCode: string
Abbreviation that identifies the name of an organizing unit in the internal or external organization structure of your enterprise. Organization structure provides the framework for performing legal reporting, financial control, and management reporting. This attribute is read-only, which can be modified for the create operation.
-
OrganizationId: string
Maximum Length:
240Value that uniquely identifies the organization. -
ParentBillSequenceId: integer
(int64)
Value that uniquely identifies the parent structure.
-
ParentCommonBillSequenceId: integer
(int64)
Value that uniquely identifies the parent bill structure.
-
ParentComponentSequencePath: string
Maximum Length:
32767Value that identifies the hierarchical path or linage of a parent component item to the root item in a structure using the component sequence IDs. -
ParentEffectivityControl: number
Abbreviation that identifies the way effectively is controlled within the parent of the structure.
-
ParentEffectivityControlValue: string
Value that identifies the way effectivety is controlled within the parent of the structure. The values include Date, Unit Number, or Serial Number.
-
ParentItemId: string
Maximum Length:
240Value that uniquely identifies the parent of an identifier for a part, material, product, or service that is unique as compared with other items, by the nature of its attributes. -
ParentItemNumber: string
Number that uniquely identifies the parent identifier for a part, material, product, or service.
-
ParentStructureDescription: string
Title:
DescriptionMaximum Length:240Value that identifies the description of a parent structure. -
ParentStructureItemTypeValue: string
Value that indicates whether the structure is date effective or is model or unit effetive.
-
ParentStructureName: string
Maximum Length:
255Value that identifies the name of a parent structure. -
PickComponentFlag: boolean
Title:
Pick ComponentsValue indicating that an item has a structure l with options, classes, or included items picked from finished goods inventory. -
PlanLevel: number
Value which indicates the depth of the node, row, in the exploded tree. For example, a value of 0 denotes that it is the root node.
-
PlanningPercentage: number
Title:
Planning PercentValue that identifies the distribution percentage for a component. It is used by forecast planning. -
PrimaryUomCode: string
Maximum Length:
3Value that identifies the primary unit of measure for the item quantities. -
PrimaryUOMValue: string
Maximum Length:
255Value that identifies the unit of measure of a component in a bill of materials. This may be different from the unit of measure of the item. For example, wooden panels used in the making of a table. The unit of measure of the wooden panel can be Box; however, when used as the component of a table, the unit of measurement can be Each. -
Quantity: number
Title:
QuantityValue that identifies quantity of a component in a structure. -
QuantityRelatedFlag: boolean
Title:
Quantity RelatedValue that indicates that a component is quantity related. If enabled, the application validates whether the specified quantity matches the number of reference designators on the component. -
ReplenishToOrderFlag: boolean
Title:
Assemble to OrderMaximum Length:1Value that indicates the generally built for sales order demand; a final assembly work order is created based on sales order details. -
RequiredForRevenueFlag: boolean
Title:
Required for RevenueContains one of the following values: true or false. If true, then the component is required to recognize revenue before you ship the order. If false, then the component is not required. The default value is true. -
RequiredToShipFlag: boolean
Title:
Required to ShipContains one of the following values: true or false. If true, then the component is required to be shipped. If false, then the component is not required. The default value is true. -
SalesOrderBasisValue: string
Value that indicates to override the default quantity for the option class when a sales order is entered for components belonging to BOM Item Type option class. The option class quantities affect the mandatory standard components.
-
SalesOrderTransactionFlag: boolean
Maximum Length:
1Value that identifies a reference to the source transaction definition that identifies the type of transactions within each application where a budgetary control transaction is originated. -
ShippableItemFlag: boolean
Title:
ShippableMaximum Length:1Value that indicates to ship an item to a customer. -
ShowInSales: number
Value that indicates that the component is visible in the sales application. Valid values include Yes, Hide Self, and Hide Self and Descendants.
-
ShowInSalesValue: string
Value that indicates that the component is visible in the sales application. Valid values include Yes, Hide Self, and Hide Self and Descendants.
-
SoBasis: number
Title:
Sales Order BasisValue that identifes the basis to override the default quantity for the option class when a sales order is entered, the default, for components of the BOM Item Type option class. The option class quantities affect the mandatory standard components assigned to the option class. -
StartDateTime: string
(date)
Title:
Start DateDate and time when a component in a structure begins. -
SuggestedOperationSequence: integer
Title:
Suggested Operation SequenceRead Only:trueAn attribute value that holds the suggested operation sequence. -
SupplyType: string
Value that identifies the type of supply for components.
-
ToNumber: string
Title:
To End Item Unit NumberMaximum Length:30Number that identifies the item unit or serial up to which the component is effective. It is valid only for unit or serial effective structures. Whether the value is unit or serial number depends on when the component is effective. -
TopBillSequenceId: string
Maximum Length:
256Value that uniquely identifies the bill sequence of the root item of the structure. -
TopItemId: string
Maximum Length:
256Value that uniquely identifies the root item for the explosion of the structure. -
TopItemNumber: string
Value that identifies the root item for the explosion of the structure.
-
UsePlaceholderFlag: boolean
An attribute that determines whether option class item data should be loaded into configurator models or not.
-
UserItemTypeValue: string
Maximum Length:
255Value that uniquely identifes a grouping of all items of a particular category that share the same set of item attributes, used as a high-level grouping for processes. For example, each account generator item type , such as FA account generator, contains a group of processes for determining how an accounting flexfield code combination is created. -
WipSupplyType: number
Title:
Supply TypeValue that identifies the type of supply for components. -
Yield: number
Title:
YieldValue that identifies the planned or actual output of a process. Values include loss, increase, or no change in the planned or actual output quantity.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : itemStructures-StructureAttachments-item-response
Type:
Show Source
object-
AttachedDocumentId: integer
(int64)
Title:
Attached Document IdUnique identifier for a document that's an attachment in the repository. -
CategoryName: string
Title:
CategoryMaximum Length:30Represents a component of a catalog used for classification of items. - ContentRepositoryFileShared: boolean
-
CreatedBy: string
Title:
Created ByRead Only:trueMaximum Length:255Name of the user who created the attachment associated with the item structure. -
CreatedByUserName: string
Title:
Created By User NameRead Only:trueUser name of the user who created the attachment associated with the item structure. -
CreationDate: string
(date-time)
Title:
Creation DateRead Only:trueDate on which the attachment was associated with the item structure. -
DatatypeCode: string
Title:
TypeMaximum Length:30Default Value:FILEUnique identifier for the data type of the attachment. -
Description: string
Title:
DescriptionMaximum Length:255Value that represents the description of the attachment. -
DmDocumentId: string
Maximum Length:
255Unique identifier for a document in the repository. -
DmFolderPath: string
Title:
Dm Folder PathMaximum Length:1000Value that represents the repository folder path of the attachment. -
DmVersionNumber: string
Maximum Length:
255Value that represents the version number of attachment in the repository. -
DocumentPreviewURL: string
Read Only:
trueMaximum Length:255Preview URL of the attachment. -
DocumentURL: string
Read Only:
trueValue that represents the URL of the attachment. -
DownloadInfo: string
Title:
DownloadInfoValue that represents the download information of the attachment. -
ErrorStatusCode: string
Title:
Error Status CodeValue that represents the error status associated with the attachment creation. -
ErrorStatusMessage: string
Title:
Error Status MessageValue that represents the error details associated with the attachment creation. -
ExpirationDate: string
(date-time)
Title:
Expiration DateValue that represents the expiration date of the attachment associated with the item structure. -
FileContents: string
(byte)
Title:
File ContentsContents of the file attachment. -
FileName: string
Title:
File NameMaximum Length:2048Value the represents the name of a file of the attachment. -
FileUrl: string
Title:
File UrlValue that represents the URL of the attachment file. -
LastUpdateDate: string
(date-time)
Title:
Last Update DateRead Only:trueIndicates the date and time of the last update of the attachment. -
LastUpdatedBy: string
Title:
Last Updated ByRead Only:trueMaximum Length:255Indicates the last user who updated the attachment. -
LastUpdatedByUserName: string
Title:
Last Updated By UserRead Only:trueIndicates the user name of the user who updated the attachment. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
Title: string
Title:
TitleValue that represents the title of the attachment. -
UploadedFileContentType: string
Title:
Uploaded File Content TypeValue that represents the content type of the file attachments associated with the item structure. -
UploadedFileLength: integer
Title:
File SizeValue that indicates the length of the file attachment associated with the item structure. -
UploadedFileName: string
Title:
Uploaded File NameValue that indicates the name of the file attachment associated with the item structure. -
UploadedText: string
Title:
Uploaded TextContents of the text file that's attached. -
Uri: string
Title:
UriMaximum Length:4000Value the represents the Uniform Resource Identifier (URI) appended to the base URI derived from the endpoint associated with application identified by the MODULE_ID. -
Url: string
Title:
UrlMaximum Length:4000Value that represents the URL for the attachment. -
UserName: string
Title:
User NameRead Only:trueMaximum Length:255Value that represents the name of user who uploads the attachment.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : itemStructures-StructureDFF-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
ContextMaximum Length:30Descriptive flexfield context that references the structure. -
__FLEX_Context_DisplayValue: string
Title:
ContextContext -
BillSequenceId: integer
Value that uniquely identifies the structure. This attribute is read-only, which can be modified only if the attribute is already modified.
-
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Examples
This example describes how to get all structures.
Example 1 cURL Command
Use the following cURL command to submit a request on the REST resource:
curl -u username:password "https://servername/fscmRestApi/resources/version/itemStructures"
Example 1 Response Body
The following shows an example of the response body in JSON format.
{
"items": [
{
"BillSequenceId": 6924,
"ChangeNotice": null,
"OrganizationId": "604",
"OrganizationCode": "P4",
"ItemId": "1148",
"ItemNumber": "SB21211",
"AlternateBOMDesignator": "Primary",
"StructureName": "Primary",
"Description": null,
"EffectivityControl": 1,
"EffectivityControlValue": "Date",
"CommonItemNumber": "SB21211",
"CommonOrganizationCode": "P4",
"SourceItemNumber": "SB21211",
"SourceOrganizationCode": "P4",
"CreationDateTime": "1998-01-24T12:43:41+00:00",
"LastUpdateDateTime": "1998-01-24T12:43:41+00:00",
"OriginalSystemReference": null,
...
},
...
],
...
}
Example 2 cURL Command
Use the following cURL command to submit a request on the REST resource to get all itemStructures of one speicific item:
curl -u username:password "https://servername/fscmRestApi/resources/version/itemStructures?q=ItemNumber=JUN26_PIM001"
Example 2 Response Body
The following shows an example of the response body in JSON format.
{
"items": [
{
"BillSequenceId": 300100152396998,
"ChangeNotice": null,
"OrganizationId": "204",
"OrganizationCode": "V1",
"ItemId": "300100152396951",
"ItemNumber": "JUN26_PIM001",
"AlternateBOMDesignator": "EBOM_KM",
"StructureName": "EBOM_KM",
"Description": "test",
"EffectivityControl": 1,
"EffectivityControlValue": "Date",
"CommonItemNumber": "JUN26_PIM001",
"CommonOrganizationCode": "V1",
"SourceItemNumber": "JUN26_PIM001",
"SourceOrganizationCode": "V1",
"CreationDateTime": "2018-06-26T02:48:27.800+00:00",
"LastUpdateDateTime": "2018-06-26T02:49:28.539+00:00",
"OriginalSystemReference": null,
...
},
...
],
...
}