Enterprise Administration > Implementing Windchill ESI > Implementing Windchill ESI in an ORACLE Applications Environment > Loading Release History
Loading Release History
Release history is a record of the information that is published from Windchill, identifying the sourceWindchill PDMLink, MPMLink data, and the distribution target.
It may sometimes be necessary to load the release history for objects (such as parts and assemblies) that reside in the ERP system, but which were not published by Windchill ESI in the first place. Such a loading helps ensure that the two systems (Windchill PDMLink, MPMLink, and the ERP system) are in sync with each other, thereby allowing ESI to use those objects in subsequent publications.
Release Activity is now a typed object.
You can access the Release Activity from Site > Utilities > Type and Attribute Management. For more information on Type and Attribute Management, see Working with the Type and Attribute Management Utility.
You can add local and global attributes for Release Activity, but sub-types can not be created.
Creates Multiple Release Activity For Objects (using csvCreateReleaseActivity)
Loading release history is a common ERP Connector function. Release history may be loaded from an XML (Extensible Markup Language) or a CSV (comma-separated values) import file, when using wt.load.LoadFromFile to load release activity:
Field
Description
Mandatory
release Class
The Windchill ESI release class of the Releasable object. A value is required for this attribute. This contains strings such as com.ptc.windchill.esi.Part or com.ptc.windchill.esi.mpml.ProcessPlan. Refer to the path <WT_HOME>\codebase\com\ptc\windchill\esi to open the file ESIResponseMetaInfo.xml for appropriate release class value of Releasable objects.
Yes
release object type
The class type of Releasable object. A value is required for this attribute. This contains strings such as wt.part.WTPart or com.ptc.windchill.mpml.processplan.MPMProcessPlan.
Yes
release object number
The number of the Releasable object. A value is required for this attribute.
Yes
release object version
The version of the Releasable object. A value is optional for this attribute.
No
release object iteration
The iteration of the Releasable object. A value is optional for this attribute.
No
release object view
The view of the Releasable object. A value is optional for this attribute.
No
distribution target number
The number of the distribution target. A value is required for this attribute.
Yes
publication date
The date on which the information was published to ERP. The format should be YYYY-MM-DD HH:MM:SS. The time portion should be represented as GMT. If the date is not provided in the specified format, the date and time will default to the current time in the time zone of the Windchill server.
No
publication action
The action of the publication. A value is required for this attribute. This is a string which can be create, change, or delete.
Yes
container path
The container path of the Releasable object. A value is optional for this attribute.
No
message
The publish message for release activity. A value is optional for this attribute.
No
For example:
<csvCreateReleaseActivity handler="com.ptc.windchill.esi.load.LoadESI.createReleaseActivity">
<csvreleaseClass>com.ptc.windchill.esi.Part</csvreleaseClass>
<csvobjectClass>wt.part.WTPart</csvobjectClass>
<csvobjectNumber>PART_OP555</csvobjectNumber>
<csvobjectVersion>A</csvobjectVersion>
<csvobjectIteration>1</csvobjectIteration>
<csvobjectView>Design</csvobjectView>
<csvtargetNumber>00000003</csvtargetNumber>
<csvpublishDate>2015-07-05 06:30:00</csvpublishDate>
<csvpublishAction>create</csvpublishAction>
<csvcontainerPath>/wt.inf.container.OrgContainer=ESI Tests Organization/wt.pdmlink.PDMLinkProduct=ESITests</csvcontainerPath>
<csvpublishMessage>Loader Part</csvpublishMessage>
</csvCreateReleaseActivity>
<csvCreateReleaseActivity handler="com.ptc.windchill.esi.load.LoadESI.createReleaseActivity">
<csvreleaseClass>com.ptc.windchill.esi.Part</csvreleaseClass>
<csvobjectClass>com.ptc.windchill.esi.Document</csvobjectClass>
<csvobjectNumber>TEST_DOC1_9903560</csvobjectNumber>
<csvobjectVersion>A</csvobjectVersion>
<csvobjectIteration>1</csvobjectIteration>
<csvtargetNumber>FILE001</csvtargetNumber>
<csvpublishDate>2015-07-05 06:30:00</csvpublishDate>
<csvpublishAction>create</csvpublishAction>
<csvcontainerPath>/wt.inf.container.OrgContainer=ESI Tests Organization/wt.pdmlink.PDMLinkProduct=ESITests</csvcontainerPath>
<csvpublishMessage>Created release history successfully for document TEST_DOC1_9903560.</csvpublishMessage>
</csvCreateReleaseActivity>
Attributes
<csvBeginReleaseActivities handler="com.ptc.windchill.esi.load.LoadESI.beginCreateReleaseActivities"/>
<csvCreateReleaseActivity handler="com.ptc.windchill.esi.load.LoadESI.createReleaseActivity">
<csvreleaseClass>com.ptc.windchill.esi.Part</csvreleaseClass>
<csvobjectClass>wt.part.WTPart</csvobjectClass>
<csvobjectNumber>0000000003</csvobjectNumber>
<csvobjectVersion>A</csvobjectVersion>
<csvobjectIteration>1</csvobjectIteration>
<csvobjectView>Design</csvobjectView>
<csvtargetNumber>00000003</csvtargetNumber>
<csvpublishDate>2021-07-22 09:00:00</csvpublishDate>
<csvpublishAction>create</csvpublishAction>
<csvpublishMessage>Loader Part</csvpublishMessage>
</csvCreateReleaseActivity>
<csvIBAValue handler="wt.iba.value.service.LoadValue.createIBAValue"> <!--Global attributes-->
<csvdefinition>StringIBA</csvdefinition>
<csvvalue1>StringIBA_value</csvvalue1>
<csvvalue2></csvvalue2>
<csvdependency_id></csvdependency_id>
</csvIBAValue>
<csvLoadValue handler="com.ptc.core.lwc.server.LoadAttValues.loadValue"> <!--Local attributes-->
<csvname>StringAttr</csvname>
<csvrefType/>
<csvrefAtt/>
<csvvalue>DATA|java.lang.String|StringAttr_value</csvvalue>
</csvLoadValue>
<csvEndReleaseActivity handler="com.ptc.windchill.esi.load.LoadESI.endCreateReleaseActivity" />
<csvEndReleaseActivities handler="com.ptc.windchill.esi.load.LoadESI.endCreateReleaseActivities"/>
Create Multiple Release Activity for Object Associations (using csvCreateReleaseActivityForLink)
Release history can be loaded from a XML (Extensible Markup Language) import file, when using wt.load.LoadFromFile to load release activity:
Field
Description
Mandatory
release Class
The Windchill ESI release class of the Releasable object. A value is required for this attribute. This contains strings such as com.ptc.windchill.esi.Part or com.ptc.windchill.esi.mpml.ProcessPlan. Refer to the path <WT_HOME>\codebase\com\ptc\windchill\esi to open the file ESIResponseMetaInfo.xml for appropriate release class value of Releasable objects.
Yes
releasable link type
The class type of Releasable link. A value is required for this attribute. This contains a string such as com.ptc.windchill.mpml.processplan.MPMPartToProcessPlanLink.
Yes
object type of roleA of link
The object type of the roleA object of the link.
Yes
object number of roleA of releasable link
The object number of the roleA object of the Releasable link object. A value is required for this attribute.
Yes
version of roleA object of releasable link
The version of the roleA object of the Releasable link object. A value is optional for this attribute.
No
iteration of roleA object of releasable link
The iteration of the roleA object of Releasable link object. A value is optional for this attribute.
No
view of roleA object of releasable link
The view of the roleA object of Releasable link object. A value is optional for this attribute.
No
container path of roleA object of releasable link
The container path for the roleA object of the Releasable link object for which release history is being loaded.
Specify a value for this attribute only if the roleA and roleB objects of the link (say, a WTPartDescribeLink) are from different contexts. If they are both from the same context (for example the part and the document from same context), specify a value for container path instead.
No
object type of roleB of link
The object type of roleB object of the link.
Yes
object number of roleB of releasable link
The object number of the roleB of Releasable link object. A value is required for this attribute.
Yes
version of roleB object of releasable link
The version of the roleB of Releasable link object. A value is optional for this attribute
No
iteration of roleB object of releasable link
The iteration of the roleB of Releasable link object. A value is optional for this attribute.
No
view of roleB object of releasable link
The view of the roleB of Releasable link object. A value is optional for this attribute.
No
container path of roleB object of releasable link
The container path for the roleB object of the Releasable link object for which release history is being loaded.
Specify a value for this attribute only if the roleA and roleB objects of the link (say, a WTPartDescribeLink) are from different contexts. If they are both from the same context (for example the part and the document from same context), specify a value for container path instead.
No
distribution target number
The number of the distribution target. A value is required for this attribute.
Yes
publication date
The date of the publication. A value is optional for this attribute.
No
publication action
The action of the publication. A value is required for this attribute. This is a string which can be create, change, or delete.
Yes
container path
The container path of the Releasable object. A value is optional for this attribute and is specified only if both the roleA and roleB objects of the Releasable link object are from the same context.
No
message
The publish message for release activity. A value is optional for this attribute.
No
For example:
<csvCreateReleaseActivityForLink handler="com.ptc.windchill.esi.load.LoadESI.
createReleaseActivityForLink">
<csvreleaseClass>com.ptc.windchill.esi.mpml.PartToProcessPlanLink</csvreleaseClass>
<csvlinkClass>com.ptc.windchill.mpml.processplan.MPMPartToProcessPlanLink</csvlinkClass>
<csvroleAObjectClass>wt.part.WTPart</csvroleAObjectClass>
<csvroleAObjectNumber>BOM_OP01</csvroleAObjectNumber>
<csvroleAObjectVersion>A</csvroleAObjectVersion>
<csvroleAObjectIteration>1</csvroleAObjectIteration>
<csvroleAObjectView>Design</csvroleAObjectView>
<csvroleAObjectContainerPath>/wt.inf.container.OrgContainer=ESI Tests Organization/wt.pdmlink.PDMLinkProduct=ESITests</csvroleAObjectContainerPath>
<csvroleBObjectClass>com.ptc.windchill.mpml.processplan.MPMProcessPlan</csvroleBObjectClass>
<csvroleBObjectNumber>YDPLAN01</csvroleBObjectNumber>
<csvroleBObjectVersion>A</csvroleBObjectVersion>
<csvroleBObjectIteration>1</csvroleBObjectIteration>
<csvroleBObjectContainerPath>/wt.inf.container.OrgContainer=ESI Tests Organization/wt.pdmlink.PDMLinkProduct=ESITests</csvroleBObjectContainerPath>
<csvroleBObjectView>Design</csvroleBObjectView>
<csvtargetNumber>00000003</csvtargetNumber>
<csvpublishDate>2015-07-05 06:30:00</csvpublishDate>
<csvpublishAction>create</csvpublishAction>
<csvpublishMessage>Loader Message</csvpublishMessage>

</csvCreateReleaseActivityForLink>
Each row in the import file represents a publishing event for a specific Windchill business object to a specific ERP organization.
Was this helpful?