Description
IBM WebSphere Business Integration Express for Item Synchronization 4.3.1
Fix Pack 1.2
This fixpack includes the following:
- IBM WebSphere Business Integration Express for Item Synchronization 4.3.1 Fix Pack 1.1
- IBM WebSphere Business Integration Collaborations for Consumer Products Item Synchronization 4.4.0 Fix Pack 3
Prerequisites
- IBM WebSphere Business
Integration Express for Item Synchronization 4.3.1
- For OS/400 –
Integration Assistant for iSeries V5.2.0, LPP 5722IA1 with one of the
following depending on your installation:
- Option 11 –
WebSphere Business Integration Express for Item Sync
- Option 12 –
WebSphere Business Integration Express Plus for Item Sync
APARs Included
APAR SE20443 (Express)
APAR SE20476 (Express Plus)
Enhancements
The IBM WebSphere Business Integration Collaborations for Consumer Products Item
Synchronization 4.4.0 Fix Pack 3 includes changes to business objects, maps to support
the UCCnet Network Release 1.0. Use of some UCCnet Network Release 1.0 functionality
enhancements requires XML schema processing capabilities, which is enforced by the
Trading Partner registration of a capability for XSD. Refer to the UCCnet Network
Release 1.0.0 Community Update document for more details.
The changes described here are derived from the UCCnet Network v1.0 Release Notes
and UCCnet Network v1.0 schema definitions. In keeping with the design philosophy of
the WBI Retail Collaborations, every effort has been made to mask the changes to the
UCCnet Services messages from the applications which reside above the Retail
Collaboration layer. To this end, changes to the GBO’s, i.e. Retail_Item BO, were
minimized by mapping the UCCnet changes into the existing BO’s wherever possible.
In summary the enhancements include:
-
Updated UCCnetXSD
business objects and mapping to support the new XSD message structure, which
includes a ‘hook’ area
within the Trade Item schema. This area will contain the currently supported
extensions when passed through UCCnet Network Services.
-
Multiple extensions attributes of differing types can now be
sent on a single GLN forwarded to any recipient.
-
FMCG extension attributes have been extracted from the
data contained in the UCCnet 1.3 Trade Item in order to support the separate
GDSN FMCG extension.
-
Added the Lowes extension business objects and
mappings to support the new Lowe’s extension.
-
Fix for getting error codes and description from
recursive subdocumentValid elements in Error Response
Files included in this Fix Pack:
- CIN_CIP_Dispatcher.jar
- Readme.htm - this file
- Retail_Error.jar
- Retail_Error_ASBO.jar
- Retail_Item.jar
- Retail_Item_ASBO.jar
- Retail_Item_ASBO_to_Retail_Item.jar
- Retail_Item_to_UCCnetGBO_envelope_notifyCommand_catalogueItem.jar
- Retail_Item_to_UCCnetGBO_envelope_publicationCommand_CIP.jar
- Retail_Item_to_UCCnetJMSXSD_envelope_publicationCommand_catalogueItem.jar
- Retail_Item_to_UCCnetJMSXSD_envelope_registerCommand_itemAddChange.jar
- Retail_Item_to_UCCnetTPIXSD_envelope_publicationCommand_catalogueItem.jar
- Retail_Item_to_UCCnetTPIXSD_envelope_registerCommand_itemAddChange.jar
- Retail_Item_to_UCCnetXSD_envelope_publicationCommand_catalogueItem.jar
- Retail_Item_to_UCCnetXSD_envelope_registerCommand_itemAddChange.jar
- Retail_Price.jar
- Retail_Price_ASBO.jar
- Retail_Price_to_UCCnetXSD_envelope.jar
- Sub_Retail_Item_to_UCCnetXSD_envelope.jar
- UCCnetGBO_envelope.jar
- UCCnetJMSXSD_envelope.jar
- UCCnetTPIXSD_envelope.jar
- UCCnetXSD_envelope.jar
- UCCnetXSD_envelope_to_UCCnetGBO_envelope.jar
- UCCnet_processWorklist.jar
- UCCnet_requestWorklist.jar
Business Object changes:
- UCCnetXSD_envelope_tradeItem (modified)
- UCCnetXSD_envelope_longDescription (modified)
- UCCnetXSD_envelope_catalogueItemSubscription (modified)
- UCCnetXSD_envelope_value (modified)
- UCCnetXSD_envelope_ExtensionsGroup (new)
- UCCnetXSD_envelope_ExtensionsGroup_Wrapper (new)
- UCCnetXSD_envelope_hardlinesTradeItem (new)
- UCCnetXSD_envelope_FMCGTradeItem (new)
- UCCnetXSD_envelope_HBCTradeItem (new)
- UCCnetXSD_envelope_OfficeSuppliesTradeItem (new)
- UCCnetXSD_envelope_componentMeasurementsOS (new)
- UCCnetXSD_envelope_componentDetailsOS (new)
- UCCnetXSD_envelope_tradeItemShippedInMultipleBoxesOS (new)
- UCCnetXSD_envelope_tradeItemComponentsOS (new)
- UCCnetXSD_envelope_dependent (new)
- UCCnetXSD_envelope_otcTradeItem (new)
- UCCnetXSD_envelope_produceTradeItem (new)
- UCCnetXSD_envelope_fMCGTradeItemIdentification (new)
- UCCnetXSD_envelope_fMCGtradeItemMarking
(new)
- UCCnetXSD_envelope_FMCGtradeItemMeasurements
(new)
- UCCnetXSD_envelope_LowesTradeItem (new)
- UCCnetXSD_envelope_LowesTradeItemIndicator (new)
- UCCnetXSD_envelope_environmentalOrHazardousInformation (new)
- UCCnetXSD_envelope_additionalProductInformation (new)
- UCCnetXSD_envelope_shelfQuantityInformation (new)
- UCCnetXSD_envelope_truckLoadType (new)
- UCCnetXSD_envelope_imageType (new)
- UCCnetXSD_envelope_imageFileSize (new)
- UCCnetXSD_envelope_environmental (new)
- Retailer_tradeItem (modified)
- Retailer_value (modified)
- Retailer_additionalItemIdentification (modified)
- Retailer_dependent (new)
- Retailer_LowesTradeItemIndicator (new)
- Retailer_environmentalOrHazardousInformation (new)
- Retailer_environmental (new)
- Retailer_additionalProductInformation (new)
- Retailer_shelfQuantityInformation (new)
- Retailer_truckLoadType (new)
- Retailer_imageType (new)
- Retailer_imageFileSize (new)
Map changes:
- Sub_Retail_Item_piecesPerTradeItem_to_UCCnetXSD_env_measurement (new)
- Sub_Retail_Item_tradeItemFinish_to_UCCnetXSD_env_tradeItemFinish (new)
- Sub_Retail_Item_wranntyInfo_to_UCCnetXSD_env_wranntyInfo (new)
- Sub_Retail_Item_wranntydes2_to_UCCnetXSD_env_wranntydes2 (new)
- Sub_Retail_Item_orderingAndSelling_to_UCCnetXSD_env_orderingAndSelling (new)
- Sub_Retail_Item_wranntyInd_to_UCCnetXSD_env_wranntyIndOS (new)
- Sub_Retail_Item_nestingInf_to_UCCnetXSD_env_nestingInfOS (new)
- Sub_Retail_Item_securityTagInf_to_UCCnetXSD_env_securityTagInfOS (new)
- Sub_Retail_Item_tradeItemAltUnitOfMea_to_UCCnetXSD_env_tradeItemUnitOfMea (new)
- Sub_Retail_Item_percentPosConRe_to_UCCnetXSD_env_measurement (new)
- Sub_Retail_Item_percentTotalReCon_to_UCCnetXSD_env_measurement (new)
- Sub_Retail_Item_longdescription1_to_UCCnetXSD_env_longdescription1 (new)
- Sub_Retail_Item_assembledForDisplay_to_UCCnetXSD_env_assembledForDisplay (new)
- Sub_Retail_Item_depthMeasureValue_to_UCCnetXSD_env_depthMeasureValue (new)
- Sub_Retail_Item_heightMeasureValue_to_UCCnetXSD_env_heightMeasureValue (new)
- Sub_Retail_Item_widthMeasureValue_to_UCCnetXSD_env_widthMeasureValue (new)
- Sub_Retail_Item_tradeItemComponents_to_UCCnetXSD_env_tradeItemComponents (new)
- Sub_Retail_Item_tradeItemShipInMultiBox_to_UCCnetXSD_env_tradeItemShipInMultiBox (new)
- Sub_Retail_Item_LowesTradeItemInd_to_UCCnetXSD_env_LowesTradeItemInd (new)
- Sub_Retail_Item_envOrHaz_to_UCCnetXSD_env_envOrHaz (new)
- Sub_Retail_Item_additionalProInfo_to_UCCnetXSD_env_additionalProInfo (new)
- Sub_Retail_Item_shelfQuanIn_to_UCCnetXSD_env_shelfQuanIn (new)
- Sub_Retail_Item_truckLoadType_to_UCCnetXSD_env_truckLoadType (new)
- Sub_Retail_Item_imageType_to_UCCnetXSD_env_imageType (new)
- Sub_Retail_Item_imageFileSize_to_UCCnetXSD_env_imageFileSize (new)
- Sub_Retail_Item_environmental_to_UCCnetXSD_env_environmental (new)
- Sub_Retail_Item_dependent_to_UCCnetXSD_env_dependent (new)
- Sub_Retail_Item_tradeItem_to_UCCnetXSD_env_tradeItem (modified)
- Sub_Retail_Item_value_to_UCCnetXSD_env_value (modified)
Collaboration Template changes:
The above business objects, maps, and collaboration templates contain the
modifications necessary to support the addition of new Lowe’s extension, the
support of the new ‘hook’ area within the Trade Item schema, the support of multiple extensions on a single GLN, and separated FMCG
extension attributes from the data contained in the UCCnet 1.3 Trade
Item.
UCCnet_processWorklist collaboration was
modified to get error codes and description from recursive
subdocumentValid elements in direct Error Response.
APAR SE17259
(Fixpack 1.1 which is included here - November 2004)
Enhancements
The IBM WebSphere Business Integration Express for Item Synchronization
4.3.1 Fix Pack has been enhanced to include the following:
Compliance with
UCCnet Services V2.3 (including Pricing and Price Bracket)
Compliance with
UCCnet Services V2.3.1 (office supplies extension)
Support for
UCCnet Services commands:
Initial Item Load (XSD)
Correction (XSD)
CIP Withdrawal (XSD)
Triggering
Business Object that now supports WWRE and Transora, in addition to UCCnet
Services-specific extensions
Improved
logging function
Support for
dynamically specifying data recipients for publications
Validation
errors returned to user
Files included in this Fix Pack:
- Readme.htm - this file
- BIA_Retail_BO_ItemSync.jar
– contains a complete set of Business Objects
- BIA_Retail_BO_ItemSyncSamples.jar
– contains a sample Retail_Item_ASBO
- BIA_Retail_CT_ItemSync.jar
– contains collaboration templates
- BIA_Retail_NM_ItemSync.jar
– contains maps
- BIA_Retail_NM_ItemSyncSamples.jar
– contains sample maps for Retail_Item_ASBO
- CatalogueItemUtility.jar - new utility to populate data
recipient in a CIN message
- Create_ItemSync_Database.sql
– sample script for DB2 database creation
- Create_ItemSync_Tables.sql
– sample script for DB2 table creation
- ITMSNKDB – SQL source
to create the QITEMSYNC database on OS/400
- ITMSNKTBL – SQL source
to create the tables in the QITEMSYNC database on OS/400
- QWEBBIIAL – CL source
and program to submit jobs which create the database and associated tables
on OS/400
Business Object changes
Changed business objects are:
- UCCnetGBO_envelope
- UCCnetJMSXSD_envelope
- UCCnetTPIXSD_envelope
- UCCnetXSD_envelope
New
business objects are:
- Retail_Item
- Retail_Item_ASBO
- Retail_Price
- Retail_Price_ASBO
Map changes
New top level maps:
- Retail_Item_to_UCCnetGBO_envelope_notifyCommand_catalogueItem
- Retail_Item_to_UCCnetGBO_envelope_publicationCommand_CIP
- Retail_Item_to_UCCnetJMSXSD_envelope_publicationCommand_catalogueItem
- Retail_Item_to_UCCnetTPIXSD_envelope_publicationCommand_catalogueItem
- Retail_Item_to_UCCnetXSD_envelope_publicationCommand_catalogueItem
- Retail_Item_to_UCCnetJMSXSD_envelope_registerCommand_itemAddChange
- Retail_Item_to_UCCnetTPIXSD_envelope_registerCommand_
itemAddChange
- Retail_Item_to_UCCnetXSD_envelope_registerCommand_
itemAddChange
- Retail_Price_to_UCCnetJMSXSD_envelope
- Retail_Price_to_UCCnetTPIXSD_envelope
- Retail_Price_to_UCCnetXSD_envelope
Collaboration changes
Changed collaborations:
- UCCnet_ItemSync
- UCCnet_ProcessWorklist
- UCCnet_RequestWorklist
- CIN_CIP_Dispatcher
- Notify_by_Email
New collaborations:
- CI_Sync
- UCCnet_Price
- CommandRouter
Installation Instructions
Before installing this Fix Pack, backup all affected business objects,
maps, and collaboration templates. Please see the installation instructions
in the IBM WebSphere Business Integration Collaborations for Consumer Products
Item Synchronization 4.4.0 for reference, as needed.
- Using the WebSphere
Business Integration tooling, System Manager, import each of the unzipped
.jar files into the appropriate Integration Component Library (ICL). For ease of deployment, import the
jar files into an ICL that already contains the full Item Synchronization
product. You should preserve
an ICL in your System Manager containing the previous complete
installation version of the Item Sync product as a backup. Components in the fix pack jar
files with the same names will overwrite the existing components in the
ICL receiving the import.
- Any custom modifications
previously made to any of the business objects, maps, or templates will
need to be made to the new imported versions of those objects.
- Compile all the maps and
collaboration templates in the ICL containing the fix pack
- If necessary, restart the
target ICS server in design
mode. (The ICS server must be running in design mode in order to delete
the maps)
- Stop and delete all the
maps running in the target ICS server
- Stop all running
collaboration objects
- Deploy all the business
objects from the ICL containing the fix pack objects to the target ICS
server
- Deploy and compile all the
maps from the ICL containing the fix pack objects to the target ICS server
- Deploy and compile the 3
updated collaboration templates from the ICL containing the fix pack
objects to the target ICS server
- Restart the target ICS in
the desired mode (design or production)
- Verify that all the
collaboration objects and maps are running on the target ICS server
To uninstall this Fix Pack, follow these steps:
- If
you have deployed any of the business objects, maps, or collaboration
templates from the fix pack to the IBM WebSphere Interchange Server repository,
stop all of the running maps and collaboration objects, using the System
Manager toolset.
- Delete
all of the business objects (except for the business objects with names
which begin with MO_), maps, and collaboration templates from the target
Interchange Server repository using the System Manager.
- If
desired, delete the ICL from the System Manager containing the fix pack
components.
- Deploy
the business objects, maps, and collaboration templates to the target ICS
server from the backup System Manager ICL containing the previous, full
version of the Item Synchronization product.