This nonprovisional application is based on Japanese Patent Application No.
2022-083558 filed on May 23, 2022, with the Japan Patent Office, the entire contents of which are hereby incorporated by reference.
The present disclosure relates to an information management system and an information management method.
Conventionally, a bill of material (BOM), a bill of process (BOP), and the like are used for product production management. For example, Japanese Patent Laying-Open No. 2018-36899 discloses a system that supports editing of the BOM.
In general, data regarding quality of an individual is accumulated for each individual of a product or an intermediate product. The data regarding the quality is accumulated in a database different from the BOM and the BOP. For example, the BOM, the BOP, and the data regarding the quality may be utilized for investigation of a defect cause of the product. However, the BOM, the BOP, and the data regarding the quality are distributed but not cooperated. Therefore, there is a problem that it is difficult to investigate the defect cause of the product.
The present disclosure has been made in view of the above problems, and an object of the present disclosure is to provide an information management system and an information management method capable of easily investigating the defect cause of the product.
According to an example of the present disclosure, an information management system includes a BOM database, a BOP database, a quality database, an acquisition section, and a registration section. The BOM database indicates a hierarchical structure of at least one component constituting a product. The BOP database indicates a hierarchical structure of at least one process producing the product. The quality database associates first identification information identifying an individual of an intermediate product or the product manufactured by the process with a quality data set regarding quality of the individual for each of the at least one process. The acquisition section acquires second identification information identifying an individual of a target component used in the process in the at least one component, and the first identification information corresponding to the intermediate product or the product manufactured in the process according to work order of the process from each of the at least one process. The registration section registers the second identification information in a hierarchy of the target component of the BOM database in the order acquired by the acquisition section in response to the acquisition of the second identification information from each of the at least one process. The registration section registers the first identification information in a hierarchy of the process of the BOP database in the order acquired by the acquisition section in response to the acquisition of the first identification information from each of the at least one process.
According to this disclosure, the first identification information and the second identification information are acquired according to the work order of the process. Then, the first identification information and the second identification information are registered in the BOP database and the BOM database in the acquired order. Consequently, the user checks the registration order of the first identification information and the second identification information in the BOP database and the BOM database, thereby easily specifying the intermediate product and the component constituting the target individual of the product. Furthermore, the user can specify a quality data set regarding the quality of each individual of the product or the intermediate product based on the quality database. Consequently, the user can use the first identification information of a defective individual as a key to specify the quality of the individual, the quality of the intermediate product constituting the individual, an individual of the component constituting the individual, and the like. Thus, the user can easily investigate the defect cause of the product.
In the above disclosure, the information management system further includes a search section configured to search the second identification information of each individual of the at least one component constituting a target individual of the product using the BOM database and the BOP database.
According to this disclosure, the user can easily specify the individual of the component constituting the defective individual by checking a search result by the search section.
In the above disclosure, the BOM database includes supply source data that associates the second identification information of the individual with third identification information identifying a supply source of the individual for each individual of at least one component. The information management system further includes an inquiry section configured to specify third identification information corresponding to the second identification information searched by the search section based on the BOM database, and transmit inquiry about quality of the individual indicated by the second identification information searched by the search section to a supply source indicated by the specified third identification information.
According to this disclosure, the user can easily check the quality of the individual of the component constituting a defective product.
In the above disclosure, the quality data set includes item data indicating each of a plurality of items. The information management system further includes: a provision permission database configured to indicate provision permission of each of the plurality of items to a supply destination of the product; and an answer section configured to generate answer information in response to receiving an inquiry about the quality of the target individual of the product from the supply destination, and transmit the generated answer information to the supply destination. The answer section reads the quality data set of the target individual from the quality database, and specifies at least one item permitted to be provided, based on the provision permission database. The answer section extracts item data corresponding to each of the at least one specified item from the read quality data set, and includes the extracted item data in the answer information.
According to this disclosure, the answer information including the item data corresponding to the item permitted to be provided can be immediately answered.
According to another example of the present disclosure, an information management method uses a BOM database, a BOP database, and a quality database. The BOM database indicates a hierarchical structure of at least one component constituting a product. The BOP database indicates a hierarchical structure of at least one process producing the product. The quality database associates first identification information identifying an individual of an intermediate product or the product manufactured by the process with a quality data set regarding quality of the individual for each of the at least one process. The information management method includes first to third steps. In the first step, second identification information identifying an individual of a target component used in the process in at least one component and first identification information corresponding to an intermediate product or a product manufactured in the process are acquired according to work order of the process from each of at least one process. In the second step, the second identification information is registered in a hierarchy of the target component of the BOM database in the acquired order in response to the acquisition of the second identification information from each of the at least one process. In the third step, the first identification information is registered in the hierarchy of the process of the BOP database in the acquired order in response to the acquisition of the first identification information from each of at least one process. This disclosure also allows the user to easily investigate the defect cause of the product.
The foregoing and other objects, features, aspects and advantages of the present invention will become more apparent from the following detailed description of the present invention when taken in conjunction with the accompanying drawings.
With reference to the drawings, an embodiment of the present invention will be described in detail. The same or equivalent portion in the drawings is denoted by the same reference numeral, and the description will not be repeated. The following modifications described below may selectively be combined as appropriate.
BOM database 51 indicates a hierarchical structure (tree structure) of at least one component constituting a product produced in company 2. BOP database 52 indicates a hierarchical structure of at least one process producing the product.
Quality database 60 associates first identification information identifying an individual of the product or an intermediate product produced in company 2 with a quality data set regarding quality of the individual. The intermediate product includes a unit constituting the product. Hereinafter, it is assumed that a “unit serial number” is used as the first identification information identifying the individual of the intermediate product, and a “product serial number” is used as the first identification information identifying the individual of the product.
The quality data set indicates information about the quality of the individual of the product or the intermediate product, and includes data indicating directly the quality, and data indicating information indirectly regarding the quality of the product or the intermediate product. For example, the data directly indicating the quality of the product or the intermediate product includes inspection data indicating the quality of processing and data indicating a characteristic (a dimension, an electrical property, and the like) of the product or the intermediate product. For example, the data indicating the information indirectly regarding the quality of the product or the intermediate product includes facility data in a factory, history data of processing and assembling work, worker data indicating a worker name, a time stamp (a work start time stamp, a work end time stamp, and the like), processing method data, data indicating a material, and processing condition data.
The information management method includes following steps (1) to (3) in order to cooperate BOM database 51, BOP database 52, and quality database 60.
Step (1): From each of at least one process of company 2, second identification information identifying the individual of a target component used in the process and the unit serial number (or the product serial number) identifying the individual of the intermediate product (or the product) manufactured in the process are acquired according to work order of the process. Hereinafter, it is assumed that a “component serial number” is used as the second identification information.
Step (2): In response to acquisition of the component serial number from each of at least one process of company 2, the component serial number is registered in the hierarchy of target components in the order of acquisition in BOM database 51.
Step (3): In response to acquisition of the unit serial number (or the product serial number) from each of at least one process of company 2, the unit serial number (or the product serial number) is registered in the hierarchy of the process in the order of acquisition in BOP database 52.
In the example of
Furthermore, in the example of
In step (1), the unit serial number (or the product serial number) and the component serial number are acquired according to the work order of the process. Furthermore, in steps (2), (3), the unit serial number (or the product serial number) and the component serial number are registered in BOP database 52 and the BOM database 51, in the acquired order. Consequently, when the registration order of the unit serial number, the product serial number, and the component serial number is checked in BOP database 52 and BOM database 51, the intermediate product and the component constituting the target individual of the product can be easily specified.
For example, the user can easily specify that the product with the product serial number “MA00003” registered third in BOP database 52 is manufactured from the intermediate product having the unit serial number “000003” registered third in BOP database 52. Similarly, the user can easily specify that the intermediate product having the unit serial number “000003” includes the component having the component serial number “HA4354” registered third in BOM database 51.
Furthermore, the user can specify a quality data set regarding the quality of each individual of the product or the intermediate product based on quality database 60.
Accordingly, the user can use the product serial number of a defective individual as a key to specify the quality of the individual, the quality of the intermediate product constituting the individual, the individual of the component constituting the individual, and the like. Thus, the user can easily investigate the defect cause of the product.
<Conventional Traceability System>
ERP system 3 monitors a production plan of management and component procurement along the production plan. The component is specified from the BOM database. ERP system 3 designates a component number, a delivery date, and a quantity to a supplier of the component, and orders the component.
MES 4 manages information required for a production operation of a factory such as a production schedule, a preparation, quality, a component stock, a product stock, maintenance, and a facility according to the production plan managed by ERP system 3, and generates a production instruction based on these pieces of information. IVIES 4 manages these pieces of information using the BOP database and the BOE database.
Manufacturing management system 5 controls a processing assembly line, a process, and a facility using a programmable logic controller (PLC), a sensor device, and the like in accordance with the production instruction from IVIES 4. In addition, a work instruction document required for manufacturing the product is produced using the BOM database and the BOP database and distributed to the worker.
Quality database 960 indicates facility data in the factory, a history of processing and assembling work, a time stamp, processing data, inspection data such as the quality of the product, the serial number, a lot number, and the like. These pieces of information are acquired from the facility, the worker, the PLC constituting manufacturing management system 5, and the sensor device.
As illustrated in
<Overall Configuration of Information Management System>
Information management system 1A is disposed in a manufacturer that manufactures a product 6A. Information management system 1B is disposed in a component supplier that manufactures a product 6B. Product 6B is used as a component of product 6A, and is delivered to the manufacturer in which information management system 1A is disposed. Information providing system 8 can further include, in addition to information management systems 1A, 1B, information management system 1 disposed in another component supplier that supplies a component of product 6A.
Information management system 1 of each company includes a server that manages information regarding a product produced by the company, and a manufacturing controller that controls production of the manufacturing. That is, information management system 1A includes a server 100A that manages the information regarding product 6A and a manufacturing controller 200A that controls the production of product 6A. Information management system 1B includes a server 100B that manages the information about product 6B and a manufacturing controller 200B that controls the production of product 6B. Hereinafter, in a case where servers 100A, 100B, . . . are not particularly distinguished, each of servers 100A, 100B, . . . is referred to as a “server 100”. When manufacturing controllers 200A, 200B, . . . are not particularly distinguished, each of manufacturing controllers 200A, 200B, . . . is referred to as a “manufacturing controller 200”. For example, servers 100A, 100B, . . . can communicate with each other through the Internet. For example, manufacturing controller 200 is implemented by the PLC.
<Hardware Configuration of Server>
Processor 101 expands various programs stored in storage 103 on memory 102, and executes the programs, thereby implementing various pieces of processing of the embodiment.
Memory 102 is typically a volatile storage device such as a dynamic random access memory (DRAM), and stores the program and the like read from storage 103.
Storage 103 is typically a non-volatile magnetic storage device such as a hard disk drive. Storage 103 stores a management program 130 executed by processor 101. Management program 130 to be installed in storage 103 is distributed while stored in a memory card or the like.
Display controller 104 is connected to a display device 140, and outputs a signal displaying various pieces of information to display device 140 according to an internal command from processor 101.
Input interface 105 serves as an interface for data transmission between processor 101 and an input device 150 such as a keyboard, a mouse, a touch panel, or a dedicated console. That is, input interface 105 receives an operation instruction given by the user operating input device 150.
Communication interface 106 serves as an interface for data transmission between processor 101 and an external device (for example, manufacturing controller 200 and another server 100). Management program 130 to be stored in storage 103 may be downloaded from a distribution server or the like through communication interface 106.
When the computer having the structure following the general-purpose computer architecture is used, an operating system (OS) providing a basic function of the computer may be installed in addition to the application providing the function of the embodiment. In this case, the program of the embodiment may call a required module in a predetermined order and timing in program modules provided as a part of the OS to execute processing. That is, the program itself of the embodiment does not include the module as described above, and sometimes the processing is executed in cooperation with the OS.
Alternatively, some or all of the functions provided by the execution of management program 130 may be implemented as a dedicated hardware circuit.
<Hardware Configuration of Manufacturing Controller>
Processor 201 reads various programs stored in storage 204, expands the various programs in main memory 203, and executes the various programs, thereby implementing a control arithmetic operation controlling a control target. Chip set 202 controls the data transmission and the like between processor 201 and each component.
Storage 204 stores a system program 210 that implements basic processing and a user program 211 that implements the control arithmetic operation.
Control system network controller 205 controls data exchange with the control target through a control system network.
Information system network controller 206 controls the data exchange with external devices (including server 100) through an information system network.
Memory card interface 208 is configured such that a memory card 220 is detachable, and can write data to memory card 220 and read various data (such as a user program) from memory card 220.
Although the configuration example in which the required function is provided by processor 201 executing the program has been illustrated in
<Functional Configuration of Information Management System>
The control target of manufacturing controller 200A in
A code reader 401 and a laser marker 411 are provided in housing unit assembling process 301. A code reader 402 and a laser marker 412 are provided in end cap unit assembling process 302. A code reader 403 and a laser marker 413 are provided in rotor unit assembling process 303. A code reader 404 and a laser marker 414 are provided in motor assembling process 304. A code reader 405 is provided in motor inspection process 305.
Each of code readers 401 to 405 reads a QR code (registered trademark) of a component, an intermediate product, or a product that has been conveyed to a corresponding process. The QR code indicates a serial number that identifies the component, the intermediate product, or the product. For example, code reader 401 reads the QR code marked on the housing conveyed to housing unit assembling process 301, and outputs the component serial number indicated by the read QR code. Code reader 405 reads the QR code marked on the motor conveyed to motor inspection process 305, and outputs the product serial number indicated by the read QR code.
Laser markers 411 to 414 mark the intermediate product or the product to be output from the corresponding process with the QR code (registered trademark). The QR code indicates a serial number identifying the intermediate product or the product. The QR codes marked by laser marker 411 to 414 are uniquely designated by manufacturing controller 200A or the facility installed in the corresponding process. For example, laser marker 414 marks the product serial number on the motor manufactured by motor assembling process 304.
Manufacturing controller 200A includes an IO processing section 21A that performs data input and output processing with the facility installed in the process. Processor 201 (see
For example, IO processing section 21A outputs data indicating an operation instruction, data indicating the QR code to be marked on the intermediate product or the product, and the like to the facility installed in each process.
IO processing section 21A acquires at least one item data regarding the quality of the intermediate product or the product manufactured by each process from each process. The item data indicates a value, a content, and the like of the item regarding the quality. The serial number (the unit serial number or the product serial number) of the corresponding individual is added to the at least one item data. For example, IO processing section 21A receives data (time stamp) indicating the time when code reader 401 to 405 read the QR code, data indicating a processing condition, data indicating a processing method, and data indicating the quality as item data.
Furthermore, IO processing section 21A operates as an acquisition section that acquires the component serial number identifying the individual of the component used in the process and the unit serial number (or the product serial number) identifying the individual of the intermediate product or the product manufactured in the process according to the work order of the process from each process. Specifically, every time the code reader installed in each process reads the QR code of the component, IO processing section 21A acquires the component serial number indicated by the QR code. Each time the laser marker installed in each process marks the QR code on the intermediate product or the product, IO processing section 21A acquires the unit serial number or the product serial number indicated by the QR code.
For example, every time the individual of the housing unit is manufactured by housing unit assembling process 301, IO processing section 21A acquires the component serial number identifying the individual of the component used for the individual of the housing unit and the unit serial number identifying the individual of the housing unit from housing unit assembling process 301. In addition, IO processing section 21A acquires the product serial number marked on the individual of the motor from motor assembling process 304 each time the individual of the motor is manufactured.
The control target of manufacturing controller 200B in
A code reader 406 and a laser marker 416 are provided in sheet metal press punching process 306. A code reader 407 and a laser marker 417 are provided in housing molding process 307. A code reader 408 is provided in housing inspection process 308.
Each of code readers 406 to 408 reads the QR code of the component, the intermediate product, or the product that has been conveyed to the corresponding process. The QR code indicates a serial number that identifies the component, the intermediate product, or the product. For example, code reader 406 reads the QR code marked on a metal plate conveyed to sheet metal press punching process 306, and outputs the component serial number indicated by the read QR code. Code reader 408 reads the QR code marked on the manufactured housing, and outputs the product serial number indicated by the read QR code.
Laser marker 416, 417 marks the QR code on the intermediate product or the product to be output from the corresponding process. The QR code indicates a serial number identifying the intermediate product or the product. The QR code marked by laser marker 416, 417 is uniquely specified by manufacturing controller 200B or the facility installed in the corresponding process.
Manufacturing controller 200B includes an IO processing section 21B that performs the data input and output processing with the facility installed in each process. Processor 201 (see
For example, IO processing section 21B outputs the data indicating the operation command, the data indicating the QR code to be marked on the intermediate product or the product, and the like to the facility installed in the process.
IO processing section 21B acquires at least one item data regarding the quality of each individual of the intermediate product or the product manufactured by the process from each process. The item data indicates a value, a content, and the like of the item regarding the quality. The serial number (the unit serial number or the product serial number) of the corresponding individual is added to the at least one item data. For example, IO processing section 21B receives the data (work start time stamp) indicating the time when code reader 406 to 408 reads the QR code, the data indicating the processing condition, the data indicating the processing method, the data indicating the value of the parameter (dimension or the like) representing the quality, and the like as the item data.
Furthermore, IO processing section 21B operates as an acquisition section that acquires the component serial number identifying the individual of the component used in the process in at least one component from each process, and the unit serial number (or the product serial number) identifying the individual of the intermediate product or the product manufactured in the process according to the work order of the process. Specifically, IO processing section 21B acquires the component serial number indicated by the QR code every time the code reader installed in each process reads the QR code of the component. Each time the laser marker installed in each process marks the QR code on the intermediate product or the product, IO processing section 21B acquires the unit serial number or the product serial number indicated by the QR code.
For example, IO processing section 21B acquires the component serial number identifying the individual of the metal plate and the unit serial number identifying the individual of the metal piece from sheet metal press punching process 306 each time the metal piece is punched out from the metal plate. In addition, IO processing section 21B acquires the product serial number marked on the individual of the housing from housing molding process 307 every time the individual of the housing is manufactured.
As illustrated in
Registration section 10A, data analysis section 11A, and inquiry and answer section 12A are implemented by processor 101 (see
BOM database 51 indicates the hierarchical structure of at least one component constituting the product. For example, BOM database 51 of server 100A indicates the hierarchical structure of at least one component constituting the motor. On the other hand, BOM database 51 of server 100B indicates the hierarchical structure of at least one component constituting the housing.
BOP database 52 indicates the hierarchical structure of at least one process producing the product. BOE database 53 indicates a hierarchical structure of at least one facility producing the product.
First association database 54 indicates a correspondence relationship between each of at least one process producing the product and the component used in the process. Second association database 55 indicates a correspondence relationship between each of at least one process and the facility used in the process.
A first association database 54A associates the component indicated by BOM database 51A with the process indicated by BOP database 52A. For example, first association database 54A associates the component “housing” with the process “fix housing” using the component “housing”. In this manner, BOM database 51A and BOP database 52A are correlated with each other by first association database 54A.
A second association database 55A associates the process indicated by BOP database 52A with the facility indicated by BOE database 53A. For example, second association database 55A associates the process “fix housing” with the facilities “fixing jig 1” and “workbench 1” used in the process. In this manner, BOP database 52A and BOE database 53A are correlated with each other by second association database 55A.
BOM database 51 includes, for each individual of each component, supply source data that associates the component serial number of the individual with third identification information identifying a supply source of the individual. Hereinafter, it is assumed that a “supplier number” is used as the third identification information.
Quality database 60A in
Quality database 60B in
Provision permission database 70A in
Registration section 10A in
When manufacturing controller 200A acquires at least one item data from each process, registration section 10A registers the at least one item data in quality database 60A corresponding to the process.
In addition, when manufacturing controller 200A acquires the component serial number of the target component from each process, registration section 10A registers the component serial number in the hierarchy of the target component in BOM database 51A. Specifically, when manufacturing controller 200A acquires the component serial number from each process, registration section 10A specifies the target component to be used in the process using first association database 54A. Then, registration section 10A registers the component serial numbers in the hierarchy of the target components in the order acquired by manufacturing controller 200A in BOM database 51A.
Furthermore, when manufacturing controller 200A acquires the serial number of the intermediate product or the product manufactured by the process from each process, registration section 10A registers the serial number in the hierarchy of the process in the order acquired in BOP database 52A.
Data analysis section 11A illustrated in
For example, data analysis section 11A operates as a search section that searches the component serial number of each individual of at least one component constituting the target individual of the product using BOM database 51A, BOP database 52A, and first association database 54A. In addition, data analysis section 11A searches the facility used to manufacture the target individual using BOE database 53A and second association database 55A. Data analysis section 11B also executes the similar search processing.
Inquiry and answer section 12A in
For example, inquiry and answer section 12A specifies the supplier number corresponding to the component serial number searched by data analysis section 11A based on BOM database 51A. Then, inquiry and answer section 12A transmits the inquiry about the quality of the individual indicated by the component serial number searched by data analysis section 11A to server 100 (for example, server 100B) of the component supplier indicated by the specified supplier number.
For example, inquiry and answer section 12B generates the answer information in response to receiving the inquiry about the quality of the target individual from the supply destination of the housing that is the product, and transmits the generated answer information to the supply destination. Specifically, inquiry and answer section 12B reads the quality data set of the target individual from quality database 60B. Inquiry and answer section 12B specifies at least one item permitted to be provided to the supply destination based on provision permission database 70B. Inquiry and answer section 12B extracts the item data corresponding to each of the specified at least one item from the read quality data set, and includes the extracted item data in the answer information.
<Flow of Pre-Processing>
First, a designer of the product produces a drawing of the product, and produces BOM database 51 based on the component number identifying each of at least one component constituting the product and a structure of the product (step S1).
Subsequently, the designer of the process produces BOP database 52 based on the design content (step S2), and produces BOE database 53 (step S3).
Furthermore, the designer of the process produces first association database 54 based on the design content (step S4) and produces second association database 55 (step S5).
The person in charge of product delivery produces provision permission database 70 indicating the provision permission of each of the plurality of items regarding the quality of the product to the supply destination based on the contract content with the supply destination of the product (step S6). Thus, the pre-processing ends.
<Flow of Information Management Processing after Production Start>
As illustrated in
Subsequently, processor 201 of manufacturing controller 200 controls the operation of the facility installed in each process to start the production of the target lot (step S12).
Subsequently, processor 201 acquires the component serial number identifying the individual of the component used in the process from each process (step S13).
Subsequently, in step S14, in response to the acquisition of the component serial number from each process, processor 101 of server 100 specifies the target component used in the process using first association database 54. Then, processor 101 registers the component serial numbers in the order acquired by manufacturing controller 200 in the hierarchy of the target components in BOM database 51.
Each time the intermediate product or the product is manufactured in each process, processor 201 of manufacturing controller 200 acquires the serial number (the unit serial number or the product serial number) identifying the individual of the intermediate product or the product (step S15). Processor 201 outputs the serial number acquired from each process to server 100.
In response to the acquisition of the serial number identifying the individual of the intermediate product or the product from each process, processor 101 of server 100 registers the serial number in the hierarchy of the process of BOP database 52 in the acquired order (step S16).
Processor 201 of manufacturing controller 200 acquires at least one item data regarding the quality of the intermediate product or the product manufactured by each process (step S17). Processor 201 outputs the item data acquired from each process to server 100.
In response to the acquisition of at least one item data corresponding to each individual of the intermediate product or the product from each process, processor 101 of server 100 registers the at least one item data in quality database 60 corresponding to the process (step S18).
Processor 101 determines whether the production of the target lot is completed (step S19). For example, processor 101 may determine whether the production of the target lot is completed based on the production plan from the MES.
When the production of the target lot is not completed (NO in step S19), the information management processing returns to step S13.
When the production of the target lot is completed (YES in step S19), processor 101 determines whether a defective product exists based on quality database 60 (step S20). For example, based on quality database 60 A_2 in
When the defective product exists (YES in step S20), processor 101 executes data analysis (step S21). After step S21, the information management processing ends.
<Subroutine in Step S21>
First, processor 101 of server 100 extracts the data regarding the defective product from various databases using the serial number of the defective product as a key (step S31). Specifically, processor 101 extracts the unit serial number of the intermediate product constituting the defective product, the quality data set corresponding to the defective product or the intermediate product constituting the defective product, the component serial number of the component constituting the defective product, the supplier number identifying the supply source of the component constituting the defective product, the process number identifying the process used for manufacturing the defective product, a facility number identifying the facility used for manufacturing the defective product, and the like.
For example, in the case of the example in
Furthermore, processor 101 specifies the quality data set corresponding to the unit serial number “000002” of quality database 60A_1 in
Furthermore, processor 101 specifies the quality data set corresponding to the product serial number “MA00002” of quality database 60A_2 in
Furthermore, processor 101 specifies “D0023B” corresponding to the component serial number “HB5018” in supply source data 56A included in BOM database 51A in
Subsequently, processor 101 provides the information extracted in step S31 (step S32). Specifically, processor 101 generates a screen indicating the specified information, and causes display device 140 (see
The production manager investigates the defect cause based on the provided information. As described above, the provided information includes information regarding the defective product, and the intermediate product and the component constituting the defective product. Accordingly, the production manager can easily investigate the defect cause.
As illustrated in
The production manager may investigate the cause candidates located at the end of the tree structure in
The production manager checks whether the cause candidates “mistake in assembling work of rotor unit” and “mistake in work in inspection process” among the cause candidates located at the end are the defect cause using the quality data set corresponding to each of the “rotor unit assembling process” and the “inspection process”. Specifically, the production manager can check whether the cause candidates “mistake in assembling work of rotor unit” and “mistake in work in inspection process” are the defect causes by inquiring the worker indicated by the quality data set.
The production manager cannot immediately check whether the cause candidate “mistake in processing operation of housing” among the cause candidates located at the end is the defect cause. Accordingly, the production manager inputs an inquiry instruction to the component supplier to server 100.
Subsequently, processor 101 determines whether the inquiry instruction to the component supplier is input to input device 150 (step S33). When the inquiry instruction to the component supplier is not input (NO in step S33), step S21 ends.
When the inquiry instruction to the component supplier is input (YES in step S33), processor 101 receives the input of the component of an inquiry target (step S34). For example, when there is a possibility that the cause candidate “error in processing operation of housing component” is the defect cause, the production manager inputs “housing” as the component of the inquiry target.
In response to the input, processor 101 specifies the component supplier of an inquiry destination (step S35). Specifically, processor 101 specifies the component serial number of the component of the inquiry target constituting the defective product.
For example, when the component of the inquiry target is “housing” and when the serial number of the defective product is “MA00002”, processor 101 specifies the component serial number “HB5018” based on BOM database 51 and BOP database 52 in
Subsequently, processor 101 generates an inquiry sentence and transmits the generated inquiry sentence to the inquiry destination (step S36). Processor 101 may generate the inquiry sentence in response to the input to input device 150, or may generate the inquiry sentence by incorporating the component serial number of the inquiry target in a previously-produced fixed phrase.
Thereafter, processor 101 receives answer information from the inquiry destination (step S37). The received answer information is displayed on display device 140. After step S37, step S21 ends.
<Flow of Answer Processing>
When the inquiry is received (YES in step S41), processor 101 reads the quality data set corresponding to the individual having the serial number designated in the inquiry from quality database 60 (step S42). In step S42, processor 101 reads not only the quality data set corresponding to the same product serial number as the designated serial number but also the quality data set corresponding to the intermediate product constituting the product with the product serial number. The method for searching the unit serial number of the intermediate product constituting the product with the product serial number is as described above.
Subsequently, processor 101 specifies the item permitted to be provided to the supply destination based on the provision permission database 70 (step S43).
Processor 101 extracts, from the quality data set read in step S42, only item data permitted to be provided (step S44).
Processor 101 produces the answer information including the information indicated by the extracted item data, and transmits the answer information to the inquiry source (step S45). After step S45, the answer processing ends.
<Modification>
In the above description, server 100 includes BOM database 51, BOP database 52, BOE database 53, quality database 60, and provision permission database 70. However, these databases may be distributed and located on different devices.
In the above description, as illustrated in
When registering the component serial number of the used component in BOM database 51A, processor 101 of server 100 also registers the supplier number identifying the component supplier of the supply source of the component in BOM database 51A. Processor 101 may specify the supplier number corresponding to the used component by accessing the database in which a list of component serial numbers of components delivered from the component supplier is associated with the supplier number identifying the component supplier.
In the above description, it is assumed that BOP database 52 and quality database 60 are associated with each other on a one-to-one basis. However, in the company, a plurality of lines may be installed for one product. In this case, a plurality of quality databases 60 can be provided for each line. On the other hand, one BOP database 52 is provided in the company or the factory. In such a case, BOP database 52 is produced so as to indicate the hierarchical structure of processes for each line. That is, in BOP database 52, the process number identifying each process identifies the line in which the process is installed and the process. Then, when the unit serial number (or product serial number) is acquired from a certain process of a certain line, the unit serial number (or product serial number) is registered in the hierarchy corresponding to the process of the line in BOP database 52.
In addition, BOM database 51 is also produced so as to indicate the hierarchical structure of components for each line. That is, in BOM database 51, the component number identifying each component identifies the line in which the component is used and the component. Then, when the component serial number is acquired from a certain process of a certain line, the component serial number is registered in the hierarchy corresponding to the component of the line in BOM database 51.
Thus, the component constituting the target individual of the product manufactured in each line can be specified even when BOM database 51 and BOP database 52 are associated with quality database 60 on a one-to-many basis.
As described above, the embodiment includes the following disclosure.
(Configuration 1)
An information management system (1, 1A, 1B) including:
(Configuration 2)
The information management system (1, 1A, 1B) described in configuration 1, further including a search section (11A, 11B, 101) configured to search the second identification information of each individual of the at least one component constituting a target individual of the product using the BOM database (51, 51A) and the BOP database (52, 52A).
(Configuration 3)
The information management system (1, 1A, 1B) described in configuration 2, further including an inquiry section (12A, 12B, 101) configured to specify third identification information corresponding to the second identification information searched by the search section (11A, 11B, 101) based on the BOM database (51, 51A), and transmit inquiry about quality of the individual indicated by the second identification information searched by the search section to a supply source indicated by the specified third identification information,
(Configuration 4)
The information management system (1, 1A, 1B) described in any one of configurations 1 to 3, further including:
(Configuration 5)
An information management method in which a BOM database (51, 51A) indicating a hierarchical structure of at least one component constituting a product, a BOP database (52, 52A) indicating a hierarchical structure of at least one process producing the product, and a quality database (60, 60A, 60B) associating first identification information identifying an individual of an intermediate product or the product manufactured by the process with a quality data set regarding quality of the individual for each of the at least one process are used,
Although the embodiment of the present invention has been described, it should be considered that the disclosed embodiment is an example in all respects and not restrictive. The scope of the present invention is indicated by the claims, and it is intended that all modifications within the meaning and scope of the claims are included in the present invention.
Number | Date | Country | Kind |
---|---|---|---|
2022-083558 | May 2022 | JP | national |