So, last week Simran and I rolled out all the delivered jobs that populate the operational data store (a.k.a. OWS and/or staging area) in PeopleSoft EPM (Enterprise Performance Warehouse) for the Human Capital Management system. We noticed that beside some really weird “Abnormal termination of stage” errors in the DataStage ETL logs most of the issues were related to missing database objects either in the source HRMS schema or in our warehouse database. After talking to one of our hired guns (cool consultants) we were told it is somehow rare for PeopleSoft to have this kind of issues, almost as rare as for them to remove columns from records between releases. We opened a new SR in metalink very quickly got on the phone with a very nice support engineer that clarified the issue. We found out EPM 9.0 as delivered out of the box is designed to source all the OWS tables from HRMS 8.9, if you need to get your staging tables populated with data from the HRMS 9.0 you need to get a different set of jobs that are generally referred to as “Integration Updates”, there are several sets to source data from different versions of PeopleSoft and Enterprise One, if you want the detailed information go to Metalink3 and under the knowledge tab and search for keyword 679264 (Doc. ID 650224.1).
Now before finish I want to thank Frank from Oracle support and clarify that these integration updates only replace the OWS jobs, OWE and MDX get built usin the jobs delivered out of the box with EPM 9.0.