Wednesday, February 15, 2017

Data Migration and Conversion Strategies in Oracle E-business Suite

Data Migration and Conversion Strategies in Oracle E-business Suite:




Data Migration and Conversion Strategies in Oracle E-business Suite



Businesses spend billions of dollars migrating data between information-intensive applications. Yet up to 75 percent of new systems fail to meet expectations, often because flaws in the migration process result in data that is not adequately validated for the intended task.

Data migrations generally result from the introduction of a new system. This may involve an application migration or consolidation in which one or more legacy systems are replaced or the deployment of an additional system that will sit alongside the existing applications.

Whatever the specific nature of any data migration, the ultimate aim is to improve corporate performance and deliver competitive advantage.
Especially while implementation of Oracle e-business Suite and migration of the data from other legacy system to Oracle 


Steps To Design an Effective Data Conversion Process:

Below are the steps for effective data migration and conversion process for any implementations in Oracle ERP.

1-              Data Need for Conversion.
2-            Data Mapping / Conversion Design
3-            Finalization of Data for Migration
4-            Loading of data for QA (Validation)
5-             Data Migration /Data loading to Production.
6-            Data Validations - Production

Data Need for Conversion:

The first point is to decide which data is required for conversion and requirement. It is normally depend on your implementations domain and modules. Which modules are implementing during the imp mentation and that basis it is decided what is the requirement of the data.
For example it is Oracle Financials and SCM implementation and for that you need to load the data from Financials modules let say for Oracle Fixed Asset data and from Supply chain you need to load data for Oracle Inventory.

Data Mapping / Conversion Design

After identifying the data for migration the next stage is to make the conversion design and data mapping.  Few are the important points for data conversion design.
  • ·       Extraction of data from Legacy System
  • ·       Templates for data loading
  • ·       Preparation of mapping sheet to map the legacy data to Oracle required data.
  • ·       Field to Field mapping of data legacy to required data.
  • ·       Legacy system data validation for mapping sheets.
  • ·       Data conversion if required during mapping and validation

Finalization of Data for Migration:

Once the Mapping is complete, the next step is to preparing and finalization of data for migration. This step is very crucial, because whatever data is finalized and migrated will be affected the performance of the ERP and it is saying garbage in and garbage out.
Each and every aspect of the data should be reviewed and analyzed that every piece of information that is required from the legacy data is available and converted into Oracle required form.
Like for Assets data for migration to oracle from legacy system, should be checked that each and every information is included in the data sheets like Assets number, tag number, Asset Category, Manufacturer, Invoice number, serial number etc...

Loading of data for QA:

It increases the effectiveness of the data migration process. Data is loaded into Test Instance (Sometimes called-QA Instance) for detail quality assurance. Mostly QA teams are deployed on QA for data loading. But many cases the imp mentation team validates the data when it loaded to Test Instance.
After QA it identifies all the issues/ deficiencies of data uploaded then the same issues to be resolved from the actual data before final upload.

Data Migration / Data loading to Production:

After data validation the next step is data migration to Production. This step is relatively straightforward. However, it would likely be quite time-consuming due to the size of the legacy database.

Data Validations:

Once the data is migrated to prod, the last step is to validation of prod data. Mostly this validation is high level and summary level data is validated because detail validation is done on QA (Quality Assurance) level.



13 comments:

Anonymous said...

Wow, this post is nice, my younger sister is analyzing these kinds of things, therefore
I am going to let know her.

Anonymous said...

І haᴠе ƅeen surfing online more tɦan 3 hours todаү, yᥱt I by no means discovered аny attention-grabbing article
ⅼike yours. It іs beautiful worth sufficient for me.
Personally, if аll web owners ɑnd bloggers madᥱ excellent content as you diԁ, tɦe
internet migһt be a lot more helpful than evеr Ьefore.



My blog - https://www.youtube.com/watch?v=jonza6OkXE8

Anonymous said...

This design is wicked! You most certainly know how to keep
a reader amused. Between your wit and your videos, I was almost moved to
start my own blog (well, almost...HaHa!) Fantastic
job. I really enjoyed what you had to say, and more than that, how you presented it.
Too cool!

Anonymous said...

If it's essential have additional Gems or Cash, the Golf Clash hack is one of the best factor
that you must get.

Anonymous said...

Some organizations put their retirees via a process , involving the transfer
of info in a period of time. Take away hate, greed, envy, and fear
and replace all of them with love and kindness we are able to
undertake it its around us to alter for the better tomorrow.
This test center printout is key to unlocking the door regarding passing the next
CPIM attempt.

Anonymous said...

I have fun with, lead to I discovered exactly what I used to be having a look for.
You've ended my 4 day lengthy hunt! God Bless you man. Have a
nice day. Bye

Anonymous said...

Hello, I believe your website could be having browser compatibility problems.

When I look at your blog in Safari, it looks fine but when opening in Internet Explorer, it has some overlapping issues.

I simply wanted to provide you with a quick heads up!
Besides that, excellent blog!

Anonymous said...

Hmm it seems like your blog ate my first comment (it
was extremely long) so I guess I'll just sum it up what I submitted
and say, I'm thoroughly enjoying your blog. I too am an aspiring blog writer but I'm still new to the whole thing.
Do you have any helpful hints for newbie blog writers?
I'd certainly appreciate it.

Anonymous said...

Especially with regards to dwell NFL games
, the content provided is not provided by means of official channels.

Anonymous said...

Very energetic article, I liked that bit. Will there be a part 2?

Anonymous said...

Magnificent beat ! I wish to apprentice while you amend your
site, how could i subscribe for a blog web site?
The account helped me a acceptable deal. I had been tiny
bit acquainted of this your broadcast provided bright clear idea

Anonymous said...

Today, while I was at work, my sister stole my iPad and tested to see
if it can survive a forty foot drop, just so she can be a youtube sensation. My iPad is
now destroyed and she has 83 views. I know this is totally
off topic but I had to share it with someone!

Anonymous said...

Hello, I desire to subscribe for this blog to take most up-to-date updates,
thus where can i do it please help out.