Correlating and mapping original orders with new orders for adjusting long running order management fulfillment processes

• US 8,793,262 B2
• Filed: 03/05/2010
• Issued: 07/29/2014
• Est. Priority Date: 03/05/2010
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Addala, Raju, Singh, Alok, Datti, Sunita, Sridharan, Sarita, Siliveri, Lavanya, Malapati, Venkatesh, Baxi, Shailendra
• Primary Examiner(s): Perveen, Rehana
• Assistant Examiner(s): Waldron, Scott A
• Application Number:
  US12/718,468
• Publication Number:
  US 20110218813A1
• Time in Patent Office: 1,607 Days
• Field of Search: 707/755, 707/756
• US Class Current: 707/756
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06Q 10/00 Administration; Management
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 30/00 Commerce
• CPC Class Codes: G06Q 30/0635 Processing of requisition or of purchase orders

Abstract

A computer-readable medium, computer-implemented method, and system are provided. In one embodiment, a new order header object and an original order header object that share a source order number are selected, and one or more new order line objects based on the new order header object are also selected. One or more original order line objects based on the original order header object are selected and the one or more new order line objects and the one or more original order line objects are compared. Where a new order line object and an original order line object match, a reference identity of the new order line object is set to an identity of an original order line object.

Claims

1. A non-transitory computer-readable medium having instructions stored thereon, when executed by a processor, cause the processor to map and correlate a new order object with an original order object for a distributed order orchestration system, the mapping and correlating comprising:

selecting a new order header object and an original order header object that share a source order number;

wherein the original order object comprises an object that represents an original order received from an order capture system, and wherein the new order object comprises an object that represents a new order received from the order capture system that references the original order;

wherein the original order header object comprises an object that contains a hierarchy of the original order, and wherein the new order header object comprises an object that contains a hierarchy of the new order;

selecting one or more new order line objects based on the new order header object, wherein each new order line object comprises an object that contains information of the corresponding order line of the new order;

selecting one or more original order line objects based on the original order header object, wherein each original order line object comprises an object that contains information of the corresponding order line of the original order;

comparing the one or more new order line objects and the one or more original order line objects;

when a new order line object and an original order line object match, setting a reference identity of the new order line object to an identity of an original order line object, wherein the new order line object is mapped to the original order line object;

defining a delta comprising a set of one or more delta line attributes;

comparing one or more line attributes from the new order line object with one or more line attributes from the original order line object using the mapping of the new order line object to the original order line object;

determining whether any changes to the one or more line attributes from the new order line object comprise changes to the delta line attributes;

defining one or more cost of change values for one or more steps of an executable process;

determining whether a sum of the one or more cost of change values is greater than a pre-defined threshold value; and

initiating a change request of the original order when any changes to the one or more line attributes from the new order line object comprise changes to the delta line attributes and when the sum of the one or more cost of changes values is not greater than the pre-defined threshold value.

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

selecting one or more header attributes from the new order header object and the original order header object;

comparing the one or more header attributes; and

when a header attribute of the new order header object matches a header attribute of the original order header object, setting a reference identity of the header attribute of the new order header object to an identity of the header attribute of the original order header object.

3. The non-transitory computer-readable medium of claim 2, the mapping and correlating further comprising:

when the new order line object and the original order line object match, selecting one or more line attributes from the new order line object and the original order line object;

comparing the one or more line attributes; and

when a line attribute of the new order line object matches a line attribute of the original order line object, setting a reference identity of the line attribute of the new order line object to an identity of the line attribute of the original order line object.

4. The non-transitory computer-readable medium of claim 1, the mapping and correlating further comprising:

selecting one or more new fulfillment line objects based on the new order header object;

selecting one or more original fulfillment line objects based on the original order header object;

comparing the one or more new fulfillment line objects and the one or more original fulfillment line objects; and

when a new fulfillment line object and an original fulfillment line object match;

setting a reference identity of the new fulfillment line object to an identity of an original fulfillment line object.

5. The non-transitory computer-readable medium of claim 4, the mapping and correlating further comprising:

selecting one or more header attributes from the new order header object and the original order header object;

