Product common object

• US 8,200,539 B2
• Filed: 05/26/2006
• Issued: 06/12/2012
• Est. Priority Date: 03/24/2003
• Status: Active Grant

• Current Assignee: Siebel Systems Inc. (Oracle Corporation)
• Original Assignee: Siebel Systems Inc. (Oracle Corporation)
• Inventors: Leon, Maria Theresa Barnes, Catahan, Nardo B. Jr., Garg, Shailendra, Kale, Shekhar P.
• Primary Examiner(s): Misiaszek, Michael
• Application Number:
  US11/441,493
• Publication Number:
  US 20060271446A1
• Time in Patent Office: 2,209 Days
• Field of Search: 705/26, 705 261- 272, 345/419, 707/102
• US Class Current: 705/26.1
• 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 comprising:

obtaining product definitions associated with a product from a source product application, wherein

the product definitions are in a source format corresponding to the source product application, and

the source product application executes on a source computer system;

transforming the product definitions into intermediate product definitions, wherein

the transforming the product definitions is performed on an integration server,

the transforming the product definitions uses a common object model,

the common object model defines a common format, and

the intermediate product definitions are in the common format;

transforming the intermediate product definitions into transformed product definitions, wherein

the transforming the intermediate product definitions is performed on the integration server,

the transforming the intermediate product definitions uses the common object model, and

the transformed product definitions are in a target format,

communicating the transformed product definitions to a first target product application; and

communicating the transformed product definitions to a second target product application.

2. The method of claim 1, wherein

the common object model comprises a list of product elements for defining a hierarchy of data elements, and

the hierarchy of data elements comprises a plurality of product elements comprising other 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 identifier;

a product base data element;

a product sales data element;

a product configuration 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 1, further comprising:

obtaining modified product definitions associated with at least one to-be-modified product from the source product application of a plurality of product applications, wherein

the modified product definitions are in the source format;

transforming the modified product definitions into intermediate modified product definitions, wherein

the intermediate modified product definitions are in the common format;

transforming the intermediate product definitions into transformed modified product definitions, wherein

the transformed modified product definitions are in the target format;

communicating the transformed modified product definitions to the one or more target product applications;

using the transformed modified product definitions to create one or more data records in the target format and to update one or more existing data records in the target format to reflect the modified product; and

causing to modify the at least one to-be-modified product based on the one or more data records and the updated existing data records if the one or more target product applications is tasked to modify the at least one to-be-modified product.

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. A non-transitory computer-readable medium carrying 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:

obtaining product definitions associated with a product from a source product application, wherein

the product definitions are in a source format corresponding to the source product application;

transforming the product definitions into intermediate product definitions, wherein

the transforming the product definitions uses a common object model,

the common object model defines a common format, and

the intermediate product definitions are in the common format;

transforming the intermediate product definitions into transformed product definitions, wherein

the transforming the intermediate product definitions uses the common object model, and

the transformed product definitions are in a target format;

communicating the transformed product definitions to a first target product application; and

communicating the transformed product definitions to a second target product application.

8. The non-transitory computer-readable medium of claim 7, wherein

the common object model comprises a list of product elements for defining a hierarchy of data elements, and

the hierarchy of data elements comprises a plurality of product elements comprising other elements.

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

a product identifier;

a product base data element;

a product sales data element;

a product configuration 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.

10. The non-transitory computer-readable medium of claim 9, 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.

11. The non-transitory computer-readable medium of claim 7, further comprising:

obtaining modified product definitions associated with at least one to-be-modified product from the source product application of a plurality of product applications, wherein

the modified product definitions are in the source format;

transforming the modified product definitions into intermediate modified product definitions, wherein

the intermediate modified product definitions are in the common format;

transforming the intermediate product definitions into transformed modified product definitions, wherein

the transformed modified product definitions are in the target format;

communicating the transformed modified product definitions to the one or more target product applications;

using the transformed modified product definitions to create one or more data records in the target format and to update one or more existing data records in the target format to reflect the modified product; and

causing to modify the at least one to-be-modified product based on the one or more data records and the updated existing data records if the one or more target product applications is tasked to modify the at least one to-be-modified product.

12. The non-transitory computer-readable medium of claim 9, 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.