MBOM data integrity control method and device, equipment and storage medium

Abstract

The invention discloses an MBOM data integrity control method, device and equipment and a storage medium. The method comprises the following steps: acquiring an instantiated vehicle type list corresponding to a to-be-checked vehicle type series; mBOM integrity check is started according to the instantiated vehicle model list, and a check result is obtained; and determining a problem list from the checking result, and feeding back the problem list to the terminal, so that automatic processing of MBOM data integrity checking at multiple vehicle type series and multiple time points can be realized, an instantiated vehicle type list can be automatically identified and submitted for checking, the problem of error risk caused by manual processing is avoided, the accuracy of BOM data checking is improved, and the efficiency of checking the BOM data is improved. The MBOM management cost is reduced, and the speed and efficiency of MBOM data integrity control are improved.

Description

Technical Field

[0001] The present invention relates to the technical field of vehicle manufacturing, and in particular to a MBOM data integrity control method, device, equipment and storage medium. Background Art

[0002] Amid severe internal competition in the automotive industry, automakers frequently update and iterate their models, and new models are launched continuously. The evolution of model definitions and the surge in the number of model series and instantiated models have brought great risks and challenges to the management of the Manufacturing Bill of Materials (MBOM). As the source of vehicle production organization, the basic data of multiple systems such as downstream vehicle scheduling, parts ordering, process cards, and cost calculation all come from MBOM, and its importance is self-evident. To ensure the integrity of MBOM, engineers need to conduct various checks on the data regularly or irregularly.

[0003] The general approach to MBOM integrity check is: Bill of Materials (BOM) engineers first organize the instantiated vehicle list according to the vehicle series they are responsible for, determine the time point for checking the selected data, and then input the differences between the instantiated vehicle BOM and the vehicle function configuration table into the system one by one, and then verify and confirm the differences one by one. The above operations need to be repeated at each required time point. This method faces the following problems:

[0004] 1. The number of instantiated models in each vehicle series is huge, most of which are in the hundreds or thousands. Various configuration combinations plus some special restrictions make it difficult to manually and accurately compile a list of instantiated models. It is easy to have multiple models or missing models, and the work efficiency is low.

[0005] 2. In actual work, some MBOM data verification is a periodic task. For example, before the monthly order is made, MBOM integrity verification is required for multiple time points such as the established month, forecast January, and forecast February of the KD order. Multiple time points are intersected with multiple instantiation models to form the models to be verified. Manually inputting these verification models is a heavy workload and is repeated over and over again, wasting a lot of human resources.

[0006] Existing solutions mainly use systematic means to reduce manual proofreading of BOM integrity. However, they only conduct an overall check on the BOM of a certain vehicle series and cannot intuitively identify BOM integrity issues of specific instantiated vehicle models. Nor does it provide a solution for simultaneously checking BOM data of multiple vehicle series and multiple time points.

[0007] Another solution is to identify the BOM differences between two vehicle models. For instantiated vehicle model data of multiple vehicle series, no solution is provided for simultaneous checking. Similarly, this solution does not provide a solution for simultaneous checking of BOM data at multiple time points. Summary of the invention

[0008] The main purpose of the present invention is to provide an MBOM data integrity control method, device, equipment and storage medium, aiming to solve the technical problems in the prior art that the vehicle model BOM data verification cannot simultaneously check the instantiated vehicle model data of multiple vehicle series, cannot simultaneously check the BOM data of multiple time points, the data integrity verification efficiency is low, the accuracy of the verification results cannot be guaranteed, and the verification cost is high.

[0009] In a first aspect, the present invention provides a method for controlling MBOM data integrity, the method comprising the following steps:

[0010] Get the list of instantiated models corresponding to the model series to be checked;

[0011] Initiate MBOM integrity check according to the instantiated vehicle model list and obtain a check result;

[0012] A problem list is determined from the inspection results, and the problem list is fed back to the terminal.

[0013] Optionally, obtaining a list of instantiated vehicle models corresponding to the vehicle model series to be checked includes:

[0014] When the current time reaches the preset time point, the task will be automatically started;

[0015] According to the preset identification time point, a list of instantiated models corresponding to the model series to be checked is identified from the preset model library.

[0016] Optionally, the step of identifying, from a preset vehicle model library, a list of instantiated vehicle models corresponding to a vehicle model series to be checked according to a preset identification time point includes:

[0017] Obtain all instantiated models in the model library, compare the preset identification time point with the validity period of all instantiated models, and take the model within the validity period at the preset identification time point as the model to be verified;

[0018] The vehicle model library is traversed, a vehicle model series to be checked is generated according to all vehicle models to be verified, and an instantiated vehicle model list of the vehicle model series to be checked is generated.

[0019] Optionally, starting the MBOM integrity check according to the instantiated vehicle model list to obtain the check result includes:

[0020] Obtaining basic data from the MBOM according to the instantiated vehicle model list;

[0021] The MBOM integrity check function is started, and the basic data is checked one by one according to different function codes within a specified date to obtain the check result.

[0022] Optionally, acquiring basic data from the MBOM according to the instantiated vehicle model list includes:

[0023] Obtaining a vehicle model logo list, function code configuration table data and a parts configuration expression table from the MBOM according to the instantiated vehicle model list;

[0024] Obtaining vehicle model mark data of vehicle models, optional marks and management marks developed according to a specified date from the vehicle model mark list;

[0025] Obtaining the assembly center, vehicle model series, function code, workshop, coefficient, unit, configuration expression, start date and end date from the function code configuration table data;

