Custom common object

• US 20040199489A1
• Filed: 03/24/2004
• Published: 10/07/2004
• Est. Priority Date: 03/24/2003
• Status: Active Grant

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Siebel Systems Inc. (Oracle Corporation)
• Inventors: Catahan, Nardo B. Jr., Barnes-Leon, Maria Theresa, Exley, Richard Mark
• Granted Patent: US 7,287,041 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

Enterprise management information in a first format for use by a first computerized system is transformed into an intermediate format to readily make the stored enterprise management information available for use in a second computerized system that utilizes a second format. The intermediate format includes a plurality of custom data type elements that are adapted for capturing unique customer information that are relevant to the customer'"'"'s business systems.

Claims

1. A method in a computing system for managing enterprise data, the method comprising:

extracting enterprise information in a first form that is associated with a first source computerized system;

converting the enterprise information in the first form into corresponding information that is in a second intermediate form; and

converting the enterprise information in the second intermediate form into a target form that corresponds to a target computerized system, wherein the second intermediate form includes a plurality of custom data type elements that are adapted for capturing customer information and that can be referenced by other data structures in the second intermediate form.

2. The method of claim 1, further comprising:

extracting enterprise information in a third form that is associated with a second source computerized system that is distinct from the first source computerized system;

converting the enterprise information in the third form into enterprise information that is in the second intermediate form; and

converting the enterprise information in the second intermediate form into the target form.

3. The method of claim 1, wherein the customer information includes information that defines specific aspects of the customer'"'"'s business.

4. The method of claim 1, wherein the custom data type elements include one or more elements comprising:

an address custom data type element;

an auto deal custom data type element;

an auto policy custom data type element;

an auto sales history custom data type element;

an auto service history custom data type element;

an auto service job custom data type element;

an auto service repair order custom data type element;

a balance statement custom data type element;

a billing profile custom data type element;

a bill of material component custom data type element;

a bill of material custom data type element;

a business unit custom data type element.

5. The method of claim 1, wherein the custom data type elements include one or more elements comprising:

a claim custom data type element;

a claim payment custom data type element;

a class attribute custom data type element;

a class attribute value custom data type element;

a class custom data custom data type element;

a contact-of custom data type element;

a contract custom data type element;

a cost list custom data type element; and

a cost list line custom data type element.

6. The method of claim 1, wherein the custom data type elements include one or more elements comprising:

a credit bureau report custom data type element;

a customer-of custom data type element;

an employee-of custom data type element;

an expense custom data type element;

an expense line custom data type element;

a financial account custom data type element;

a financial applicant custom data type element;

a financial application account custom data type element;

a financial application collateral custom data type element;

a financial application custom data type element;

a financial application funding source custom data type element; and

a financial statement custom data type element.

7. The method of claim 1, wherein the custom data type elements include one or more elements comprising:

a forecast custom data type element;

a forecast line detail custom data type element;

a product catalog custom data type element;

a product catalog line item custom data type element;

a product custom data type element;

a product inventory location custom data type element;

a product line custom data type element;

a product price custom data type element;

an installed product custom data type element;

a price list custom data type element; and

a price list line custom data type element.

8. The method of claim 1, wherein the custom data type elements include one or more elements comprising:

a purchase order custom data type element;

a purchase order line item custom data type element;

a vehicle anti theft device custom data type element;

a vehicle custom data type element;

a vehicle option custom data type element;

a person custom data type element;

a policy custom data type element;

a position custom data type element;

a related-to custom data type element;

a represented-by custom data type element;

a security custom data type element;

a service request custom data type element; and

a set of books custom data type element.

9. The method of claim 1, wherein the custom data type elements include one or more elements comprising:

an order custom data type element;

an order line custom data type element;

an order type custom data type element;

an organization custom data type element;

a party authentication custom data type element;

a party custom data type element;

a payment custom data type element;

a payment line custom data type element;

a payment method custom data type element;

a payment term custom data type element; and

a payment type custom data type element.

10. The method of claim 1, wherein the custom data type elements include one or more elements comprising:

an opportunity custom data type element;

an opportunity notes custom data type element;

