Saturday, October 26, 2013

R12: Updating your ETLs

Along the "let me show you our lesson's" vein, like a lot of you there are a lot of moving parts and pieces which make up an infrastructure.  One of those for us is a rather complex series of ETL (Extract, Transform, and Load) events that get run on a regular basis and were tested in our QA environment during multiple mock deployments of R12.  During the first day with our IT partners doing extensive integration testing we found that there were ETL statements which were not referencing new objects which had been introduced such as tables or columns.

So my tip is that if you are going to R12, and have ETLs in your environment, make sure that you look them over closely so outdated tables aren't retained in favor of new tables that are introduced.

No comments:

Post a Comment