PeopleSoft EPM:Applying Maintenance Packs and Bundles (Updates)

We had one or two issues related to DataStage ETL maps that were skipped when we applied MP5 and multiple bundles on our development environment.  To prevent this issue from happening again I decided to re-install all of our ETL maps from scratch using a Sharepoint wiki to keep track of the update level applied to each of our projects (Main + CS & HCM Integration Updates), order of the files. The format is simple and looks very much like a check-list where the team member applying the patches initials or types in his or her name as each file is imported.  Check it out:

[Project] EPM90_OWE_MDX
Common + HCM OWE + HCM MDX Cummulative Maintenance Pack 5 (MP5) (Feb 28, 2009)
COMMON
File
Contents
Applied By
Common_Utilities_E_E1.dsx

Common Utilities

Ignacio
Common_E.dsx

Common Jobs for SETUP_OWE,SETUP_DIMENSION_MAPPER,
COMMON_DIMENSIONS,GLOBAL_DIMENSIONS

Ignacio
OWE_E.dsx

All E OWE Jobs for all Warehouses

Ignacio
HCM
File
Contents
Applied By
WHR_OWS_E.dsx

E – SETUPS and OWS Jobs

N/A
WHR_MDW_LOCAL_DIMS_E.dsx

E – LOCAL DIMENSIONS

Ignacio
WHR_COMPENSATION_MART_E.dsx

E – MDW Jobs (SKU)

Ignacio
WHR_LEARNING_AND_DEVELOPMENT_MART_E.dsx

E – MDW Jobs (SKU)

N/A
WHR_RECRUITING_MART_E.dsx

E – MDW Jobs (SKU)
Ignacio
WHR_WORKFORCE_PROFILE_MART_E.dsx
E – MDW Jobs (SKU)
Ignacio
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s