[0026] Obtaining part information, the function code, the use workshop, the coefficient, the unit, the configuration expression, the start date and the end date from the part configuration expression table;

[0027] The vehicle type identification data, the parts information, the assembly center, the vehicle type series, the function code, the use workshop, the coefficient, the unit, the configuration expression, the start date and the end date are used as basic data.

[0028] Optionally, the MBOM integrity check function is started to check the basic data one by one according to different function codes within a specified date to obtain the check result, including:

[0029] Start the MBOM integrity check function, expand the instantiated vehicle models in the instantiated vehicle model list on a specified date, and obtain the corresponding target function code, target workshop, and target parts list;

[0030] Summarizing the target function code, the target use workshop and the target parts list to obtain a first master list corresponding to each vehicle model, each function code, each use workshop and each coefficient;

[0031] According to the function code configuration table data combined with the time point information and the vehicle type mark definition information, a second master list corresponding to each vehicle type, each function code, each workshop and each coefficient is obtained;

[0032] The first master list and the second master list are compared to identify differences and matching data, all instantiated vehicle models are traversed, and inspection results are generated according to the differences and the matching data.

[0033] Optionally, determining a problem list from the inspection result and feeding back the problem list to the terminal includes:

[0034] Obtaining first error information from the inspection result that the current part has a coefficient, the current function code and the configuration table coefficient of the current workshop are empty;

[0035] Obtaining from the inspection result a second error message that the current function code and the configuration table of the currently used workshop have coefficients, and the current part coefficient is empty;

[0036] Obtaining third error information from the inspection result that the coefficient of the currently used workshop under the same current function code is inconsistent with the coefficient of the configuration table of the current function code and the currently used workshop;

[0037] A question list is generated according to the first error information, the second error information, and the third error information, and the question list is determined and fed back to the terminal.

[0038] In a second aspect, in order to achieve the above-mentioned object, the present invention further proposes an MBOM data integrity control device, the MBOM data integrity control device comprising:

[0039] A list acquisition module is used to acquire a list of instantiated models corresponding to the model series to be checked;

[0040] An integrity check module, used to start the MBOM integrity check according to the instantiated vehicle model list and obtain the check result;

[0041] The feedback module is used to determine a problem list from the inspection results and feed back the problem list to the terminal.

[0042] In a third aspect, to achieve the above-mentioned purpose, the present invention further proposes an MBOM data integrity control device, wherein the MBOM data integrity control device comprises: a memory, a processor, and an MBOM data integrity control program stored in the memory and executable on the processor, wherein the MBOM data integrity control program is configured to implement the steps of the MBOM data integrity control method described above.

[0043] In a fourth aspect, to achieve the above-mentioned purpose, the present invention further proposes a storage medium, on which an MBOM data integrity control program is stored, and when the MBOM data integrity control program is executed by a processor, the steps of the MBOM data integrity control method described above are implemented.

[0044] The MBOM data integrity control method proposed in the present invention obtains an instantiated vehicle model list corresponding to a vehicle model series to be checked; starts an MBOM integrity check according to the instantiated vehicle model list to obtain an inspection result; determines a problem list from the inspection result, and feeds the problem list back to a terminal, thereby realizing automatic processing of MBOM data integrity checks at multiple vehicle model series and multiple time points, automatically identifying an instantiated vehicle model list and submitting it for inspection, avoiding the risk of errors in manual processing, improving the accuracy of BOM data calculation, reducing MBOM management costs, and improving the speed and efficiency of MBOM data integrity control. BRIEF DESCRIPTION OF THE DRAWINGS

[0045] Figure 1 A schematic diagram of the device structure of the hardware operating environment involved in the embodiment of the present invention;

[0046] Figure 2 It is a flowchart of a first embodiment of the MBOM data integrity control method of the present invention;

[0047] Figure 3 It is a flow chart of the second embodiment of the MBOM data integrity control method of the present invention;

[0048] Figure 4 It is a flowchart of a third embodiment of the MBOM data integrity control method of the present invention;

[0049] Figure 5 It is a flowchart of a fourth embodiment of the MBOM data integrity control method of the present invention;

[0050] Figure 6 Schematic diagram of the integrity control system in the MBOM data integrity control method of the present invention;

[0051] Figure 7 It is a functional module diagram of the first embodiment of the MBOM data integrity control device of the present invention.

[0052] The realization of the purpose, functional features and advantages of the present invention will be further explained in conjunction with embodiments and with reference to the accompanying drawings. DETAILED DESCRIPTION

[0053] It should be understood that the specific embodiments described herein are only used to explain the present invention, and are not used to limit the present invention.

[0054] The solution of the embodiment of the present invention is mainly: by obtaining a list of instantiated models corresponding to the model series to be checked; starting the MBOM integrity check according to the list of instantiated models to obtain the inspection result; determining a list of problems from the inspection result, and feeding back the list of problems to the terminal, it is possible to realize the automatic processing of the MBOM data integrity check of multiple model series and multiple time points, and can automatically identify the list of instantiated models and submit it for inspection, thereby avoiding the risk of manual processing errors, improving the accuracy of BOM data calculation, reducing MBOM management costs, and improving the speed and efficiency of MBOM data integrity control, and solving the technical problems in the prior art that the vehicle model BOM data check cannot simultaneously check the instantiated model data of multiple vehicle series, cannot simultaneously check the BOM data of multiple time points, the data integrity check efficiency is low, the accuracy of the check result cannot be guaranteed, and the check cost is high.

[0055] Reference Figure 1 , Figure 1 The figure is a schematic diagram of the device structure of the hardware operating environment involved in the embodiment of the present invention.

