System and method for managing a regulated industry

• US 7,925,550 B2
• Filed: 08/09/2004
• Issued: 04/12/2011
• Est. Priority Date: 01/23/2001
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Kataria, Anjali Rani, Desai, Kamlesh Rashmi
• Primary Examiner(s): Zeender; F. Ryan
• Assistant Examiner(s): ALMATRAHI, FARIS S
• Application Number:
  US10/914,538
• Publication Number:
  US 20050015166A1
• Time in Patent Office: 2,437 Days
• Field of Search: None
• US Class Current: 705/28
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders

Abstract

A system and a method enable supply chain solutions for regulated industries. The embodiments facilitate regulatory and tax compliance management integrated with smart inventory and e-warehouse management solutions. The embodiments are applicable to heavily regulated industries such as, for example, beverages, food, oil, pharmachemicals, and chemicals.

Claims

1. A system for managing a regulated industry, the system comprising:

a processor; and

a memory having stored therein instructions which, when executed by the processor, cause the processor to provide;

an inventory management module tracking goods in the regulated industry;

a process module receiving data pertaining to a plurality of stages of a manufacturing process of the regulated industry and instructions for generating an audit trail;

a regulation module collecting information for regulations governing the regulated industry including regulatory compliance information and tax compliance information, processing data from the manufacturing process of the regulated industry and relating to the regulations governing the regulated industry, and preparing a plurality of statutory reports including compliance reports and tax reports based on the collected information for the regulations governing the regulated industry; and

a core module, wherein the core module is coupled to the inventory management module, the process module, and the regulation module, and coordinates the operation of the modules, wherein the core module comprises a global configuration module and a functional configuration module, wherein the global configuration module allows for user assisted set up of a currency designation, a language designation, a country designation, and a state designation, and wherein the function configuration module allows for user assisted set up of a numbering range of a plurality of records, an activity in a work-order, a location, a buyer code, an item category, a tank number, a barrel number, a lot number, a composition, and a vintage.

2. The system of claim 1, wherein the data pertaining to a plurality of stages of the manufacturing process of the regulated industry is a recipe or process for making a product in accordance with regulations in the regulated industry.

3. The system of claim 1, further comprising:

a content management module providing company-specific or supplier-specific information.

4. The system of claim 3, wherein the company-specific information or supplier-specific information is arranged in a hierarchical format.

5. The system of claim 3, wherein the company-specific information is arranged in a plurality of groups wherein access to documents in a group in said plurality of groups is only granted to select users associated with the group.

6. The system of claim 3, wherein the company-specific information is searchable based on meta data values.

7. The system of claim 1, wherein the regulated industry is the beverage industry or the wine industry.

8. The system of claim 1, wherein the regulated industry is the beer industry, the spirits industry, the soft drink industry, the oil industry, the petroleum industry, the cosmetics industry, the pharmaceutical industry, the toxic chemical industry, the nontoxic chemical industry, or the food/grocery industry.

9. The system of claim 1, wherein the work order is a recipe or process for making a product in accordance with regulations in the regulated industry.

10. The system of claim 1, wherein the activity is a receiving step, a crushing/desteming step, a fermentation step, a desteming step, a rack and clear step, a fine stabilizing step, a filtering step, or a bottling step.

11. The system of claim 1, wherein the item category has a name, description, and parent identifier.

12. The system of claim 1, wherein the buyer code is the user identifier of a person responsible for purchasing.

13. The system of claim 1, wherein the composition specifies a varietal and appellation of grapes.

14. The system of claim 1, wherein the core module comprises a functional interface that houses an item master module that comprises a plurality of views for items in a plurality of items.

15. The system of claim 14, wherein the plurality of views comprise any combination of a general view, a purchasing view, a storage view, an accounting view, and a costing view.

16. The system of claim 15, wherein the plurality of views are classified based on general information, purchasing information, storage information and inventory information.

17. The system of claim 15, wherein the general view comprises an item description, a base unit of measure, an alternate unit of measure, a physical dimension, a weight, a volume, a unit of weight, an active/inactive flag, a composition, an item category for catalog hierarchy, and/or a meta data element for user search.

18. The system of claim 15, wherein the purchasing view comprises an item category, a procurement time, a lot indicator, an inspection flag, a buyer code, a purchase comment, and/or a source list.

19. The system of claim 15, wherein the purchasing view tracks the procurement of one or more items including where each item in the one or more items originated.

