Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Conversion Methodology

Posted on August 1st, 2007 by Sanjit Anand ||Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

In one of previous post , i have discussed the basics of interface ,conversion and migration.Lets take a more detailed life cycle for data conversion/migration activity. This activity can not be ignored in any Oracle ERP transformation project.

A conversion does follow there own methodology , being a typically methodology it consist of certain task and subtask identified at sub activity level . Here are some of them as discussed below.

1. Movement of Data or Transport of data

This is where you have to plan the movement of data from an external system/old system to Oracle Applications which normally consider within a conversion project plan. The more important is developing a detailed conversion plan for each entity, listing all design, development, testing, and conversion tasks. You have also include resource,software, and hardware requirements to successfully convert each entity.

2.Design Processconversion

This is where you have to decide what need to convert. This start with identifying all objects first there corresponding volume.

  • Examine the business objectives and requirements to determine the data to be converted.
  • Specify time constraints for the conversion, especially for transaction data.
  • Determine the appropriate conversion method, it is not recommended to go for manual entry.If data volume is low , try to find alternate product.
  • Then need is performing data mapping.
  • Then its required to install all hardware and software required for the conversion process.
  • Determine the testing requirements. Identify testing method if available in Oracle else design a custom query to compare the result.

3.Developing Programs

This process does consist of :

  • Writing extract and import programs.
  • Scripts to create any interface or translation tables in Oracle RDBMS.
  • Writing validation, translation, and migration programs.
  • Write verification scripts and reports.

4. Performing Conversion

This is process in which major activity is performed, this consist of:

  • Extract and format data.
  • Create temporary interface tables.
  • Upload data to interface tables.
  • Run translation programs & validation programs.
  • Migrate data into production tables.
  • Run verification scripts.
  • Run application reports to verify converted data.

5. Data Verification

In this phase each converted entity, design a conversion process from data extraction through data verification. Main consideration is business objectives and dependencies for each point in the process.

Related Posts

Posted in Conversion | No Comments »Email This Post Email This Post |

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.