Supply chain orchestration system with configure-to-order item matching

• US 9,767,499 B2
• Filed: 09/28/2013
• Issued: 09/19/2017
• Est. Priority Date: 09/28/2012
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Daniel, Thomas, Ranjan, Kshitij, Brand, William, Lizio, Michael, Merenda, Stephanie
• Primary Examiner(s): Desai, Resha
• Assistant Examiner(s): WOOD, ALLISON G
• Application Number:
  US14/040,631
• Publication Number:
  US 20140095343A1
• Time in Patent Office: 1,452 Days
• Field of Search: 705 261- 272, 705 265, 705 268, 705 2681, 707770, 707706
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06F 7/02 Comparing digital values G06F7/06, G06F7/22, G06F7/38 take precedence
• CPC Class Codes: G06Q 10/06315 Needs-based resource requirements planning or analysis
• CPC Class Codes: G06Q 30/0603 Catalogue ordering
• CPC Class Codes: G06Q 30/0621 Item configuration or customization
• CPC Class Codes: G06Q 30/0633 Lists, e.g. purchase orders, compilation or processing
• CPC Class Codes: G06Q 30/0635 Processing of requisition or of purchase orders

Abstract

A system is provided that searches and matches data. The system receives a payload including one or more data values, where the one or more data values represent an item configuration. The system further generates a match key for the payload that includes at least one data value of the one or more data values. The system further compares the match key with one or more match keys stored in a match repository. The system further retrieves a configuration item identity from the match repository when the match key matches a match key stored in the match repository, where the configuration item identity represents a previously ordered item configuration. The system further generates a new configuration item identity when the match key does not match a match key stored in the match repository, where the new configuration item identity represents the item configuration.

Claims

1. A computer-readable non-transitory medium having instructions stored thereon that, when executed by a processor, cause the processor to search and match data, the searching and matching comprising:

receiving an XML (Extensible Markup Language) payload comprising a data value representing an item configuration;

generating a first match key for the payload that comprises the data value;

comparing the first match key with a second match key stored in a match repository using a relational database management system;

retrieving a configuration item identity from the match repository when the first match key exactly matches the second match key, wherein the configuration item identity represents a previously ordered item configuration;

generating a new configuration item identity when the first match key does not match the second match key, wherein the new configuration item identity represents the item configuration; and

fulfilling an order based on the retrieved or the new configuration item identity and wherein the retrieved or new configuration item identity comprises a value separate and distinct from the first and second match key.

2. The computer-readable non-transitory medium of claim 1, the searching and matching further comprising:

receiving the order for the item configuration; and

generating the payload.

3. The computer-readable non-transitory medium of claim 1, the searching and matching further comprising configuring a transactional item attribute data value that is contained within the first match key.

4. The computer-readable non-transitory medium of claim 1, wherein the generating the first match key and the comparing the first match key with the second match key is performed in volatile memory.

5. The computer-readable non-transitory medium of claim 1, wherein the first match key comprises a combination of a key, a data value of the payload, and a delineator.

6. The computer-readable non-transitory medium of claim 1, the searching and matching further comprising storing the new configuration item identity and the item configuration within a database.

7. The computer-readable non-transitory medium of claim 1, the searching and matching further comprising storing the new configuration item identity and the item configuration within the match repository.

8. The computer-readable non-transitory medium of claim 7, wherein the match repository is stored within a database.

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

wherein the match repository comprises a match record comprising configuration options, including a match header record, a match detail record, and a match transactional item attribute detail record;

and

wherein each match header record comprises a match key.

10. The computer-readable non-transitory medium of claim 1, wherein an item configuration comprises an item header that represents a base item, an item component that represents a part or feature of the base item, and an item sub-component that represents a configuration option for the item component.

11. A computer-implemented method for searching and matching data, the computer-implemented method comprising:

receiving, by a computer processor, an XML(Extensible Markup Language) payload comprising a data value representing an item configuration;

generating, by the computer processor, a first match key for the payload that comprises the data value;

comparing, by the computer processor, the first match key with a second match key stored in a match repository using a relational database management system;

retrieving, by the computer processor, a configuration item identity from the match repository when the first match key exactly matches the second match key, wherein the configuration item identity represents a previously ordered item configuration;

generating, by the computer processor, a new configuration item identity when the first match key does not match the second match key, wherein the new configuration item identity represents the item configuration; and

fulfilling an order based on the retrieved or the new configuration item identity and wherein the retrieved or new configuration item identity comprises a value separate and distinct from the first and second match key.

12. The computer-implemented method of claim 11, the searching and matching further comprising configuring a transactional item attribute data value that is contained within the first match key.

13. The computer-implemented method of claim 11, wherein the generating of the first match key and the comparing the first match key with the second match key is performed in volatile memory.

14. The computer-implemented method of claim 11, wherein the first match key comprises a combination of a key, a data value of the payload, and a delineator.

15. The computer-implemented method of claim 11, wherein an item configuration comprises an item header that represents a base item, an item component that represents a part or feature of the base item, and an item sub-component that represents a configuration option for the item component.

16. A system, comprising:

a processor configured to execute a collection of software modules, wherein the processor is further configured, when executing the collection of software modules, to;

receive an XML (Extensible Markup Language) payload comprising a data value representing an item configuration;

generate a first match key for the payload that comprises a data value;

compare the first match key with a second match key stored in a match repository using a relational database management system;

retrieve a configuration item identity from the match repository when the first match key exactly matches the second match key stored in the match repository, wherein the configuration item identity represents a previously ordered item configuration;

generate a new configuration item identity when the first match key does not match the second match key, wherein the new configuration item identity represents the item configuration; and

fulfill an order based on the retrieved or the new configuration item identity and wherein the retrieved or new configuration item identity comprises a value separate and distinct from the first and second match key.

17. The system of claim 16, further comprising generating a transactional item attribute data value that is contained within the first match key.

18. The system of claim 16, wherein the first match key is stored in volatile memory, and

wherein the first match key is compared to the second match key stored in volatile memory.

19. The system of claim 16, wherein the first match key comprises a combination of a key, a data value of the payload, and a delineator.

20. The system of claim 16, wherein an item configuration comprises an item header that represents a base item, an item component that represents a part or feature of the base item, and an item sub-component that represents a configuration option for the item component.

21. The system of claim 16, further comprising updating the match repository with the new configuration item identity.