Methods and computer-readable medium for defining a product model

• US 7,904,340 B2
• Filed: 12/31/2003
• Issued: 03/08/2011
• Est. Priority Date: 03/24/2003
• Status: Active Grant

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Siebel Systems Inc. (Oracle Corporation)
• Inventors: Garg, Shailendra, Kale, Shekhar P., Leon, Maria Theresa Barnes, Catahan, Nardo B. Jr.
• Primary Examiner(s): MISIASZEK, MICHAEL
• Application Number:
  US10/751,008
• Publication Number:
  US 20040199536A1
• Time in Patent Office: 2,624 Days
• Field of Search: 345/419, 707/102, 705/26, 705/27, 705/1
• US Class Current: 705/28
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions
• CPC Class Codes: G06Q 30/0601 Electronic shopping [e-shopping]
• CPC Class Codes: G06Q 30/0641 Shopping interfaces

Abstract

Stored product management information in a first format for use by a first computerized system is transformed to readily make the stored product management information available for use in a second computerized system that utilizes a second format in a cost-efficient and time-efficient manner.

Claims

1. A method in a computing system, the method comprising:

defining a product common model, wherein

the defining comprises

determining a common set of fields of product management information,

each field of the common set of fields corresponds to a source field in a source set of fields of product management information,

the source set of fields comprises

at least one source field that does not correspond to any field of the common set of fields,

the each field of the common set of fields further corresponds to a target field in a target set of fields of product management information, and

the target set of fields comprises

at least one target field that does not correspond to any field of the common set of fields;

extracting a source set of product management information, wherein

the source set is stored on a source computerized product management system,

the source set is stored within the source set of fields, and

the extracting is performed by an integration server coupled to the source computerized product management system;

converting the source set of product management information, wherein

the converting the source set converts the source set into a common set of product management information,

the common set of product management information is stored within the common set of fields of the product common model, and

the converting the source set is performed by the integration server;

converting the common set of product management information, wherein

the converting the common set converts the common set into a target set of product management information,

the target set is stored on a target computerized product management system,

the target set is stored within the target set of fields, and

the converting the common set is performed by the integration server.

2. The method of claim 1, wherein the common set of product management information comprises a plurality of product elements.

3. The method of claim 2, wherein each of the plurality of product elements comprises one or more elements selected from a group comprising:

a product configuration element;

a product identifier;

a product base data element;

a product sales data element;

a related product line element for defining a product line element;

a product list of price type element for defining a plurality of product price type elements;

a product list of related inventory location element for defining a plurality of product related inventory location elements for the product;

a list of related product element for defining a plurality of related product elements;

a product list of related business unit element for defining a product related business unit element; and

a product custom data element.

4. The method of claim 3, wherein the product base data element comprises one or more elements selected from a group comprising:

a product category code element;

a product description element;

an product effective end date element for defining a product'"'"'s effective validity end date;

an product effective start date element for defining a product'"'"'s effective validity start date;

a global product identifier element;

a global product classification code element;

a global product serial identifier;

a global product special handling code element;

a product name element;

a product number element;

a product part number element;

a product status code element;

a product type code element;

a product unit of measure code element; and

a product vendor part serial number element.

5. The method of claim 3, wherein the product sales data element comprises one or more elements selected from a group comprising:

a product field replaceable flag;

a product lead time element;

a product maximum order quantity element;

a product minimum order quantity element;

a product revision number element;

a product orderable flag;

a sales product flag;

a service product flag;

a service instance flag; and

a serialized product flag.

6. The method of claim 3, wherein

the product configuration data element comprises a product configuration flag and a product related class element that is specific to a product;

the product line element comprises a product line identifier, a product line base data element and a product line custom data element, wherein the product line base data element comprises;

a product line description element, and

a product line name element;

each of the plurality of product price type elements comprises a product price type code element;

each of the plurality of product related inventory location elements for the product comprises a product inventory location identifier and a product inventory data element for the product, wherein the product inventory data element for the product comprises one or more elements selected from;

a product inventory location classification data element, wherein the product inventory location classification data element comprises one or more elements selected from;

a product movement class code element, and

a product value class code element; and

a product inventory location stocking data element, wherein the product inventory location stocking data element comprises one or more elements selected from;

a product allocate below safety stock level flag,;

a product auto substitute flag,

a product auto allocate flag,

a product maximum inventory level element,

a product minimum inventory level element, and

a product safety stock level element;

each of the plurality of related product elements comprises one or more elements selected from;

a related product identifier,

a related product name element,

a related product number element, and

a related product type code element; and

the product related business unit element comprises a product organization identifier and a product business unit data element, wherein the product business unit data element comprises a product sales unit of measure code element.

7. The method of claim 1, further comprising

extracting a second source set of product management information, wherein

the source computerized product management system is one of a plurality of source computerized management systems,

a second source computerized product management system is another of the plurality of source computerized management systems,

the second source set is stored on the second source computerized product management system, and

the second source set is stored within a second source set of fields;