[0056] like Figure 1 As shown, the device may include: a processor 1001, such as a CPU, a communication bus 1002, a user interface 1003, a network interface 1004, and a memory 1005. Among them, the communication bus 1002 is used to realize the connection and communication between these components. The user interface 1003 may include a display screen (Display), an input unit such as a keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface and a wireless interface. The network interface 1004 may optionally include a standard wired interface and a wireless interface (such as a Wi-Fi interface). The memory 1005 may be a high-speed RAM memory, or it may be a stable memory (Non-Volatile Memory), such as a disk memory. The memory 1005 may optionally be a storage device independent of the aforementioned processor 1001.

[0057] Those skilled in the art will understand that Figure 1 The device structure shown in the figure does not constitute a limitation of the device, and may include more or less components than shown in the figure, or combine certain components, or arrange the components differently.

[0058] like Figure 1 As shown, the memory 1005 as a storage medium may include an operating device, a network communication module, a user interface module, and an MBOM data integrity control program.

[0059] The device of the present invention calls the MBOM data integrity control program stored in the memory 1005 through the processor 1001, and performs the following operations:

[0060] Get the list of instantiated models corresponding to the model series to be checked;

[0061] Initiate MBOM integrity check according to the instantiated vehicle model list and obtain a check result;

[0062] A problem list is determined from the inspection results, and the problem list is fed back to the terminal.

[0063] The device of the present invention calls the MBOM data integrity control program stored in the memory 1005 through the processor 1001, and also performs the following operations:

[0064] When the current time reaches the preset time point, the task will be automatically started;

[0065] According to the preset identification time point, a list of instantiated models corresponding to the model series to be checked is identified from the preset model library.

[0066] The device of the present invention calls the MBOM data integrity control program stored in the memory 1005 through the processor 1001, and also performs the following operations:

[0067] Obtain all instantiated models in the model library, compare the preset identification time point with the validity period of all instantiated models, and take the model within the validity period at the preset identification time point as the model to be verified;

[0068] The vehicle model library is traversed, a vehicle model series to be checked is generated according to all vehicle models to be verified, and an instantiated vehicle model list of the vehicle model series to be checked is generated.

[0069] The device of the present invention calls the MBOM data integrity control program stored in the memory 1005 through the processor 1001, and also performs the following operations:

[0070] Obtaining basic data from the MBOM according to the instantiated vehicle model list;

[0071] The MBOM integrity check function is started, and the basic data is checked one by one according to different function codes within a specified date to obtain the check result.

[0072] The device of the present invention calls the MBOM data integrity control program stored in the memory 1005 through the processor 1001, and also performs the following operations:

[0073] Obtaining a vehicle model logo list, function code configuration table data and a parts configuration expression table from the MBOM according to the instantiated vehicle model list;

[0074] Obtaining vehicle model mark data of vehicle models, optional marks and management marks developed according to a specified date from the vehicle model mark list;

[0075] Obtaining the assembly center, vehicle model series, function code, workshop, coefficient, unit, configuration expression, start date and end date from the function code configuration table data;

[0076] Obtaining part information, the function code, the use workshop, the coefficient, the unit, the configuration expression, the start date and the end date from the part configuration expression table;

[0077] The vehicle type identification data, the parts information, the assembly center, the vehicle type series, the function code, the use workshop, the coefficient, the unit, the configuration expression, the start date and the end date are used as basic data.

[0078] The device of the present invention calls the MBOM data integrity control program stored in the memory 1005 through the processor 1001, and also performs the following operations:

[0079] Start the MBOM integrity check function, expand the instantiated vehicle models in the instantiated vehicle model list on a specified date, and obtain the corresponding target function code, target workshop, and target parts list;

[0080] Summarizing the target function code, the target use workshop and the target parts list to obtain a first master list corresponding to each vehicle model, each function code, each use workshop and each coefficient;

[0081] According to the function code configuration table data combined with the time point information and the vehicle type mark definition information, a second master list corresponding to each vehicle type, each function code, each workshop and each coefficient is obtained;

[0082] The first master list and the second master list are compared to identify differences and matching data, all instantiated vehicle models are traversed, and inspection results are generated according to the differences and the matching data.

[0083] The device of the present invention calls the MBOM data integrity control program stored in the memory 1005 through the processor 1001, and also performs the following operations:

[0084] Obtaining first error information from the inspection result that the current part has a coefficient, the current function code and the configuration table coefficient of the current workshop are empty;

[0085] Obtaining from the inspection result a second error message that the current function code and the configuration table of the currently used workshop have coefficients, and the current part coefficient is empty;

[0086] Obtaining third error information from the inspection result that the coefficient of the currently used workshop under the same current function code is inconsistent with the coefficient of the configuration table of the current function code and the currently used workshop;

[0087] A question list is generated according to the first error information, the second error information, and the third error information, and the question list is determined and fed back to the terminal.

[0088] Through the above scheme, this embodiment obtains a list of instantiated models corresponding to the model series to be checked; starts an MBOM integrity check according to the instantiated model list to obtain an inspection result; determines a problem list from the inspection result, and feeds the problem list back to the terminal, so as to realize automatic processing of MBOM data integrity check for multiple model series and multiple time points, automatically identify the instantiated model list and submit it for inspection, avoid the risk of error in manual processing, improve the accuracy of BOM data calculation, reduce MBOM management costs, and improve the speed and efficiency of MBOM data integrity control.

[0089] Based on the above hardware structure, an embodiment of the MBOM data integrity control method of the present invention is proposed.

[0090] Reference Figure 2 , Figure 2 FIG. 1 is a flow chart of a first embodiment of a method for controlling MBOM data integrity according to the present invention.