20. The system of claim 19, wherein the purchasing view associates an inspection flag with each item in said one or more items.

21. The system of claim 15, wherein the storage view comprises an issue unit of measure, a physical inventory verification type, a shelf life data description, a storage location quantity, and/or a storage condition.

22. The system of claim 1, wherein the core module comprises a supplier master module that includes a general view, a purchasing view, and/or an accounting view.

23. The system of claim 22, wherein the general view comprises a supplier name, a supplier address, a supplier telephone number, a supplier FAX number, a supplier E-mail address, a category, a sub-category, a meta-data element, and/or a supplier status flag.

24. The system of claim 22, wherein the supplier master module comprises instructions for generation of a supplier master report based on any combination of a data range, an organization unit, and a category.

25. The system of claim 1, wherein the regulated industry is the wine industry and wherein the process module comprises means for generating a Bureau of Alcohol, Tobacco, and Firearms Form 702.

26. The system of claim 1, wherein the regulated industry is the wine industry and wherein the process module tracks a plurality of records, and wherein each record in the plurality of records is categorized as an activity work order, an analysis record, an inventory record, or a tank/barrel record.

27. The system of claim 26, wherein the activity work order is associated with an act of receiving grapes, an act of crushing and desteming, an act of pumping, an act of cooling, an act of fermenting in a tank, an act of pressing, an act of storage and settling in a tank, an act or racking and clearing, an act of aging in a tank or barrel, an act of stabilizing, an act of filtering, or an act of bottling.

28. The system of claim 1, wherein the regulated industry is the wine industry and wherein the process module comprises instructions for managing a wine making process associated with a plurality of lots, wherein each lot in said plurality of lots represents a variation of grapes received.

29. The system of claim 28, wherein the process module comprises instructions for assigning a unique lot number to every lot in said plurality of lots.

30. The system of claim 28, wherein the process module comprises instructions for assigning a unique sub-lot number to a portion of a lot in said plurality of lots.

31. The system of claim 28, wherein the process module comprises instructions for receiving an activity-work order, before an activity in the wine making process, that records the activity, a lot process associated with the activity, an input to the activity, an origination of the input to the activity, an identity of a piece of equipment used in the activity, and/or a detail of the activity.

32. The system of claim 31, wherein the activity is crushing and desteming, an act of pumping, an act of cooling, an act of fermenting in a tank, an act of pressing, an act of storage and settling in a tank, an act of blending, an act or racking and clearing, an act of aging in a tank or barrel, an act of stabilizing, an act of filtering, or an act of bottling.

33. The system of claim 32, wherein, when the activity is an act of blending, a new lot number is assigned to the resultant blend.

34. The system of claim 32, wherein the activity-work order comprises one or more line items selected from the group consisting of:

an activity-work order name, a lot number, an origination lot number location, a destination lot number location, a quantity, an indication whether the quantity is added or removed, and a quality.

35. The system of claim 28, wherein the process module comprises instructions for constructing a summary record of a lot in said plurality of lots, wherein said summary record records any combination of a detail of a supplier of the lot, a quality of the lot, a shelf-life of the lot, and a status of the lot.

36. The system of claim 28, wherein the process module comprises instructions for maintaining a lab record of the wine making process and wherein the lab record includes a plurality of fermentation control records, wherein each fermentation control record in said plurality of fermentation control records is associated with a tank or a lot.

37. The system of claim 28, wherein the process module comprises instructions for maintaining a plurality of tank/barrel records wherein each tank/barrel record in said plurality of tank/barrel records comprises a status of a tank or barrel, wherein said status comprises one or more of a barrel/tank kind, an activity, and/or a tank/barrel property.

38. The system of claim 37, wherein said activity is a result of an inspection, a top, a fill, or a toast.

39. The system of claim 28, wherein the process module comprises instructions for creating a report as a function of a data range, a location, a tank, a barrel, a lot, or a category.

40. The system of claim 1, wherein the inventory management module comprises instructions for searching by a storage location, an item, a key word for an item, a combination of storage locations, or an item category.

41. The system of claim 1, wherein the inventory management module comprises:

instructions for defining a group;

instructions for defining an alert for an item, wherein said alert is fired when an inventory status of the item falls below a predetermined level; and

instructions for notifying said group when said alert is fired.

42. The system of claim 1, wherein the inventory management module comprises:

instructions for defining a group;

