Method, and system for product configuration

• US 5,963,953 A
• Filed: 03/30/1998
• Issued: 10/05/1999
• Est. Priority Date: 03/30/1998
• Status: Expired due to Term

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Siebel Systems Inc. (Oracle Corporation)
• Inventors: Liou, Ming-Tao, Stauber, Christopher, Cram, Robert
• Primary Examiner(s): Amsbury, Wayne
• Assistant Examiner(s): PARDO, THUY N
• Application Number:
  US09/050,749
• Time in Patent Office: 554 Days
• Field of Search: 382/156, 364/489, 345/333, 345/420, 395/500, 395/701, 705/29, 707/100
• US Class Current: 1/1
• CPC Class Codes: G06F 30/00 Computer-aided design [CAD]
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A method of configuring a complex composite product a: from a partial composite product and an enumeration of unsatisfied requirements of the complex composite product, said complex composite product being subject to rules.

Claims

1. A method of configuring a complex composite product from a partial composite product and an enumeration of unsatisfied requirements of the complex composite product, said complex composite product being subject to rules,

a ordering the enumeration of unsatisfied requirements;

b choosing an item in the ordered list of unsatisfied requirements;

c within the selected item of the ordered list;

i) determining if there is a list of subordinate unsatisfied requirements, and if a subordinate list of unsatisfied requirements exists, recursively returning to step b;

ii) if no subordinate lists of unsatisfied requirements exists, matching components currently unsatisfied requirement to create a list of components;

iii) ordering the list of components;

iv) changing the quantity of components ordered in step iii) to satisfy the unsatisfied requirement for the component; and

b returning to step a if there are remaining unsatisfied requirements.

2. The method of claim 1 wherein the selected item is the first item.

3. The method of claim 1 comprising storing rules as a direct association of part plus ordering.

4. The method of claim 3 comprising storing the rules as <

Part Identifier>

+<

Order>

.

5. The method of claim 3 comprising storing the rules in columns or fields within a larger record structure or row in a table.

6. The method of claim 3 comprising providing a screen form for the user to enter into the database or file, an ordering number per configuration item.

7. The method of claim 3 comprising querying a database for the <

Order>

information for each item in the list of unsatisfied requirements, sorting the resulting list, and identifying the first item in the resulting sorted list.

8. The method of claim 1 comprising storing rules and preferences as one or more of a formula or formula value, a reference to a property value, or a reference to a function.

9. The method of claim 8 comprising late binding of an ordering to each item.

10. The method of claim 8 comprising querying a database for <

Order Formula>

information for each item in the list of unsatisfied requirements, executing the formula for each item, associating a formula result with each item in the list, sorting the resulting list of "item+formula" results, and identifying the first item in the resulting sorted list.

11. The method of claim 1 comprising storing in a database an identifier of a property used to order components or sub-systems in a complete complex system.

12. The method of claim 11 comprising querying the database for the value of the property of each item in the list of unsatisfied requirements, associating this property value with each item in the list, sorting the resulting list of item+property values, and identifying the first item in the sorted list.

13. An article of manufacture comprising:

a computer usable medium having computer readable program code means embodied therein for causing configuration of a complex composite product from a partial composite product and an enumeration of unsatisfied requirements of the complex composite product, said complex composite product being subject to rules, the computer readable program means in said article of manufacture comprising;

a computer readable program code means for causing a computer to effect ordering the enumeration of unsatisfied requirements;

b computer readable program code means for causing selection of an item in the ordered list of unsatisfied requirements;

c computer readable program code means for causing, within the selected item of the ordered list;

i) determining if there is a list of subordinate unsatisfied requirements, and if a subordinate list of unsatisfied requirements exists, recursively returning to step b;

ii) if no subordinate lists of unsatisfied requirements exists, matching components currently unsatisfied requirement to create a list of components;

iii) ordering the list of components;

iv) changing the quantity of components ordered in step iii) to satisfy the unsatisfied requirement for the component; and

d computer readable program code means returning to enumeration of unsatisfied requirements if there are remaining unsatisfied requirements.

14. The program product of claim 13 wherein the selected item is the first item.

15. A program storage device readable by a machine, tangibly embodying a program of instructions executable by a machine to perform method steps for configuring a complex composite product from a partial composite product and an enumeration of unsatisfied requirements of the complex composite product subject to rules and preferences said method steps comprising:

a ordering the enumeration of unsatisfied requirements;

b choosing an item in the ordered list of unsatisfied requirements;

c within the selected item of the ordered list;

i) determining if there is a list of subordinate unsatisfied requirements, and if a subordinate list of unsatisfied requirements exists, recursively returning to step b;

ii) if no subordinate lists of unsatisfied requirements exists, matching components currently unsatisfied requirement to create a list of components;

iii) ordering the list of components;

iv) changing the quantity of components ordered in step iii) to satisfy the unsatisfied requirement for the component; and

d returning to step a if there are remaining unsatisfied requirements.

16. The program storage device of claim 15 wherein the selected item is the first item.