[0091] In a first embodiment, the MBOM data integrity control method comprises the following steps:

[0092] Step S10: Obtain a list of instantiated vehicle models corresponding to the vehicle model series to be checked.

[0093] It should be noted that the instantiated vehicle model list is a data integration list of various instantiated vehicle models included in the vehicle model series to be checked, and the instantiated vehicle model list is generally obtained from a database or storage device that pre-stores corresponding data.

[0094] Step S20: Start the MBOM integrity check according to the instantiated vehicle model list to obtain the check result.

[0095] It should be understood that the MBOM integrity check function can be started according to the instantiated vehicle model list to obtain an integrity check result.

[0096] Step S30: determine a problem list from the inspection results, and feed the problem list back to the terminal.

[0097] It is understandable that a list of abnormal problems can be determined from the inspection results, and the list of problems can then be fed back to the terminal.

[0098] Through the above scheme, this embodiment obtains a list of instantiated models corresponding to the model series to be checked; starts an MBOM integrity check according to the instantiated model list to obtain an inspection result; determines a problem list from the inspection result, and feeds the problem list back to the terminal, so as to realize automatic processing of MBOM data integrity check for multiple model series and multiple time points, automatically identify the instantiated model list and submit it for inspection, avoid the risk of error in manual processing, improve the accuracy of BOM data calculation, reduce MBOM management costs, and improve the speed and efficiency of MBOM data integrity control.

[0099] Further, Figure 3 FIG. 1 is a flow chart of a second embodiment of the MBOM data integrity control method of the present invention. Figure 3 As shown, a second embodiment of the MBOM data integrity control method of the present invention is proposed based on the first embodiment. In this embodiment, the step S10 specifically includes the following steps:

[0100] Step S11: When the current time reaches a preset time point, the task is automatically started.

[0101] It should be noted that when the current time reaches a preset time point, the task of performing the MBOM integrity check may be automatically started.

[0102] Step S12: identifying a list of instantiated vehicle models corresponding to the vehicle model series to be checked from the preset vehicle model library according to the preset identification time point.

[0103] It can be understood that, according to the preset recognition time point, a list of instantiated models corresponding to the model series to be checked can be identified from the preset model library.

[0104] Furthermore, the step S12 specifically includes the following steps:

[0105] Obtain all instantiated models in the model library, compare the preset identification time point with the validity period of all instantiated models, and take the model within the validity period at the preset identification time point as the model to be verified;

[0106] The vehicle model library is traversed, a vehicle model series to be checked is generated according to all vehicle models to be verified, and an instantiated vehicle model list of the vehicle model series to be checked is generated.

[0107] It should be understood that the task is automatically started at a time point, and a list of instantiated models of the model series to be checked is identified from the model library at the specified time point.

[0108] In the specific implementation, the MBOM integrity check plan for each month of the year can be determined according to the company's overall parts ordering plan. For example, the MBOM integrity check plan for each month of the year 2023 is set in the system. For example, the check plan for March is as follows:

[0109]

[0110] According to the operating rules, MBOM integrity verification is required at three time points: A (2023 / 5 / XX), B (2023 / 6 / XX), and C (2023 / 7 / XX) on 2023 / 3 / XX; once the system time reaches 2023 / 3 / XX, the system automatically starts the work task, first comparing the validity period of all instantiated models in the model library according to time point A. When the model effective date <= time point A < model deadline, the model is determined to be the model to be verified at time point A. This method is used to traverse the instantiated models in the model library, identify the total list of models to be verified at time point A, and specify the expansion date of these models as A. According to this method, the system completes the identification of models to be verified at time points B and C in turn.

[0111] The model list information includes: assembly center + 24-digit model + optional mark + management mark + deployment date

[0112] For example:

[0113] CM LqCy Pers Gest Date VD 1CWKxxxxxxxxxxxxxxxxxxxx 0000 C100 XX052023

[0114] Through the above scheme, this embodiment automatically starts the task when the current time reaches the preset time point; identifies the instantiated model list corresponding to the model series to be checked from the preset model library according to the preset identification time point; can accurately obtain the instantiated model list of the model series to be checked, thereby improving the speed and efficiency of MBOM data integrity control.

[0115] Further, Figure 4 FIG. 1 is a flow chart of a third embodiment of the MBOM data integrity control method of the present invention. Figure 4 As shown, a third embodiment of the MBOM data integrity control method of the present invention is proposed based on the first embodiment. In this embodiment, the step S20 specifically includes the following steps:

[0116] Step S21: acquiring basic data from the MBOM according to the instantiated vehicle model list.

[0117] It should be noted that, according to the submitted vehicle model list, basic data can be obtained from the MBOM, that is, according to the instantiated vehicle model list, basic data can be obtained from the MBOM.

[0118] Furthermore, the step S21 specifically includes the following steps:

[0119] Obtaining a vehicle model logo list, function code configuration table data and a parts configuration expression table from the MBOM according to the instantiated vehicle model list;

[0120] Obtaining vehicle model mark data of vehicle models, optional marks and management marks developed according to a specified date from the vehicle model mark list;

[0121] Obtaining the assembly center, vehicle model series, function code, workshop, coefficient, unit, configuration expression, start date and end date from the function code configuration table data;

[0122] Obtaining part information, the function code, the use workshop, the coefficient, the unit, the configuration expression, the start date and the end date from the part configuration expression table;

[0123] The vehicle type identification data, the parts information, the assembly center, the vehicle type series, the function code, the use workshop, the coefficient, the unit, the configuration expression, the start date and the end date are used as basic data.

