Inventory balance common object

• US 9,704,120 B2
• Filed: 10/28/2003
• Issued: 07/11/2017
• Est. Priority Date: 03/24/2003
• Status: Active Grant

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Kahlon, Paramjit, Catahan, Jr., Nardo B., Barnes-Leon, Maria Theresa, Garg, Shailendra, Sundararajan, Ramaswamy
• Primary Examiner(s): Refai, Ramsey
• Application Number:
  US10/696,097
• Publication Number:
  US 20070214063A1
• Time in Patent Office: 5,005 Days
• Field of Search: 705 22, 705 28
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 20/203 Inventory monitoring

Abstract

Stored inventory balance information in a first format for use by a first computerized system is transformed to readily make the stored inventory balance information available for use in a second computerized system that utilizes a second format in a cost-efficient and time-efficient manner.

Claims

1. A computer-implemented method for managing inventory, the method comprising:

synchronizing inventory balance information between a source computerized inventory management system and a target computerized inventory management system, wherein

the source computerized inventory management system and the target computerized inventory management system are among a plurality of computerized inventory management systems,

the synchronizing is bi-directional, wherein

the synchronizing is performed by an integration server, and

the synchronizing comprises

extracting inventory balance information in a source format, wherein

the source format is a format used by the source computerized inventory management system, and

the inventory balance information in the source format is associated with the source computerized inventory management system,

converting the inventory balance information in the source format into source inventory balance information in an intermediate format,

receiving target inventory balance information, wherein

the target inventory balance information is associated with the target computerized inventory management system,

converting the target inventory balance information into target inventory balance information in the intermediate format,

generating an inventory balance delta, wherein

the inventory balance delta is calculated as a difference between a source inventory balance and a target inventory balance,

the source inventory balance information in the intermediate format comprises the source inventory balance,

the target inventory balance information in the intermediate format comprises the target inventory balance, and

the generating is performed by the integration server, and

converting the inventory balance delta into inventory balance information in a target format, wherein

the target format is a format used by the target computerized inventory management system,

the inventory balance information in the target format comprises the inventory balance delta, and

the inventory balance information in the target format is associated with the target computerized inventory management system.

2. The computer-implemented method of claim 1, wherein

the receiving the target inventory balance information is performed in response to querying the target computerized inventory management system by the integration server.

3. The computer-implemented method of claim 1, further comprising:

extracting inventory balance information in a second source format that is associated with a second source computerized inventory management system that is distinct from the first source computerized inventory management system, wherein

the second source computerized inventory management system is one of the plurality of computerized inventory management systems;

converting the inventory balance information in the second source format into inventory balance information that is in the intermediate format;

converting the inventory balance information in the intermediate format into inventory balance information in the target format; and

using the inventory balance information in the target format to update an existing inventory balance record in the target computerized inventory management system.

4. The computer-implemented method of claim 1, further comprising:

updating existing inventory balance information using the inventory balance information in the target format, wherein

the existing inventory balance information is in the target format,

the existing inventory balance information is associated with the target computerized inventory management system, and

the updating is based, at least in part, on the inventory balance delta.

5. The computer-implemented method of claim 1, wherein the intermediate format comprises a hierarchy of data elements comprising a plurality of inventory balance elements comprising:

a list of inventory balances element;

an inventory balance related inventory location element;

a list of related inventory balances for defining a plurality of related inventory balances; and

a custom data element for defining customized attributes for the inventory.

6. The computer-implemented method of claim 5, wherein each of the plurality of inventory balance elements comprises a related inventory location element for defining related inventory location identifier.

7. The computer-implemented method of claim 5, wherein each of the plurality of inventory balance elements comprises a list of inventory balance data element for defining a plurality of inventory balance data elements.

8. The computer-implemented method of claim 5, wherein each of the plurality of inventory balance elements comprises an inventory balance custom data.

9. The computer-implemented method of claim 7, wherein each of the plurality of inventory balance data elements comprises a related product element for defining a product identifier.

10. The computer-implemented method of claim 7, wherein each of the plurality of inventory balance data element comprises a list of balance data element for defining a plurality of balance data elements.

11. The computer-implemented method of claim 10, wherein each of the plurality of balance data elements comprises:

a bucket code element;

a quantity of product element;

a product unit of measure code element; and

a balance data custom data element.

23. The computer-implemented method of claim 1, further comprising:

receiving second target inventory balance information, wherein

the second inventory balance information is associated with a second source computerized inventory management system,

converting the second inventory balance information into second source inventory balance information in the intermediate format, and

the generating the inventory balance delta further comprises calculating a second difference between a second source inventory balance and the difference between the source inventory balance and the target inventory balance, wherein

the second source inventory balance information in the intermediate format comprises the second source inventory balance.

24. The computer-implemented method of claim 1, wherein

the source inventory balance information comprises the source inventory balance for a plurality of products;

the target inventory balance information comprises the target inventory balance for the plurality of products; and

the inventory balance delta comprises a plurality of differences between the source inventory balance and the target inventory balance, wherein

each of the plurality of differences indicates a difference between the source inventory balance for one of the plurality of products and a corresponding target inventory balance for the one of the plurality of products.

25. The computer-implemented method of claim 24, wherein the converting the inventory balance delta into inventory balance information in the target format comprises:

converting the inventory balance delta into a plurality of inventory balance information in the target format, wherein

