Adding Attributes to Enterprise Data Overview
We can add user attributes on enterprise data and we can also create new soft type extensions of enterprise data. Please follow below mentioned steps to publish these new attributes to SAP.
Add Safety Stock attribute in Common Enterprise Data
Open Type and attribute manager to add a new attribute ‘ Safety Stock Days’ on Common Enterprise data.
Modify ESI Response Meta Info file to render newly added attribute
Modify <WindchillHome>\codebase\com\ptc\windchill\esi ESIResponseMetaInfo to add Safety Stock element.
<!-- ESI Common Enterprise Data Mapping -->
<esi:Map id="ESICommonEnterpriseData">
<esi:attributeMapping sourceAttribute="obid">ObjectID</esi:attributeMapping>
<esi:attributeMapping sourceAttribute="xxxx" defaultValue="com.ptc.windchill.esi.CommonEnterpriseData"> Class</esi:attributeMapping>
<esi:attributeMapping sourceAttribute="versionInfo.identifier.versionId">Version</esi:attributeMapping>
<esi:attributeMapping sourceAttribute="iterationInfo.identifier.iterationId">Iteration</esi:attributeMapping>
<esi:attributeMapping sourceAttribute="PreviousVersion">PreviousVersion</esi:attributeMapping>
<esi:attributeMapping sourceAttribute="MaterialGroup">MaterialGroup</esi:attributeMapping>
<esi:attributeMapping sourceAttribute="SafetyStockDays">SafetyStockDays</esi:attributeMapping>
</esi:Map>
<esi:Map id="ESICommonEnterpriseData">
<esi:attributeMapping sourceAttribute="obid">ObjectID</esi:attributeMapping>
<esi:attributeMapping sourceAttribute="xxxx" defaultValue="com.ptc.windchill.esi.CommonEnterpriseData"> Class</esi:attributeMapping>
<esi:attributeMapping sourceAttribute="versionInfo.identifier.versionId">Version</esi:attributeMapping>
<esi:attributeMapping sourceAttribute="iterationInfo.identifier.iterationId">Iteration</esi:attributeMapping>
<esi:attributeMapping sourceAttribute="PreviousVersion">PreviousVersion</esi:attributeMapping>
<esi:attributeMapping sourceAttribute="MaterialGroup">MaterialGroup</esi:attributeMapping>
<esi:attributeMapping sourceAttribute="SafetyStockDays">SafetyStockDays</esi:attributeMapping>
</esi:Map>
Tibco Project Changes
Take the tibco project modified for publishing OOTB Enterprise Data.
1. Modify the ESIResponse schema.
Location:
> .
Create element for SafetyStockDays of type String. (? Indicates optional element)
2. Modify the CBO Schema.
Location: >
Add SafetyStockDays in PartUserArea
3. Mapping from Collection to CBO:
Location:
Process: > : Mapper_ESIResponse_CBO_Headers
Map SafetyStockDays to Part User area
4. Mapping to ERP call.
Location: Process: Project > ProcessDefinitions > ERP Communications > Oracle> Part > Start_CBOPart_ORACreateChange_PD
Activity: Publish_FinalCreate_CallStoredProc
a. Browse to TIB INT MTL SYS ITEMS IFACE mapping
b. Scroll down till you see SAFETY STOCK BUCKET DAYS, map it to SafetyStockDays
How to run this example:
2. Verify that the appropriate distribution targets have been loaded into Windchill.
3. Verify that there is at least one Lifecycle that has a Released state.
4. Verify that all components (Windchill, TIBCO, SAP) are up and running.
5. After every use case, log into Oracle Apps and verify the data was created correctly.