[0124] It is understandable that the basic data obtained from MBOM includes the following three parts:

[0125] 1. Model-Logo List: Expand the submitted 24-digit model + optional logo + management logo into logos according to the specified date.

[0126] 2. Get the function code configuration table data from MBOM. The data includes the following information: assembly center, vehicle model series, function code, workshop, coefficient, unit, configuration expression, start date, and end date.

[0127] 3. Part-configuration expression table in MBOM, information includes: part, function code, workshop, coefficient, unit, configuration expression, start date, and end date.

[0128] Step S22: Start the MBOM integrity check function, and verify the basic data one by one according to different function codes within a specified date to obtain the check result.

[0129] It should be understood that after the MBOM integrity check function is started, the basic data can be checked one by one according to different function codes within a specified date to obtain a check result.

[0130] Furthermore, the step S22 specifically includes the following steps:

[0131] Start the MBOM integrity check function, expand the instantiated vehicle models in the instantiated vehicle model list on a specified date, and obtain the corresponding target function code, target workshop, and target parts list;

[0132] Summarizing the target function code, the target use workshop and the target parts list to obtain a first master list corresponding to each vehicle model, each function code, each use workshop and each coefficient;

[0133] According to the function code configuration table data combined with the time point information and the vehicle type mark definition information, a second master list corresponding to each vehicle type, each function code, each workshop and each coefficient is obtained;

[0134] The first master list and the second master list are compared to identify differences and matching data, all instantiated vehicle models are traversed, and inspection results are generated according to the differences and the matching data.

[0135] In the specific implementation, for the submitted vehicle model, find the corresponding assembly center + vehicle model series in the function code configuration table, and verify them one by one according to the function code on the specified date:

[0136] 1. For the instantiated vehicle model submitted, expand the vehicle model at the specified time point to obtain the function code + workshop used + parts list, and summarize to obtain the total list of vehicle model + function code + workshop used + coefficient.

[0137] A sample total list is shown in the following table:

[0138] family date refer code fonc desi ch usiuti coefnfc Instantiate Model 1 … … … … … … … 1PXX 20220425 A2613001 Intake pipe assembly VD5 1,000 1 1PXX 20220425 A3811002 Multi-function switch module VD5 2,000 1 1PXX 20220425 E2525608 Rear suspension spring VD5 1,000 1 1PXX 20220425 W1A01008 Back door glass pad VD5 4,000 1 1PXX 20220425 W2C01001 Right door glass outer sealing strip VD5 2,000 1 … … … … … … …

[0139] 2. According to the function code configuration table, combined with the time point and vehicle model logo definition information, comprehensive calculation is performed to obtain the total list of vehicle model + function code + workshop used + coefficient.

[0140] A sample total list is shown in the following table:

[0141] family date refer code fonc desi ch usiuti coef table Instantiate Model 1 … … … … … … … 1PXX 20220425 A2609002 Air heat exchanger VD5 1,000 1 1PXX 20220425 A2613001 Intake pipe assembly VD5 1,000 1 1PXX 20220425 A3811002 Multi-function switch module VD5 2,000 1 1PXX 20220425 W1A01008 Back door glass pad VD5 4,000 1 1PXX 20220425 W2C01001 Right door glass outer sealing strip VD5 1,000 1 … … … … … … …

[0142] 3. Compare the above two master lists and identify the differences.

[0143] 4. Follow the above steps to complete the verification of all instantiated models one by one.

[0144] Through the above scheme, this embodiment obtains basic data from the MBOM according to the instantiated vehicle model list; starts the MBOM integrity check function, verifies the basic data one by one according to different function codes within a specified date, and obtains the inspection result. The inspection result of the MBOM integrity check can be quickly obtained, and the instantiated vehicle model list can be automatically identified and submitted for inspection, avoiding the risk of errors in manual processing and improving the accuracy of BOM data calculation.

[0145] Further, Figure 5 FIG. 4 is a flow chart of a fourth embodiment of the MBOM data integrity control method of the present invention. Figure 5 As shown, a fourth embodiment of the MBOM data integrity control method of the present invention is proposed based on the first embodiment. In this embodiment, step S30 specifically includes the following steps:

[0146] Step S31, obtaining the first error information from the inspection result that the current part has a coefficient, and the current function code and the configuration table coefficient of the current workshop are empty.

[0147] It should be noted that the inspection results have different error messages. The first error message is that the current part has a coefficient, and the configuration table coefficients of the current function code and the current workshop are empty, that is, the function code + workshop of the part cannot match the rule in the function code configuration table: the part is not defined in the function code configuration table, that is, the part has a coefficient, and the coefficient of the function code configuration table is empty.

[0148] Step S32, obtaining from the inspection result the second error information that the current function code and the configuration table of the currently used workshop have coefficients, and the current part coefficient is empty.

[0149] It can be understood that the second error message is that the inspection result is that the configuration table of the current function code and the currently used workshop has coefficients, and the current part coefficient is empty, that is, according to the function code configuration table rules, no parts can be matched in the submitted vehicle model expansion: the function code configuration table has no corresponding part definition, that is, the function code configuration table has coefficients, and the part coefficient is empty.

[0150] Step S33: Obtain third error information from the inspection result that the coefficient of the currently used workshop under the same current function code is inconsistent with the coefficient of the configuration table of the current function code and the currently used workshop.

[0151] It should be understood that the third error message is that the inspection result is that the coefficient of the currently used workshop under the same current function code is inconsistent with the coefficient of the configuration table of the current function code and the currently used workshop, that is, the coefficient sum of the same function code + used workshop under the vehicle model is inconsistent with the coefficient sum in the function code configuration table: coefficient error.