instructions for defining an alert for an item, wherein said alert is fired when an inventory status of the item exceeds a predetermined level; and

instructions for notifying said group when said alert is fired.

43. The system of claim 1, wherein the regulated industry is the wine industry and wherein the inventory module comprises a user interface that enables a user to record physical verification of cellar materials, bulk wine or cased goods.

44. The system of claim 1, wherein the inventory module comprises instructions for reconciling a physical inventory with a book inventory.

45. The system of claim 1, tracking goods in the regulated industry comprise tracking receipt of goods, issue of goods, movement of goods, and verification of goods location.

46. The system of claim 1, further comprising a supplier module providing information about a plurality of suppliers and items provided by each supplier in the plurality of suppliers.

47. The system of claim 46, wherein the supplier module comprises instructions for searching by supplier and instructions for searching by item.

48. The system of claim 46, wherein the supplier module comprises instructions for uploading a supplier catalog that includes, for each respective product in a plurality of products, a product identifier, a product description, and/or a product range.

49. The system of claim 46, wherein the supplier module comprises:

instructions for receiving a query for an item; and

instructions for providing details of each supplier in the plurality of suppliers that sells said item.

50. The system of claim 1, wherein the regulation module prepares a form 5120.17 based on transactions tracked by the process module and the inventory module.

51. The system of claim 1, wherein the system is provided to a customer under a license model or an application service provider model.

52. The system of claim 1, wherein the system supports a Secure Socket Layer.

53. The system of claim 1, wherein the system is maintained on a web server and is accessed through a web browser on a remote computer.

87. The system of claim 1, wherein the data pertaining to the plurality of stages of the manufacturing process of the regulated industry includes lab analysis data.

88. The system of claim 1, wherein the core module further provides user management, role and security management, organization structure management, system administration, and alert functions.

89. The system of claim 1, wherein coordinating the operation of the modules comprises tracking the data pertaining to the plurality of stages of the manufacturing process across the plurality of stages of the manufacturing process.

54. A computer readable storage medium having stored thereon a series of instructions which, when executed by a processor, cause the processor to provide a mechanism for managing an unregulated industry by executing:

an inventory management module tracking goods in a regulated industry;

a process module receiving data pertaining to a plurality of stages of a manufacturing process of the regulated industry and instructions for generating an audit trail;

a regulation module collecting information for regulations governing the regulated industry including regulatory compliance information and tax compliance information, processing data from the manufacturing process of the regulated industry and relating to the regulations governing the regulated industry, and preparing a plurality of statutory reports including compliance reports and tax reports based on the collected information for the regulations governing the regulated industry; and

a core module, wherein the core module is coupled to the inventory management module, the process module, and the regulation module, and coordinates the operation of the modules, wherein the core module comprises a global configuration module and a functional configuration module, wherein the global configuration module allows for user assisted set up of a currency designation, a language designation, a country designation, and a state designation, and wherein the function configuration module allows for user assisted set up of a numbering range of a plurality of records, an activity in a work-order, a location, a buyer code, an item category, a tank number, a barrel number, a lot number, a composition, and a vintage.

55. The computer readable storage medium of claim 54, wherein the data pertaining to a plurality of stages of the manufacturing process of the regulated industry is a recipe or process for making a product in accordance with regulations in the regulated industry.

56. The computer readable storage medium of claim 54, wherein the processor further provides:

a content management module, wherein the content management module comprises instructions for providing company-specific or supplier-specific information.

57. The computer program product of claim 56, wherein the company-specific information or supplier-specific information is arranged in a hierarchical format.

58. The computer program product of claim 56, wherein the company-specific information is arranged in a plurality of groups wherein access to documents in a group in said plurality of groups is only granted to select users associated with the group.

59. The computer readable storage medium of claim 56, wherein the company-specific information is searchable based on meta data values.

60. The computer program product of claim 54, wherein the regulated industry is the beverage industry or the wine industry.

61. The computer program product of claim 54, wherein the regulated industry is the beer industry, the spirits industry, the soft drink industry, the oil industry, the petroleum industry, the cosmetics industry, the pharmaceutical industry, the toxic chemical industry, the nontoxic chemical industry, or the food/grocery industry.

62. The computer readable storage medium of claim 54, wherein the work order is a recipe or process for making a product in accordance with regulations in the regulated industry.

