Dynamic criteria based line-grouping mechanism and method for purchase order generation

• US 7,386,478 B2
• Filed: 10/15/2001
• Issued: 06/10/2008
• Est. Priority Date: 10/15/2001
• Status: Active Grant

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Sun Microsystems Incorporated (Oracle Corporation)
• Inventors: Viswanath, Sridatta
• Primary Examiner(s): HAQ, NAEEM U
• Application Number:
  US09/981,147
• Publication Number:
  US 20030074269A1
• Time in Patent Office: 2,430 Days
• Field of Search: 705/26, 705/27
• US Class Current: 705/26.82
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions
• CPC Class Codes: G06Q 30/0637 Approvals

Abstract

A mechanism and method for dynamic criteria-based line grouping for generating purchase orders within a software procurement system. The software system includes a data structure containing line items of a requisition. Each line item contains criteria that can be used to sort the line item to a particular purchase order, e.g., the criteria could include (1) information regarding the supplier, (2) the billed-to address, (3) the send-to address and (4) the currency used to purchase the line item. A configuration file (LGU file) contains the criteria by which the line items are sorted into purchase orders. This configuration can be dynamically altered by the user at any time thereby altering the manner in which the line items are sorted into purchase orders. A line_group table indicates which line items are grouped within a particular purchase order based on the dynamic configuration of the LGU file. A order_header table relates a line_group table to a requisition. A “host PO” object exists within a line_group table and can represent all line items of a requisition for efficient line item processing.

Claims

1. A method for automatically generating purchase orders in a computer implemented procurement system, comprising:

accessing a user modifiable configuration file comprising a selected list of criteria on which line items are to be sorted into purchase orders;

modifying the selected list of criteria in response to user input;

traversing a list of line items associated with a requisition, each line item comprising an item description and criteria data, and automatically grouping said line items of said list into purchase orders wherein all items of a given purchase order have matching criteria data with respect to any criteria of said modified list of criteria;

storing results of said grouping into a line group data structure that is mapped to said requisition, wherein the line group data structure indicates one or more groups of one or more line items according to the results of said grouping; and

generating separate purchase orders according to said line group data structure.

2. A method as described in claim 1 further comprising an order header data structure which provides a mapping between said requisition and said line group data structure.

3. A method ad described in claim 1 wherein said requisition is represented via an electronic shopping cart.

4. A method as described in claim 1 wherein said line group data structure comprises a host purchase order item which includes all of said line items of said requisition.

5. A method as described in claim 1 wherein said modified list of criteria is selected from the group comprising:

suppler name;

billed_to location;

send_to location; and

currency.

6. A method as described in claim 1 further comprising generating said requisition by performing electronic commerce to add items to said requisition which generates said list of line items.

7. A method as described in claim 1 further comprising approving said separate purchase orders.

8. A method as described in claim 1 further comprising:

performing modifications to said list of line items to generate a new list of line items; and

automatically re-grouping said new list of line items into new purchase orders in response to said modifications.

9. A method as described in claim 1 further comprising sending a purchase order in an outbound route to a supplier via an Internet network.

10. A method as described in claim 1 wherein said modifying comprises allowing a user to modify said user modifiable configuration file to alter said selected list of criteria.

11. A system, comprising a bus coupled to a processor and a memory coupled to said bus, said memory comprising instructions that when executed implement a method for automatically generating purchase orders in a computer procurement system, said method comprising:

accessing a user modifiable configuration file comprising a selected list of criteria on which line items are to be sorted into purchase orders;

modifying the selected list of criteria in response to user input;

traversing a list of line items associated with a requisition, each line item comprising an item description and criteria data, and automatically grouping said line items of said list into purchase orders wherein all items of a given purchase order have matching criteria data with respect to any criteria of said modified list of criteria;

storing results of said grouping into a line group data structure that is mapped to said requisition, wherein the line group data structure indicates one or more groups of one or more line items according to the results of said grouping; and

generating separate purchase orders according to said line group data structure.

12. A system as described in claim 11 further comprising an order header data structure which provides a mapping between said requisition and said line group data structure.

13. A system as described in claim 11 wherein said requisition is represented via an electronic shopping cart.

14. A system as described in claim 11 wherein said line group data structure comprises a host purchase order item which includes all of said line items of said requisition.

15. A system as described in claim 11 wherein said modified list of criteria is selected from the group comprising:

supplier name;

bill-to location;

ship-to location; and

currency.

16. A system as described in claim 11 wherein said method further comprises generating said requisition by performing electronic commerce to add items to said requisition which generates said list of line items.

17. A system as described in claim 11 wherein said method further comprises approving said separate purchase orders.

18. A system as described in claim 11 wherein said method further comprises:

performing modifications to said list of line items to generate a new list of line items; and

automatically re-grouping said new list of line items into new purchase orders in response to said modifications.

19. A system as described in claim 11 wherein said method further comprises sending a purchase order in an outbound route to a supplier via an Internet network.

20. A system as described in claim 11 wherein said modifying comprises allowing a user to modify said user modifiable configuration file to alter said selected list of criteria.

21. A method for automatically generating purchase orders in a computer implemented procurement system, comprising:

accessing a user modifiable configuration file comprising a selected list of criteria on which line items are to be sorted into purchase orders;

allowing a user to perform electronic commerce to establish an electronic shopping cart associated with a requisition, said electronic shopping cart comprising a list of line items wherein each line item comprises an item description and criteria data;

modifying the selected list of criteria in response to user input;

automatically grouping said line items of said list into purchase orders wherein all items of a given purchase order have matching criteria data with respect to any criteria of said modified list of criteria;

storing results of said grouping into a line group data structure that is mapped to said requisition via an order header data structure, wherein the line group data structure indicates one or more groups of one or more line items according to the results of said grouping; and

generating separate purchase orders according to said line group data structure.

22. A method as described in claim 21 wherein said line group data structure comprises a host purchase order item which includes all of said line items of said requisition.

23. A method as described in claim 21 wherein said modified list of criteria is selected from the group comprising:

supplier name;

bill-to location;

ship-to location; and

currency.

24. A method as described in claim 21 further comprising approving said separate purchase orders.

25. A method as described in claim 21 further comprising:

performing further electronic commerce to modify said list of line items and generating a new list of line items;

automatically re-grouping said new list of line items into new purchase orders in response to said modifications; and

updating said line group data structure.

26. A method as described in claim 21 further comprising sending a purchase order in an outbound route to a supplier via an Internet network.

27. A method as described in claim 21 wherein said modifying comprises allowing a user to modify said user modifiable configuration file to alter said selected list of criteria.