[0152] Step S34: Generate a problem list according to the first error information, the second error information and the third error information, and feed back the problem list to the terminal.

[0153] It can be understood that a problem list can be generated based on the first error message, the second error message and the third error message, and then the problem list is determined to be fed back to the terminal of the person in charge of the vehicle model. The terminal can be a fixed terminal or a mobile terminal, and this embodiment does not limit this.

[0154] In the specific implementation, the test results have the following four situations:

[0155] 1. According to the function code of the part + the use workshop, no rules can be matched in the function code configuration table: Error type 11, the part is not defined in the function code configuration table, that is, the part has a coefficient, and the coefficient in the function code configuration table is empty.

[0156] 2. According to the function code configuration table rules, no parts can be matched in the submitted vehicle model expansion: Error type 12, the function code configuration table has no corresponding part definition, that is, the function code configuration table has coefficients, and the part coefficients are empty.

[0157] 3. The coefficient sum of the same function code + workshop used under the vehicle model is inconsistent with the coefficient sum in the function code configuration table: Error type 13, coefficient error.

[0158] 4. The parts and function code configuration table rules can be matched, and the coefficients are consistent: no difference.

[0159] example:

[0160]

[0161] See also Figure 6 , Figure 6 FIG. 1 is a schematic diagram of an integrity control system in the MBOM data integrity control method of the present invention, as shown in FIG. Figure 6 As shown, the integrity control system includes: an instantiated vehicle model list recognition module, an instantiated vehicle model list input module, an MBOM verification module, a function code configuration table generation module and a difference result input module; wherein, the instantiated vehicle model list recognition module: is used to identify the instantiated vehicle model list at a specific time point; the instantiated vehicle model list input module: is used to submit the instantiated vehicle model and start the MBOM verification work; the function code configuration table generation module: is used to pre-build the vehicle model function code configuration table; the MBOM verification module: is used to complete the comparison and verification of the MBOM and function code configuration table data according to the function code one by one; the difference result output module: displays the difference between the MBOM and the function code configuration table, which is convenient for users to identify and subsequently analyze and process.

[0162] In a specific implementation, a car company instantiates 3,000 car models. Using the traditional manual method, it takes an average of 2 minutes to input an instantiated car model into the system for integrity check. To verify the data at three time points each month, it takes 18,000 minutes just to input these car models into the system. Even if 10 MBOM engineers handle it at the same time, it will take nearly 4 days to complete, which is about 1.7 man-years of human resources throughout the year. After adopting this embodiment, the relevant work system is completed by itself, and the MBOM data check at three time points can produce results in half a day, which does not occupy human resources, saves labor costs for the company, and greatly improves the MBOM management efficiency, avoids the risk of errors caused by manual misoperation, and ensures the accuracy of the results.

[0163] This embodiment adopts the above scheme, by obtaining from the inspection result the first error information that the current part has a coefficient, and the coefficient of the configuration table of the current function code and the current workshop is empty; obtaining from the inspection result the second error information that the configuration table of the current function code and the current workshop has a coefficient, and the current part coefficient is empty; obtaining from the inspection result the third error information that the coefficient of the current workshop under the same current function code is inconsistent with the coefficient of the configuration table of the current function code and the current workshop; generating a problem list according to the first error information, the second error information and the third error information, and determining and feeding back the problem list to the terminal; being able to realize automated processing of MBOM data integrity verification for multiple vehicle series and multiple time points, being able to automatically identify the instantiated vehicle model list and submit it for inspection, avoiding the risk of errors in manual processing, improving the accuracy of BOM data calculation, reducing MBOM management costs, and improving the speed and efficiency of MBOM data integrity control.

[0164] Accordingly, the present invention further provides an MBOM data integrity control device.

[0165] Reference Figure 7 , Figure 7 It is a functional module diagram of the first embodiment of the MBOM data integrity control device of the present invention.

[0166] In a first embodiment of the MBOM data integrity control device of the present invention, the MBOM data integrity control device comprises:

[0167] The list acquisition module 10 is used to acquire an instantiated vehicle model list corresponding to the vehicle model series to be checked.

[0168] The integrity check module 20 is used to start the MBOM integrity check according to the instantiated vehicle model list and obtain the check result.

[0169] The feedback module 30 is used to determine a problem list from the inspection result and feed back the problem list to the terminal.

[0170] The list acquisition module 10 is also used to automatically start the task when the current time reaches a preset time point; and identify the instantiated model list corresponding to the model series to be checked from the preset model library according to the preset identification time point.

[0171] The list acquisition module 10 is also used to obtain all instantiated vehicle models in the vehicle model library, compare the preset identification time point with the validity period of all the instantiated vehicle models, and use the vehicle model within the validity period at the preset identification time point as the vehicle model to be verified; traverse the vehicle model library, generate a vehicle model series to be checked based on all the vehicle models to be verified, and generate an instantiated vehicle model list of the vehicle model series to be checked.

[0172] The integrity check module 20 is further used to obtain basic data from the MBOM according to the instantiated vehicle model list; start the MBOM integrity check function, and verify the basic data one by one according to different function codes within a specified date to obtain a check result.

[0173] The integrity check module 20 is further used to obtain a vehicle model mark list, function code configuration table data and a part configuration expression table from the MBOM according to the instantiated vehicle model list; obtain the vehicle model mark data of the vehicle model, optional mark and management mark expanded according to the specified date from the vehicle model mark list; obtain the assembly center, vehicle model series, function code, workshop, coefficient, unit, configuration expression, start date and end date from the function code configuration table data; obtain the part information, the function code, the workshop, the coefficient, the unit, the configuration expression, the start date and the end date from the part configuration expression table; and use the vehicle model mark data, the part information, the assembly center, the vehicle model series, the function code, the workshop, the coefficient, the unit, the configuration expression, the start date and the end date as basic data.