an opportunity revenue item custom data type element;

an invoice custom data type element;

an invoice line custom data type element;

an invoice plan custom data type element;

an invoice type custom data type element;

a life policy custom data type element; and

a list of relationship custom data type element.

11. The method of claim 1, wherein the custom data type elements include one or more elements comprising:

an inventory balance custom data type element;

an inventory balance list of balance balance custom data type element;

an inventory transaction custom data type element;

an inventory location custom data type element;

a functional area custom data type element;

a holding custom data type element; and

a household custom data type element.

12. A computer-readable medium carrying one or more sequences of instructions for managing enterprise data, wherein execution of the one or more sequences of instructions by one or more processors causes the one or more processors to perform:

extracting enterprise information in a first form that is associated with a first source computerized system;

converting the enterprise information in the first form into corresponding information that is in a second intermediate form; and

converting the enterprise information in the second intermediate form into a target form that corresponds to a target computerized system, wherein the second intermediate form includes a plurality of custom data type elements that are adapted for capturing customer information and that can be referenced by other data structures in the second intermediate form.

13. A data schema for managing enterprise data, the data schema including custom data type elements comprising:

an address custom data type element;

an auto deal custom data type element;

an auto policy custom data type element;

an auto sales history custom data type element;

an auto service history custom data type element;

an auto service job custom data type element;

an auto service repair order custom data type element;

a balance statement custom data type element;

a billing profile custom data type element;

a bill of material component custom data type element;

a bill of material custom data type element;

a business unit custom data type element

14. The data schema of claim 13, wherein the custom data type elements further comprises:

a claim custom data type element;

a claim payment custom data type element;

a class attribute custom data type element;

a class attribute value custom data type element;

a class custom data custom data type element;

a contact-of custom data type element;

a contract custom data type element;

a cost list custom data type element; and

a cost list line custom data type element.

15. The data schema of claim 13, wherein the custom data type elements further comprises:

a credit bureau report custom data type element;

a customer-of custom data type element;

an employee-of custom data type element;

an expense custom data type element;

an expense line custom data type element;

a financial account custom data type element;

a financial applicant custom data type element;

a financial application account custom data type element;

a financial application collateral custom data type element;

a financial application custom data type element;

a financial application funding source custom data type element; and

a financial statement custom data type element.

16. The data schema of claim 13, wherein the custom data type elements further comprises:

a forecast custom data type element;

a forecast line detail custom data type element;

a product catalog custom data type element;

a product catalog line item custom data type element;

a product custom data type element;

a product inventory location custom data type element;

a product line custom data type element;

a product price custom data type element;

an installed product custom data type element;

a price list custom data type element; and

a price list line custom data type element.

17. The data schema of claim 13, wherein the custom data type elements further comprises:

a purchase order custom data type element;

a purchase order line item custom data type element;

a vehicle anti theft device custom data type element;

a vehicle custom data type element;

a vehicle option custom data type element;

a person custom data type element;

a policy custom data type element;

a position custom data type element;

a related-to custom data type element;

a represented-by custom data type element;

a security custom data type element;

a service request custom data type element; and

a set of books custom data type element.

18. The data schema of claim 13, wherein the custom data type elements further comprises:

an order custom data type element;

an order line custom data type element;

an order type custom data type element;

an organization custom data type element;

a party authentication custom data type element;

a party custom data type element;

a payment custom data type element;

a payment line custom data type element;

a payment method custom data type element;

a payment term custom data type element; and

a payment type custom data type element.

19. The data schema of claim 13, wherein the custom data type elements further comprises:

an opportunity custom data type element;

an opportunity notes custom data type element;

an opportunity revenue item custom data type element;

an invoice custom data type element;

an invoice line custom data type element;

an invoice plan custom data type element;

an invoice type custom data type element;

a life policy custom data type element; and

a list of relationship custom data type element.

20. The data schema of claim 13, wherein the custom data type elements further comprises:

an inventory balance custom data type element;

an inventory balance list of balance balance custom data type element;

an inventory transaction custom data type element;

an inventory location custom data type element;

a functional area custom data type element;

a holding custom data type element; and

a household custom data type element.