converting the second source set of product management information, wherein

the converting the second source set converts the second source set into a second common set of product management information; and

integrating the second common set of product management information into the common set of product management information.

8. A computer-readable medium storing one or more sequences of instructions, wherein execution of the one or more sequences of instructions by one or more processors causes the one or more processors to perform:

defining a product common model, wherein

the defining comprises

determining a common set of fields of product management information,

each field of the common set of fields corresponds to a source field in a source set of fields of product management information,

the source set of fields comprises

at least one source field that does not correspond to any field of the common set of fields,

the each field of the common set of fields further corresponds to a target field in a target set of fields of product management information, and

the target set of fields comprises

at least one target field that does not correspond to any field of the common set of fields;

extracting a source set of product management information, wherein

the source set is stored on a source computerized product management system,

the source set is stored within the source set of fields, and

the extracting is performed by an integration server coupled to the source computerized product management system;

converting the source set of product management information, wherein

the converting the source set converts the source set into a common set of product management information,

the common set of product management information is stored within the common set of fields of the product common model, and

the converting the source set is performed by the integration server;

converting the common set of product management information, wherein

the converting the common set converts the common set into a target set of product management information,

the target set is stored on a target computerized product management system,

the target set is stored within the target set of fields, and

the converting the common set is performed by the integration server.

9. The computer-readable medium of claim 8, wherein the common set of product management information comprises a plurality of product elements which comprise other elements.

10. The computer-readable medium of claim 9, wherein each of the plurality of product elements comprises one or more elements selected from a group comprising:

a product configuration data element;

a product identifier;

a product base data element;

a product sales data element;

a related product line element for defining a product line element;

a product list of price type element for defining a plurality of product price type elements;

a product list of related inventory location element for defining a plurality of product related inventory location elements for the product;

a list of related product element for defining a plurality of related product elements;

a product list of related business unit element for defining a product related business unit element; and

a product custom data element.

11. The computer-readable medium of claim 10, wherein the product base data element comprises one or more elements selected from a group comprising:

a product category code element;

a product description element;

an product effective end date element for defining a product'"'"'s effective validity end date;

an product effective start date element for defining a product'"'"'s effective validity start date;

a global product identifier element;

a global product classification code element;

a global product serial identifier;

a global product special handling code element;

a product name element;

a product number element;

a product part number element;

a product status code element;

a product type code element;

a product unit of measure code element; and

a product vendor part serial number element.

12. The computer-readable medium of claim 10, wherein the product sales data element comprises one or more elements selected from a group comprising:

a product field replaceable flag;

a product lead time element;

a product maximum order quantity element;

a product minimum order quantity element;

a product revision number element;

a product orderable flag;

a sales product flag;

a service product flag;

a service instance flag; and

a serialized product flag.

13. The computer-readable medium of claim 10, wherein

the product configuration data element comprises a product configuration flag and a product related class element that is specific to a product;

the product line element comprises a product line identifier, a product line base data element and a product line custom data element, wherein the product line base data element comprises;

a product line description element, and

a product line name element;

each of the plurality of product price type elements comprises a product price type code element;

each of the plurality of product related inventory location elements for the product comprises a product inventory location identifier and a product inventory data element for the product, wherein the product inventory data element for the product comprises one or more elements selected from;

a product inventory location classification data element, wherein the product inventory location classification data element comprises one or more elements selected from;

a product movement class code element, and

a product value class code element; and

a product inventory location stocking data element, wherein the product inventory location stocking data element comprises one or more elements selected from;

a product allocate below safety stock level flag,

a product auto substitute flag,

a product auto allocate flag,

a product maximum inventory level element,

a product minimum inventory level element, and

a product safety stock level element;

each of the plurality of related product elements comprises one or more elements selected from;

a related product identifier,

a related product name element,

a related product number element, and

a related product type code element; and

the product related business unit element comprises a product organization identifier and a product business unit data element, wherein the product business unit data element comprises a product sales unit of measure code element.

14. A method in a computing system, the method comprising:

synchronizing existing target product management information with first and second source product management information, wherein

the existing target product management information is stored at a target computerized product management system,

the first source product management information is stored at a first source computerized product management system,

the second source product management information is stored at a second source computerized product management system,

the synchronizing depends in part on a characteristic of product management information, wherein

the characteristic allows a target record to be updated by an update from the plurality of source computerized product management systems,

the synchronizing comprises

extracting the first source product management information, wherein

the extracting the first source product management information is performed by an integration server, and

the first source product management information is in one of a plurality of source formats,

converting the first source product management information into an intermediate format,

extracting the second product management information, wherein

the extracting the second source product management information is performed by the integration server, and

the second source product management information is in another of the plurality of source formats,

converting the second source product management information into the intermediate format,

integrating the converted first and second source product management information into integrated source product management information,

converting the integrated source product management information into target product management information, wherein

the target product management information is in a target format, and

updating the target computerized product management system with the target product management information, wherein

the updating is performed by the integration server, and

the existing target product management information comprises the target record.