[0174] The integrity check module 20 is also used to start the MBOM integrity check function, expand the instantiated vehicle models of the instantiated vehicle model list on a specified date, and obtain the corresponding target function code, target use workshop and target parts list; summarize the target function code, the target use workshop and the target parts list to obtain a first general list corresponding to each vehicle model, each function code, each use workshop and each coefficient; obtain a second general list corresponding to each vehicle model, each function code, each use workshop and each coefficient according to the function code configuration table data combined with the time point information and the vehicle model mark definition information; compare the first general list with the second general list, identify the difference part and the matching data, traverse all instantiated vehicle models, and generate a check result according to the difference part and the matching data.

[0175] The feedback module 30 is also used to obtain a first error message from the inspection result that the current part has a coefficient, and the coefficient of the configuration table of the current function code and the current workshop is empty; obtain a second error message from the inspection result that the current function code and the configuration table of the current workshop have a coefficient, and the current part coefficient is empty; obtain a third error message from the inspection result that the coefficient of the current workshop under the same current function code is inconsistent with the coefficient of the configuration table of the current function code and the current workshop; generate a problem list based on the first error information, the second error information and the third error information, and determine the problem list to be fed back to the terminal.

[0176] The steps implemented by the functional modules of the MBOM data integrity control device may refer to the various embodiments of the MBOM data integrity control method of the present invention, and will not be described in detail here.

[0177] In addition, an embodiment of the present invention further provides a storage medium, on which an MBOM data integrity control program is stored, and when the MBOM data integrity control program is executed by a processor, the following operations are implemented:

[0178] Get the list of instantiated models corresponding to the model series to be checked;

[0179] Initiate MBOM integrity check according to the instantiated vehicle model list and obtain a check result;

[0180] A problem list is determined from the inspection results, and the problem list is fed back to the terminal.

[0181] Furthermore, when the MBOM data integrity control program is executed by the processor, the following operations are also implemented:

[0182] When the current time reaches the preset time point, the task will be automatically started;

[0183] According to the preset identification time point, a list of instantiated models corresponding to the model series to be checked is identified from the preset model library.

[0184] Furthermore, when the MBOM data integrity control program is executed by the processor, the following operations are also implemented:

[0185] Obtain all instantiated models in the model library, compare the preset identification time point with the validity period of all instantiated models, and take the model within the validity period at the preset identification time point as the model to be verified;

[0186] The vehicle model library is traversed, a vehicle model series to be checked is generated according to all vehicle models to be verified, and an instantiated vehicle model list of the vehicle model series to be checked is generated.

[0187] Furthermore, when the MBOM data integrity control program is executed by the processor, the following operations are also implemented:

[0188] Obtaining basic data from the MBOM according to the instantiated vehicle model list;

[0189] The MBOM integrity check function is started, and the basic data is checked one by one according to different function codes within a specified date to obtain the check result.

[0190] Furthermore, when the MBOM data integrity control program is executed by the processor, the following operations are also implemented:

[0191] Obtaining a vehicle model logo list, function code configuration table data and a parts configuration expression table from the MBOM according to the instantiated vehicle model list;

[0192] Obtaining vehicle model mark data of vehicle models, optional marks and management marks developed according to a specified date from the vehicle model mark list;

[0193] Obtaining the assembly center, vehicle model series, function code, workshop, coefficient, unit, configuration expression, start date and end date from the function code configuration table data;

[0194] Obtaining part information, the function code, the use workshop, the coefficient, the unit, the configuration expression, the start date and the end date from the part configuration expression table;

[0195] The vehicle type identification data, the parts information, the assembly center, the vehicle type series, the function code, the use workshop, the coefficient, the unit, the configuration expression, the start date and the end date are used as basic data.

[0196] Furthermore, when the MBOM data integrity control program is executed by the processor, the following operations are also implemented:

[0197] Start the MBOM integrity check function, expand the instantiated vehicle models in the instantiated vehicle model list on a specified date, and obtain the corresponding target function code, target workshop, and target parts list;

[0198] Summarizing the target function code, the target use workshop and the target parts list to obtain a first master list corresponding to each vehicle model, each function code, each use workshop and each coefficient;

[0199] According to the function code configuration table data combined with the time point information and the vehicle type mark definition information, a second master list corresponding to each vehicle type, each function code, each workshop and each coefficient is obtained;

[0200] The first master list and the second master list are compared to identify differences and matching data, all instantiated vehicle models are traversed, and inspection results are generated according to the differences and the matching data.

[0201] Furthermore, when the MBOM data integrity control program is executed by the processor, the following operations are also implemented:

[0202] Obtaining first error information from the inspection result that the current part has a coefficient, the current function code and the configuration table coefficient of the current workshop are empty;

[0203] Obtaining from the inspection result a second error message that the current function code and the configuration table of the currently used workshop have coefficients, and the current part coefficient is empty;

[0204] Obtaining third error information from the inspection result that the coefficient of the currently used workshop under the same current function code is inconsistent with the coefficient of the configuration table of the current function code and the currently used workshop;

[0205] A question list is generated according to the first error information, the second error information, and the third error information, and the question list is determined and fed back to the terminal.

