Integration with Other Applications > Introduction to Windchill ESI > Integrating Windchill ESI With Oracle Applications > Parts
  
Parts
Windchill ESI allows you to publish parts created and changed within Windchill PDMLink to a distribution target such as Oracle Applications. You can configure the Windchill PDMLink system to publish particular attributes of the parts. The Windchill PDMLink part information is used to create a part in the distribution target.
Windchill ESI passes the following part-associated attributes from Windchill PDMLink to the EAI software components:
• Number
• Whether the part is a phantom part or not
• Default Unit
• Control Characteristics
• Type
• Name
• Source
• Version
• Iteration
• Date Effectivity
• Last Changed By
• Distribution Targets
• Serial Effectivity
• Lot Effectivity
• Lifecycle State
• View
• Storage Location
• Previously Published Part Version
Once the part data has been sent from Windchill PDMLink, the EAI software components map the Windchill PDMLink part attributes to Oracle Applications object attributes. The following table shows the mapping of Windchill PDMLink part attributes to Oracle Applications object attributes:
Windchill Part to Oracle Applications Item Attribute Mapping
Windchill Part Attribute
Oracle Applications Object Attribute
Number
Item Number
Default Unit
Primary Unit of Measure
Part Type
User Item Type using Template
Date Effectivity
Item’s Revision Effectivity Date
Name
Item Description
Version
Revision Level
Source
General planning Make or Buy
Distribution Target
Organization
* 
If you create a new part-associated attribute then you must map it. If additional part-associated attributes are available consult with your system administrator for mapping details.
If Windchill MPMLink is installed and the Publish Common Enterprise Data Information preference has been turned on, then version information from Windchill does not come from the part, but from the associated Enterprise Data.
The Windchill PDMLink part iteration is passed to the EAI software components; however, the attribute is not sent to the distribution target. If the distribution target is capable of handling Windchill PDMLink part iterations, the EAI software components can be extended to pass the information to the distribution target; however, the out-of-the-box Oracle Applications system does not currently have an attribute that can handle iteration information.
The attribute Distribution Targets (in the elements Destination and TargetID that appear in the ESI response) identifies the distribution target in which the part should be created or changed. The EAI software components use this information to communicate with the correct distribution target and pass organization information to it.
Some attributes that are passed from Windchill PDMLink are passed to the distribution target from the EAI software components without transformation; however, there are a few attributes that contain values that are either modified or cross referenced by the EAI software components.
Windchill PDMLink passes the Start Effectivity Date in the format YYYY-MM-DD HH:MM:SS. Windchill ESI assumes that the time zone is configured across Windchill PDMLink, TIBCO, and Oracle Applications.
The attributes Default Unit, Part Type, and Source are cross referenced in the EAI software components. The following tables show the possible available Windchill PDMLink part values and the corresponding Oracle Applications item values that are passed from the EAI software components to Oracle Applications.
Windchill Part Default Unit Value to Oracle Applications Item Base Unit of Measure Value Mapping
Windchill Part Default Unit Value (Database Value)
Oracle Applications Base Unit of Measure Value (Database Value)
As Needed (as_needed)
As Needed (AN)
Each (ea)
Each (Ea)
Kilogram (kg)
Kilogram (KG)
Liter (l)
Liter (L)
Meter (m)
Meter (M)
Windchill PDMLink Part Type Value to Oracle Applications Material Type Value Mapping
Windchill PDMLink Part Type Value (Database Value)
Oracle Applications Item Type Value (Database Value)
Separable (separable)
Subassembly (SA)This is the mapping for the API field ITEM_TYPE. The mapping for the API field TEMPLATE_ID is Subassembly (5), and the mapping for the API field TEMPLATE_NAME is Subassembly (@Subassembly).
Inseparable (inseparable)
Subassembly (SA)
This is the mapping for the API field ITEM_TYPE. The mapping for the API field TEMPLATE_ID is Subassembly (5), and the mapping for the API field TEMPLATE_NAME is Subassembly (@Subassembly).
Component (component)
Purchased Item (P)
This is the mapping for the API field ITEM_TYPE. The mapping for the API field TEMPLATE_ID is Purchased Item (2), and the mapping for the API field TEMPLATE_NAME is Purchased Item (@Purchased Item)
Windchill PDMLink Part Source Value to Oracle Applications Procurement Type Value Mapping
Windchill PDMLink Part Source Value (Database Value)
Oracle ApplicationsGeneral Planning Make or Buy Value
Make (make)
Make (1)
Buy (buy)
Buy (2)
There are some attributes that Oracle Applications requires to create or change item records that are not provided by Windchill PDMLink. In these instances, Windchill ESI defaults the values in the EAI software components prior to passing the data to Oracle Applications. The following table lists the Oracle Applications item attributes that are defaulted in Windchill ESI and their default values.
Oracle Applications Item Attribute Default Values
Oracle Applications Item Attribute
Default Value
Summary Flag
No (N)
Effectivity Control
1 for Date or 2 for Unit
Serial Number Generation Code
2 for Predefined
Starting Prefix
X
Starting Number
1
Windchill ESI also leverages Subassembly and Purchased Item templates in Oracle Applications, which automatically provide default data values for many other Item fields. See the Oracle Inventory User's Guide supplied with your Oracle Applications software for further details on Item templates.
Windchill PDMLink also supports publishing alternates related to parts; however, because the concept of alternate parts, as it exists in Windchill PDMLink, does not exist in Oracle Applications, the EAI software components portion of Windchill ESI does not support publishing alternate parts to Oracle Applications. If the Oracle Applications distribution target is capable of handling Windchill PDMLink alternates, the EAI software components portion of Windchill ESI can be extended to pass the information to Oracle Applications, however, by default, alternates are not supported.
Plant Specific Attributes for Parts
Plant-specific attributes for a part can be published using the view-specific capabilities of Windchill MPMLink. To publish plant-specific attributes:
• Ensure that the Publish View Specific Enterprise Data Information preference from theESI > Settings > Parts category is set to Yes.
• Define a specific view corresponding to each of your plants in Windchill MPMLink.
• Define your plant-specific attributes in the corresponding view attributes tab.
• Use Windchill ESI to publish your part.
Windchill ESI then retrieves the plant-specific attributes for the part from Windchill MPMLink and sends that information to the relevant organization in the distribution target.
* 
• These attributes must have their mappings defined in the ESI response meta information file. Also, the EAI software components should be extended to map these attributes to Oracle Applications as appropriate.
• While publishing plant-specific or view-specific enterprise data for parts or resources using Send to Distribution Target action, Send Material to Distribution Target action, Change Notice, Promotion, Set State, or Saved Filter is used from:
◦ BOM Settings on distribution target when publishing part or BOM.
◦ Resource Settingson distribution target when publishing resource or resource structure.
◦ Process Plan Settings on distribution target when publishing process plan structure.
◦ Change Notice Settings on distribution target when publishing using change notice.