comparing the one or more header attributes; and

when a header attribute of the new order header object matches a header attribute of the original order header object, setting a reference identity of the header attribute of the new order header object to an identity of the header attribute of the original order header object.

6. The non-transitory computer-readable medium of claim 5, the mapping and correlating further comprising:

when the new fulfillment line object and the original fulfillment line object match, selecting one or more fulfillment line attributes from the new fulfillment line object and the original fulfillment line object;

comparing the one or more fulfillment line attributes; and

when a fulfillment line attribute of the new fulfillment line object matches a fulfillment line attribute of the original fulfillment line object, setting a reference identity of the fulfillment line attribute of the new fulfillment line object to an identity of the fulfillment line attribute of the original fulfillment line object.

7. A computer-implemented method for mapping and correlating a new order object with an original order object for a distributed order orchestration system, the computer-implemented method comprising:

selecting a new order header object and an original order header object that share a source order number;

wherein the original order object comprises an object that represents an original order received from an order capture system, and wherein the new order object comprises an object that represents a new order received from the order capture system that references the original order;

wherein the original order header object comprises an object that contains a hierarchy of the original order, and wherein the new order header object comprises an object that contains a hierarchy of the new order;

selecting one or more new order line objects based on the new order header object, wherein each new order line object comprises an object that contains information of the corresponding order line of the new order;

selecting one or more original order line objects based on the original order header object, wherein each original order line object comprises an object that contains information of the corresponding order line of the original order;

comparing the one or more new order line objects and the one or more original order line objects;

when a new order line object and an original order line object match, setting a reference identity of the new order line object to an identity of an original order line object, wherein the new order line object is mapped to the original order line object;

defining a delta comprising a set of one or more delta line attributes;

comparing one or more line attributes from the new order line object with one or more line attributes from the original order line object using the mapping of the new order line object to the original order line object;

determining whether any changes to the one or more line attributes from the new order line object comprise changes to the delta line attributes;

defining one or more cost of change values for one or more steps of an executable process;

determining whether a sum of the one or more cost of change values is greater than a pre-defined threshold value; and

initiating a change request of the original order when any changes to the one or more line attributes from the new order line object comprise changes to the delta line attributes and when the sum of the one or more cost of changes values is not greater than the pre-defined threshold value.

8. The computer-implemented method of claim 7, further comprising:

selecting one or more header attributes from the new order header object and the original order header object;

comparing the one or more header attributes; and

when a header attribute of the new order header object matches a header attribute of the original order header object, setting a reference identity of the header attribute of the new order header object to an identity of the header attribute of the original order header object.

9. The computer-implemented method of claim 8, further comprising:

when the new order line object and the original order line object match, selecting one or more line attributes from the new order line object and the original order line object;

comparing the one or more line attributes; and

when a line attribute of the new order line object matches a line attribute of the original order line object, setting a reference identity of the line attribute of the new order line object to an identity of the line attribute of the original order line object.

10. The computer-implemented method of claim 7, further comprising:

selecting one or more new fulfillment line objects based on the new order header object;

selecting one or more original fulfillment line objects based on the original order header object;

comparing the one or more new fulfillment line objects and the one or more original fulfillment line objects; and

when a new fulfillment line object and an original fulfillment line object match, setting a reference identity of the new fulfillment line object to an identity of an original fulfillment line object.

11. The computer-implemented method of claim 10, further comprising:

selecting one or more header attributes from the new order header object and the original order header object;

comparing the one or more header attributes; and

when a header attribute of the new order header object matches a header attribute of the original order header object, setting a reference identity of the header attribute of the new order header object to an identity of the header attribute of the original order header object.

12. The computer-implemented method of claim 11, further comprising:

when the new fulfillment line object and the original fulfillment line object match, selecting one or more fulfillment line attributes from the new fulfillment line object and the original fulfillment line object;

comparing the one or more fulfillment line attributes; and

when a fulfillment line attribute of the new fulfillment line object matches a fulfillment line attribute of the original fulfillment line object, setting a reference identity of the fulfillment line attribute of the new fulfillment line object to an identity of the fulfillment line attribute of the original fulfillment line object.

