Data processing system and method for supply chain management

Abstract

The data processing system has an online transactional processing (OLTP) system for receiving of reporting data from work centers of a production line. The production line is logically divided into shop areas. At the exits of each shop area where an intermediate product is completed one reporting point serves as exit point in order to report the completion of an intermediate production step. This data is stored in the OLTP system and retrieved at a later point of time in order to generate a table containing aggregated intermediate product quantities per shop area. This table is transferred to a financial data server for calculation of the value of work in progress.

1 . A data processing system, comprising:
 an online transactional processing system for receiving reporting data from a set of reporting points of work centers of a production line for producing a product, wherein the production line is logically divided into shop areas, one reporting point of each shop area being an exit point corresponding to an intermediate production step, the online transactional processing system comprising:
 a database for storing the reporting data, and 
 a first storage for storing a first table comprising aggregated quantities of intermediate products at the exit points generated on the basis of the reporting data stored in the database, and 
   a server computer comprising:
 a second storage for storing a second table comprising value increments per shop area, and 
 a processor for calculating a total value of the work in progress based on the first and second tables, 
 wherein the first table from the first storage of the online transactional processing system is transferred to the processor of the server computer. 
   
     
     
         2 . The data processing system of  claim 1 , wherein the reporting data comprises data indicative of an originating reporting point and of a quantity of an intermediate product. 
     
     
         3 . The data processing system of  claim 1 , wherein the database comprises a relational database. 
     
     
         4 . The data processing system of  claim 1 , wherein the online transactional processing system queries the database to retrieve quantities of the intermediate products. 
     
     
         5 . The data processing system of  claim 1 , the online transactional processing system further comprising:
 a timer for initiating the generation of the first table.   
     
     
         6 . The data processing system of  claim 1 , wherein the server computer further comprises:
 an electronic ledger coupled to the processor.   
     
     
         7 . The data processing system of  claim 1 , further comprising:
 a master data server for storing routing data and data descriptive of the shop areas and exit points, the master data server being coupled to the online transactional processing system and to the server computer.   
     
     
         8 . The data processing system of  claim 7 , wherein the processor of the server computer calculates the second table on the basis of master data stored on the master data server. 
     
     
         9 . A computer readable storage medium comprising program instructions embodying a method for calculating of a value of work in progress, the program instructions comprising:
 a first set of instructions for execution by a first processor of an online transactional processing system for receiving reporting data from a set of reporting points of work centers of a production line for producing a product, the production line being logically divided into shop areas, one reporting point of each shop area being an exit point corresponding to an intermediate production step, the reporting data being stored in a database, the first set of instructions operable to generate a first table comprising aggregated quantities of intermediate products at the exit points on the basis of the reporting data stored in the database and operable to store the first table in a first storage of the online transactional processing system, and   a second set of instructions for execution by a second processor of a server computer coupled to the online transactional processing system, the server computer having a second storage for storing a second table comprising value increments per shop area, the second set of instructions operable to calculate a total value of the work in progress based on the first and second tables.   
     
     
         10 . The computer readable storage medium of  claim 9 , further comprising:
 a third set of instructions for initiating a transfer of the first table from the first storage of the online transactional processing system to the server computer.   
     
     
         11 . The computer readable storage medium of  claim 9 , further comprising:
 a fourth set of instructions for performing a database query in order to retrieve quantities of the intermediate products.   
     
     
         12 . The computer readable storage medium of  claim 9 , further comprising:
 a fourth set of instructions for calculating the second table on the basis of master data stored on a master data server.   
     
     
         13 . A method of calculating of a value of work in progress on the basis of reporting data received from a set of reporting points of work centers of a production line for producing a product, the production line being logically divided into shop areas, one reporting point of each shop area being an exit point corresponding to an intermediate production step, the method comprising the steps of:
 receiving the reporting data by an online transactional processing system,   storing the reporting data in a database of the online transactional processing system,   generating a first table comprising aggregated quantities of intermediate products and aggregated scrap quantities reported from the exit points on the basis of the reporting data stored in the database,   storing the first table in a first storage means of the online transactional processing system,   transferring of the first table from the first storage to a server computer, the server computer having a second storage for storing a second table comprising value increments per shop area, and   calculating a total value of the work in progress based on the first and second tables by the server computer.   
     
     
         14 . The method of  claim 13 , further comprising:
 performing a database query to retrieve quantities of the intermediate products and scrap quantities.   
     
     
         15 . The method of  claim 13 , further comprising:
 initiating the transfer of the first table from the first storage of the online transactional processing system to the server computer at pre-scheduled time intervals or in response to a request received from the server computer.   
     
     
         16 . A data processing system, comprising:
 an online transactional processing system configured to receive reporting data from a set of reporting points of a production line for producing a product, the production line including shop areas, a reporting point of each shop area being an exit point corresponding to an intermediate production step, the online transactional processing system configured to generate a first table from the reporting data, the first table comprising a set of entries, each entry of the set of entries associated with a corresponding shop area and including an aggregated quantity of intermediate product associated with the exit point of the corresponding shop area; and   a financial data server in communication with the online transactional processing system, the financial data server configured to receive the first table from the online transactional processing system, configured to store a second table including a second set of entries, each entry of the second set of entries associated with a shop area and including value increment, and configured to determine a fiscal amount associated with work in progress based on the first table and the second table.   
     
     
         17 . The system of  claim 16 , further comprising a master data server in communication with the financial data server. 
     
     
         18 . The system of  claim 16 , wherein the financial data server is configured to generate the fiscal amount in response to receiving the first table from the online transactional processing system. 
     
     
         19 . A data processing method, comprising:
 receiving a first table including quantities of intermediate products at one or more points along a production line for producing products;   generating a second table including value increments of the intermediate products at the one or more points; and   calculating, using a processor, a total value of the intermediate products in progress of production based on the first table and the second table.   
     
     
         20 . The method of  claim 19 , wherein the first table is generated based on reports including the quantities of the intermediate products at the one or more points. 
     
     
         21 . The method of  claim 19 , further comprising:
 receiving master data including information on the production line,   wherein the second table is generated based on the master data.   
     
     
         22 . A data processing server, comprising:
 an interface for receiving a first table including quantities of intermediate products at one or more points along a production line for producing products;   a storage for storing a second table including value increments of the intermediate products at the one or more points; and   a processor for calculating a total value of the intermediate products in progress of production based on the first table and the second table.   
     
     
         23 . The server of  claim 22 , wherein the first table is generated based on reports including the quantities of the intermediate products at the one or more points. 
     
     
         24 . The server of  claim 22 , wherein:
 the interface receives master data including information on the production line; and   the second table is generated based on the master data.   
     
     
         25 . A computer readable storage medium comprising program instructions which, when executed by a processor, perform the steps of:
 receiving a first table including quantities of intermediate products at one or more points along a production line for producing products;   generating a second table including value increments of the intermediate products at the one or more points; and   calculating a total value of the intermediate products in progress of production based on the first table and the second table.   
     
     
         26 . The medium of  claim 25 , wherein the first table is generated based on reports including the quantities of the intermediate products at the one or more points. 
     
     
         27 . The medium of  claim 25 , further comprising instructions for receiving master data including information on the production line, wherein the second table is generated based on the master data.