[0206] Those skilled in the art will appreciate that all or part of the steps in the above-mentioned implementation method can be accomplished by instructing related hardware through a program, and the program is stored in a storage medium, including a number of instructions for enabling a device (which may be a single-chip microcomputer, chip, etc.) or a processor to execute all or part of the steps of the method described in each implementation method of the present application; and the aforementioned storage medium is a computer-readable storage medium, including: a U disk, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a disk or an optical disk, and other media that can store program codes.

[0207] It should be noted that, in this article, the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, an element defined by the sentence "comprises a ..." does not exclude the existence of other identical elements in the process, method, article or device including the element.

[0208] The serial numbers of the above embodiments of the present invention are only for description and do not represent the advantages or disadvantages of the embodiments.

[0209] The above are only preferred embodiments of the present invention, and are not intended to limit the patent scope of the present invention. Any equivalent structure or equivalent process transformation made using the contents of the present invention specification and drawings, or directly or indirectly applied in other related technical fields, are also included in the patent protection scope of the present invention.

Claims

1. A method for controlling MBOM data integrity, characterized in that: The MBOM data integrity control method comprises: Get the list of instantiated models corresponding to the model series to be checked; Initiate MBOM integrity check according to the instantiated vehicle model list and obtain a check result; A problem list is determined from the inspection results, and the problem list is fed back to the terminal.

2. The MBOM data integrity control method according to claim 1, wherein: The step of obtaining a list of instantiated vehicle models corresponding to the vehicle model series to be checked includes: When the current time reaches the preset time point, the task will be automatically started; According to the preset identification time point, a list of instantiated models corresponding to the model series to be checked is identified from the preset model library.

3. The MBOM data integrity control method according to claim 2, wherein: The step of identifying, from a preset vehicle model library, a list of instantiated vehicle models corresponding to the vehicle model series to be checked according to the preset identification time point includes: Obtain all instantiated models in the model library, compare the preset identification time point with the validity period of all instantiated models, and take the model within the validity period at the preset identification time point as the model to be verified; The vehicle model library is traversed, a vehicle model series to be checked is generated according to all vehicle models to be verified, and an instantiated vehicle model list of the vehicle model series to be checked is generated.

4. The MBOM data integrity control method according to claim 1, wherein: The initiating the MBOM integrity check according to the instantiated vehicle model list to obtain the check result includes: Obtaining basic data from the MBOM according to the instantiated vehicle model list; The MBOM integrity check function is started, and the basic data is checked one by one according to different function codes within a specified date to obtain the check result.

5. The MBOM data integrity control method according to claim 4, characterized in that: The acquiring basic data from the MBOM according to the instantiated vehicle model list includes: Obtaining a vehicle model logo list, function code configuration table data and a parts configuration expression table from the MBOM according to the instantiated vehicle model list; Obtaining vehicle model mark data of vehicle models, optional marks and management marks developed according to a specified date from the vehicle model mark list; Obtaining the assembly center, vehicle model series, function code, workshop, coefficient, unit, configuration expression, start date and end date from the function code configuration table data; Obtaining part information, the function code, the use workshop, the coefficient, the unit, the configuration expression, the start date and the end date from the part configuration expression table; The vehicle type identification data, the parts information, the assembly center, the vehicle type series, the function code, the use workshop, the coefficient, the unit, the configuration expression, the start date and the end date are used as basic data.

6. The MBOM data integrity control method according to claim 5, characterized in that: The MBOM integrity check function is started to check the basic data one by one according to different function codes within a specified date to obtain the check result, including: Start the MBOM integrity check function, expand the instantiated vehicle models in the instantiated vehicle model list on a specified date, and obtain the corresponding target function code, target workshop, and target parts list; Summarizing the target function code, the target use workshop and the target parts list to obtain a first master list corresponding to each vehicle model, each function code, each use workshop and each coefficient; According to the function code configuration table data combined with the time point information and the vehicle type mark definition information, a second master list corresponding to each vehicle type, each function code, each workshop and each coefficient is obtained; The first master list and the second master list are compared to identify differences and matching data, all instantiated vehicle models are traversed, and inspection results are generated according to the differences and the matching data.

7. The MBOM data integrity control method according to claim 1, wherein: Determining a problem list from the inspection results and feeding the problem list back to the terminal includes: Obtaining first error information from the inspection result that the current part has a coefficient, the current function code and the configuration table coefficient of the current workshop are empty; Obtaining from the inspection result a second error message that the current function code and the configuration table of the currently used workshop have coefficients, and the current part coefficient is empty; Obtaining third error information from the inspection result that the coefficient of the currently used workshop under the same current function code is inconsistent with the coefficient of the configuration table of the current function code and the currently used workshop; A question list is generated according to the first error information, the second error information, and the third error information, and the question list is determined and fed back to the terminal.

8. An MBOM data integrity control device, characterized in that: The MBOM data integrity control device comprises: A list acquisition module is used to acquire a list of instantiated models corresponding to the model series to be checked; An integrity check module, used to start the MBOM integrity check according to the instantiated vehicle model list and obtain the check result; The feedback module is used to determine a problem list from the inspection results and feed back the problem list to the terminal.

9. An MBOM data integrity control device, characterized in that: The MBOM data integrity control device comprises: a memory, a processor, and an MBOM data integrity control program stored in the memory and executable on the processor, wherein the MBOM data integrity control program is configured to implement the steps of the MBOM data integrity control method according to any one of claims 1 to 7.

10. A storage medium, characterized in that: The storage medium stores an MBOM data integrity control program, and when the MBOM data integrity control program is executed by the processor, the steps of the MBOM data integrity control method according to any one of claims 1 to 7 are implemented.

Images