13. An orchestration system, comprising:

a processor;

a decomposition module, when executed by the processor, configured to select a new order header object and an original order header object that share a source order number,

wherein the original order header object comprises an object that contains a hierarchy of an original order received from an order capture system, and wherein the new order header object comprises an object that contains a hierarchy of a new order received from the order capture system that references the original order,

wherein the decomposition module is further configured to select one or more new order line objects based on the new order header object, wherein each new order line object comprises an object that contains information of the corresponding order line of the new order,

wherein the decomposition module is further configured to select one or more original order line objects based on the original order header object, wherein each original order line object comprises an object that contains information of the corresponding order line of the original order,

wherein the decomposition module is further configured to compare the one or more new order line objects and the one or more original order line objects,

wherein, when a new order line object and an original order line object match, the decomposition module is further configured to set a reference identity of the new order line object to an identity of an original order line object, wherein the new order line object is mapped to the original order line object;

wherein the decomposition module is further configured to define a delta comprising a set of one or more delta line attributes;

wherein the decomposition module is further configured to compare one or more line attributes from the new order line object with one or more line attributes from the original order line object using the mapping of the new order line object to the original order line object;

wherein the decomposition module is further configured to determine whether any changes to the one or more line attributes from the new order line object comprise changes to the delta line attributes;

wherein the decomposition module is further configured to define one or more cost of change values for one or more steps of an executable process;

wherein the decomposition module is further configured to determine whether a sum of the one or more cost of change values is greater than a pre-defined threshold value; and

wherein the decomposition module is further configured to initiate a change request of the original order when any changes to the one or more line attributes from the new order line object comprise changes to the delta line attributes and when the sum of the one or more cost of changes values is not greater than the pre-defined threshold value.

14. The orchestration system of claim 13,

wherein the decomposition module is further configured to select one or more header attributes from the new order header object and the original order header object,

wherein the decomposition module is further configured to compare the one or more header attributes, and

wherein, when a header attribute of the new order header object matches a header attribute of the original order header object, the decomposition module is further configured to set a reference identity of the header attribute of the new order header object to an identity of the header attribute of the original order header object.

15. The orchestration system of claim 14,

wherein, when the new order line object and the original order line object match, the decomposition module is further configured to select one or more line attributes from the new order line object and the original order line object,

wherein the decomposition module is further configured to compare the one or more line attributes, and

wherein, when a line attribute of the new order line object matches a line attribute of the original order line object, the decomposition module is further configured to setting a reference identity of the line attribute of the new order line object to an identity of the line attribute of the original order line object.

16. The orchestration system of claim 13,

wherein the decomposition module is further configured to select one or more new fulfillment line objects based on the new order header object,

wherein the decomposition module is further configured to select one or more original fulfillment line objects based on the original order header object,

wherein the decomposition module is further configured to compare the one or more new fulfillment line objects and the one or more original fulfillment line objects, and

wherein, when a new fulfillment line object and an original fulfillment line object match, the decomposition module is further configured to set a reference identity of the new fulfillment line object to an identity of an original fulfillment line object.

17. The orchestration system of claim 16,

wherein the decomposition module is further configured to select one or more header attributes from the new order header object and the original order header object,

wherein the decomposition module is further configured to compare the one or more header attributes, and

wherein, when a header attribute of the new order header object matches a header attribute of the original order header object, the decomposition module is further configured to set a reference identity of the header attribute of the new order header object to an identity of the header attribute of the original order header object.

18. The orchestration system of claim 17,

wherein, when the new fulfillment line object and the original fulfillment line object match, the decomposition module is further configured to select one or more fulfillment line attributes from the new fulfillment line object and the original fulfillment line object,

wherein the decomposition module is further configured to compare the one or more fulfillment line attributes, and

wherein, when a fulfillment line attribute of the new fulfillment line object matches a fulfillment line attribute of the original fulfillment line object, the decomposition module is further configured to set a reference identity of the fulfillment line attribute of the new fulfillment line object to an identity of the fulfillment line attribute of the original fulfillment line object.