each of the plurality of inventory balance information in the target format is associated with a different one of the plurality of products.

26. The computer-implemented method of claim 1, wherein

the source inventory balance information further comprises a respective source inventory balance at each location of a plurality of locations.

27. The computer-implemented method of claim 1, wherein

the intermediate format comprises a hierarchy of data elements comprising a plurality of inventory balance elements, wherein the plurality of inventory balance elements comprise

a list of inventory balances element,

an inventory balance related inventory location element,

a list of related inventory balances for defining a plurality of related inventory balances, and

a custom data element for defining customized attributes for the inventory,

each of the plurality of inventory balance elements comprises

a related inventory location element for defining a related inventory location identifier,

a list of inventory balance data element for defining a plurality of inventory balance data elements, and

an inventory balance custom data,

each of the plurality of inventory balance data elements comprises

a related product element for defining a product identifier,

a list of balance data element for defining a plurality of balance data elements,

each of the plurality of balance data elements comprises

a bucket code element,

a quantity of product element,

a product unit of measure code element, and

a balance data custom data element

the source inventory balance information comprises a source inventory balance for a plurality of products,

the target inventory balance information comprises a target inventory balance for the plurality of products,

the inventory balance delta comprises a plurality of inventory differences, wherein each of the plurality of inventory differences differences indicates a difference between the source inventory balance for one of the plurality of products and a corresponding target inventory balance for the one of the plurality of products,

the converting the inventory balance delta into inventory balance information in the target format comprises

converting the inventory balance delta into a plurality of inventory balance information in the target format, wherein each of the plurality of inventory balance information in the target format is associated with a respective one of the plurailty of products, and

the source inventory balance information further comprises a respective source inventory balance at each location of a plurality of locations.

12. A computer-readable storage medium carrying one or more sequences of instructions for managing inventory, wherein execution of the one or more sequences of instructions by one or more processors causes the one or more processors to perform:

synchronizing inventory balance information between a source computerized inventory management system and a target computerized inventory management system, wherein

the source computerized inventory management system and the target computerized inventory management system are among a plurality of computerized inventory management systems,

the synchronizing is bi-directional, wherein

the synchronizing is performed by an integration server, and

the synchronizing comprises

extracting inventory balance information in a source format, wherein

the source format is a format used by the source computerized inventory management system, and

the inventory balance information in the source format is associated with the source computerized inventory management system,

converting the inventory balance information in the source format into source inventory balance information in an intermediate format,

receiving inventory balance information, wherein

the target inventory balance information is associated with the target computerized inventory management system,

converting the target inventory balance information into target inventory balance information in the intermediate format,

generating an inventory balance delta, wherein

the inventory balance delta is calculated as a difference between a source inventory balance and a target inventory balance,

the source inventory balance information in the intermediate format comprises the source inventory balance, the target inventory balance information in the intermediate format comprises the target inventory balance, and

the generating is performed by the integration server, and

converting the inventory balance delta into inventory balance information in a target format, wherein

the target format is a format used by the target computerized inventory management system,

the inventory balance information in the target format comprises the inventory balance delta, and

the inventory balance information in the target format is associated with the target computerized inventory management system.

13. The computer-readable storage medium of claim 12, wherein the receiving inventory balance information is performed in response to querying the target computerized inventory management system by the integration server.

14. The computer-readable storage medium of claim 12, further comprising:

extracting inventory balance information in a second source format that is associated with a second source computerized inventory management system that is distinct from the first source computerized inventory management system, wherein

the second source computerized inventory management system is one of the plurality of computerized inventory management systems;

converting the inventory balance information in the second source format into inventory balance information that is in the intermediate format;

converting the inventory balance information in the intermediate format into inventory balance information in the target format; and

using the inventory balance information in the target format to update an existing inventory balance record in the target computerized inventory management system.

15. The computer-readable storage medium of claim 12, further comprising:

updating existing inventory balance information using the inventory balance information in the

target format, wherein

the existing inventory balance information is in the target format,

the existing inventory balance information is associated with the target computerized inventory management system, and

the updating is based, at least in part, on the inventory balance delta.

16. The computer-readable storage medium of claim 12, wherein the intermediate format comprises a hierarchy of data elements comprising a plurality of inventory balance elements comprising:

a list of inventory balances element;

an inventory balance related inventory location element;

a list of related inventory balances for defining a plurality of related inventory balances; and

a custom data element for defining customized attributes for the inventory.

17. The computer-readable storage medium of claim 16, wherein each of the plurality of inventory balance elements comprises a related inventory location element for defining related inventory location identifier.

18. The computer-readable storage medium of claim 16, wherein each of the plurality of inventory balance elements comprises a list of inventory balance data element for defining a plurality of inventory balance data elements.

19. The computer-readable storage medium of claim 16, wherein each of the plurality of inventory balance elements comprises an inventory balance custom data.

20. The computer-readable storage medium of claim 18, wherein each of the plurality of inventory balance data elements comprises a related product element for defining a product identifier.

21. The computer-readable storage medium of claim 18, wherein each of the plurality of inventory balance data elements comprises a list of balance data element for defining a plurality of balance data.

22. The computer-readable storage medium of claim 21, wherein each of the plurality of balance data elements comprises:

a bucket code element;

a quantity of product element;

a product unit of measure code element; and

a balance data custom data element.