System and method for managing item interchange and identification in an extended enterprise

• US 7,854,376 B2
• Filed: 03/09/2006
• Issued: 12/21/2010
• Est. Priority Date: 09/10/2003
• Status: Active Grant

• Current Assignee: Agile Software Corporation (Oracle Corporation)
• Original Assignee: Agile Software Corporation (Oracle Corporation)
• Inventors: Oberoi, Supreet
• Primary Examiner(s): Labaze; Edwyn
• Application Number:
  US11/371,649
• Publication Number:
  US 20060235771A1
• Time in Patent Office: 1,748 Days
• Field of Search: 235/375, 235/487, 705 65- 69, 705 75- 78
• US Class Current: 235/375
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06Q 10/00 Administration; Management
• CPC Class Codes: G06Q 10/0875 Itemisation or classification of parts, supplies or services, e.g. bill of materials
• CPC Class Codes: G06Q 20/3674 involving authentication

Abstract

A system and method are provided for automatically managing item record interchange in a business enterprise, where an item may be a product, component part, partially assembled or manufactured part, a process, or other item that requires indicia used to identify it within a business enterprise, whether it is a single company enterprise, or a widespread business that receives items from other sources such as manufacturers, suppliers, purchasers, shippers, or other entities. The system provides a universal solution that allows the intake of item records, such as records for manufacturer component parts shipped to a product manufacturer, and integrating the part records from disparate sources into a standard and useable format.

Claims

1. A method comprising:

receiving, by a computer system from a first source, a first record related to an item;

determining, by the computer system, a first indicium in the first record identifying the item;

translating, by the computer system, the first indicium to a standard system indicium;

receiving, by the computer system from a second source, a second record related to the item;

determining, by the computer system, a second indicium in the second record identifying the item, the second indicium being distinct from the first indicium;

translating, by the computer system, the second indicium to the standard system indicium; and

storing, by the computer system, the first and second indicia as alias indicia for the item.

2. The method of claim 1 wherein the first indicium and the second indicium include at least one of the item'"'"'s name, manufacturer, supplier, assembler or purchaser.

3. The method of claim 2 wherein multiple levels of alias indicia are established for the item.

4. A method according to claim 1, further comprising performing exception handling.

5. A method according to claim 4, wherein the exception handling is performed in an interactive manner.

6. The method of claim 1 further comprising:

establishing structural validation rules for defining the manner in which the item information is validated; and

performing exception handling in an interactive manner.

7. The method of claim 1 wherein translating the first indicium to the standard system indicium comprises:

looking up a standard item name for the item according to a standard indicia database; and

converting an item name included in the first indicium to the standard item name.

8. The method of claim 1 further comprising validating the record by:

looking up a standard item name for the item according to a standard name data base;

if the item has a history, generating a template according to the item history;

if the item has no history and a similar item exists, automatically generating an item matching template by analyzing part matching results and generating an item template according to the matching results.

9. The method of claim 8 further comprising running a sequence of smart rules to verify the integrity of the record.

10. The method of claim 8 further comprising, if the item has no history and no similar item exists, generating a new template for the item.

11. The method of claim 1, wherein the first and second indicia include internal part numbers (IPN) and manufacturer part numbers (MPN).

12. A system comprising:

a processing component configured to;

receive, from a first source, a first record related to an item;

determine a first indicium in the first record identifying the item;

translate the first indicium to a standard system indicium;

receive, from a second source, a second record related to the item;

determine a second indicium in the second record identifying the item, the second indicium being distinct from the first indicium;

translate the second indicium to the standard system indicium; and

store the first and second indicia as alias indicia for the item.

13. The system of claim 12 wherein the processing component is further configured to manage exceptions related to the item and routing of item information.

14. The system of claim 12 wherein the processing component is further configured to add new indicia to the record based on additional intelligence known about the item in an enterprise, the adding comprising:

assigning a commodity code;

creating a new data source profile;

automatically assigning a plurality of attributes to a part according to a universal component intelligence database; and

searching data source profiles by a data source identifier and a data source name.

15. A computer-readable medium having stored thereon program code executable by a computer system, the program code comprising:

code that causes the computer system to receive, from a first source, a first record related to an item;

code that causes the computer system to determine a first indicium in the first record identifying the item;

code that causes the computer system to translate the first indicium into a standard indicium;

code that causes the computer system to receive, from a second source, a second record related to the item;

code that causes the computer system to determine a second indicium in the second record identifying the item, the second indicium being distinct from the first indicium;

code that causes the computer system to translate the second indicium into the standard indicium; and

code that causes the computer system to store the first and second indicia as alias indicia for the item.