MERGER AND ACQUISITION DATA VALIDATION

• US 20100088132A1
• Filed: 10/08/2008
• Published: 04/08/2010
• Est. Priority Date: 10/08/2008
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Hasegawa, Mari, PARKES, Alastair, Manjunatha, Ravi
• Granted Patent: US 8,725,701 B2
• Time in Patent Office: Days
• US Class Current: 705/7
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

Abstract

Systems and methods are provided that perform data validation in real time. By uploading the source data from spreadsheets or entering the data directly into an application, the required validations can be run and reported in real time. Users can then either extract the data back into spreadsheets for manipulation, and then re-upload it, or correct the data directly within the application. Once the data set has passed all validations, it is then passed to the technical team for upload into the transactional system.

Claims

1. A method for validating data before migration from a first platform to a second platform, comprising:

receiving data to be validated from the first platform;

validating the data at a third platform; and

sending validated data the second platform.

2. The method of claim 1, further comprising:

generating a report of errors in the data to be validated;

receiving updated data to be validated; and

validating the updated data.

3. The method of claim 1, wherein validating includes determining whether values are missing.

4. The method of claim 1, wherein validating include determining whether orphaned records are present.

5. The method of claim 1, wherein validating includes mapping a first subset of the data to be validated to a second subset of the data to be validated.

6. The method of claim 1, wherein validating includes mapping the data to be validated to a schema.

7. The method of claim 1, wherein the data to be validated is not sent to the second platform until the data to be validated passes validation.

8. The method of claim 1, wherein first platform is of an acquired company and the second platform is of an acquiring company.

15. The system of claim 1, wherein the data to be validated is not sent to the second platform until the data to be validated passes validation.

16. The system of claim 1, wherein first platform is of an acquired company and the second platform is of an acquiring company.

9. A computer-readable medium having instructions stored thereon that, when executed by a processor, cause the processor to validate data before migration from a first platform to a second platform by:

receiving data to be validated from the first platform;

validating the data at a third platform; and

sending validated data the second platform.

10. The computer-readable medium of claim 9, further comprising:

generating a report of errors in the data to be validated;

receiving updated data to be validated; and

validating the updated data.

11. The computer-readable medium of claim 9, wherein the data to be validated is not sent to the second platform until the data to be validated passes validation.

12. A system for validating data before migration from a first platform to a second platform, comprising:

a memory having stored thereon instructions that cause the system to receive data to be validated from the first platform, validate the data at a third platform, generate a report of errors in the data to be validated, receive updated data to be validated, validate the updated data, and send validated data the second platform; and

a processor that executes the instructions.

13. A system for validating data before migration from a first platform to a second platform, comprising:

means for receiving data to be validated from the first platform;

means for validating the data at a third platform; and

means for sending validated data the second platform.

14. The system of claim 13, further comprising:

means for generating a report of errors in the data to be validated;

means for receiving updated data to be validated; and

means for validating the updated data.