63. The computer readable storage medium of claim 54, wherein the activity is a receiving step, a crushing/desteming step, a fermentation step, a desteming step, a rack and clear step, a fine stabilizing step, a filtering step, or a bottling step.

64. The computer program product of claim 54, wherein the regulated industry is the wine industry and wherein the process module comprises means for generating a Bureau of Alcohol, Tobacco, and Firearms Form 702.

65. The computer program product of claim 54, wherein the regulated industry is the wine industry and wherein the process module tracks a plurality of records, and wherein each record in the plurality of records is categorized as an activity work order, an analysis record, an inventory record, or a tank/barrel record.

66. The computer program product of claim 65, wherein the activity work order is associated with an act of receiving grapes, an act of crushing and desteming, an act of pumping, an act of cooling, an act of fermenting in a tank, an act of pressing, an act of storage and settling in a tank, an act or racking and clearing, an act of aging in a tank or barrel, an act of stabilizing, an act of filtering, or an act of bottling.

67. The computer program product of claim 54, wherein the regulated industry is the wine industry and wherein the process module comprises instructions for managing a wine making process associated with a plurality of lots, wherein each lot in said plurality of lots represents a variation of grapes received.

68. The computer program product of claim 67, wherein the process module comprises instructions for assigning a unique lot number to every lot in said plurality of lots.

69. The computer program product of claim 67, wherein the process module comprises instructions for assigning a unique sub-lot number to a portion of a lot in said plurality of lots.

70. The computer program product of claim 67, wherein the process module comprises instructions for receiving an activity-work order, before an activity in the wine making process, that records the activity, a lot process associated with the activity, an input to the activity, an origination of the input to the activity, an identity of a piece of equipment used in the activity, and/or a detail of the activity.

71. The computer program product of claim 70, wherein the activity is crushing and desteming, an act of pumping, an act of cooling, an act of fermenting in a tank, an act of pressing, an act of storage and settling in a tank, an act of blending, an act or racking and clearing, an act of aging in a tank or barrel, an act of stabilizing, an act of filtering, or an act of bottling.

72. The computer program product of claim 54, wherein the inventory management module comprises instructions for searching by a storage location, an item, or a key word.

73. The computer program product of claim 54, wherein the inventory management module comprises:

instructions for defining a group;

instructions for defining an alert for an item, wherein said alert is fired when an inventory status of the item falls below a predetermined level; and

instructions for notifying said group when said alert is fired.

74. The computer program product of claim 54, wherein the inventory management module comprises:

instructions for defining a group;

instructions for defining an alert for an item, wherein said alert is fired when an inventory status of the item exceeds a predetermined level; and

instructions for notifying said group when said alert is fired.

75. The computer readable storage medium of claim 54, wherein the regulated industry is the wine industry and wherein the inventory module comprises a user interface that enables a user to record physical verification of cellar materials, bulk wine or cased goods.

76. The computer program product of claim 54, wherein the inventory module comprises instructions for reconciling a physical inventory with a book inventory.

77. The computer readable storage medium of claim 54, wherein tracking goods in the regulated industry comprises tracking issue of goods, movement of goods, and verification of goods location.

78. The computer readable storage medium of claim 54, wherein the processor further executes a supplier module providing information about a plurality of suppliers and items provided by each supplier in the plurality of suppliers.

79. The computer program product of claim 78, wherein the supplier module comprises instructions for searching by supplier and instructions for searching by item.

80. The computer readable storage medium of claim 54, wherein the regulation module prepares a form 5120.17 based on transactions tracked by the process module and the inventory module.

81. The computer program product readable storage of claim 54, wherein data can be entered by a mobile device that has a bar code reader.

82. The computer readable storage of claim 54, wherein the processor further executes a floating license manager that comprises instructions for maintaining one or more licenses to the inventory management module, the process module, the regulation module and/or the core module.

83. The computer program product of claim 54, wherein the regulated industry is the wine industry, the beer industry, the spirits industry, the soft drink industry, the oil industry, the petroleum industry, the cosmetics industry, the pharmaceutical industry, the toxic chemical industry, the nontoxic chemical industry, or the food/grocery industry.

84. The computer readable storage of claim 54, wherein the mechanism is provided to a customer under a license model or an application service provider model.

85. The computer readable storage of claim 54, wherein the mechanism supports a Secure Socket Layer.

86. The computer readable storage of claim 54, wherein the mechanism is maintained on a web server and is accessed through a web browser on a remote computer.