Method, device, equipment and medium for processing the entire process of reconciliation documents

Abstract

The embodiment of the present invention discloses a method, device, equipment and medium for processing the entire process of reconciliation files. The method includes: performing data processing operations on the initial reconciliation file through a file processing module to obtain a data processing result file and storing it in a file storage module; receiving the processing result of the data processing operation through a process monitoring module, and storing the processing status after format conversion in a status matrix module; if an abnormal reconciliation file occurs during the data processing operation, obtaining the processing status corresponding to the abnormal reconciliation file through an abnormal processing module; matching subsequent data processing operations for the abnormal reconciliation file according to the processing status corresponding to the abnormal reconciliation file, and completing the processing of the abnormal reconciliation file. Through the technical solution of the embodiment of the present invention, it is possible to realize accurate monitoring of the reconciliation file processing process and realize the subsequent intelligent processing of abnormal reconciliation files, thereby improving the processing rate of the reconciliation file.

Description

Technical Field

[0001] Embodiments of the present invention relate to the field of computer technology, and in particular to a method, device, equipment and medium for processing the entire process of reconciliation files. Background Art

[0002] In financial transaction systems, inter-platform reconciliation is one of the important scenarios. In the reconciliation scenario, the transaction details between two or more systems are exchanged in the form of reconciliation files and the relevant account verification is completed to ensure that the accounts of all parties are consistent. Usually, in order to ensure the confidentiality and data integrity of the reconciliation file, the provider of the reconciliation file needs to perform a series of operations on the reconciliation file, such as encryption, signing, compression or splitting, and the recipient of the reconciliation file needs a series of corresponding processes to process the reconciliation file, such as downloading, decompression or decryption. Since the confidentiality and data integrity of the reconciliation file are very important to the financial transaction system, if the reconciliation file has data missing, errors or damage, it will cause errors in the reconciliation between platforms, resulting in serious system failures such as accounting errors. Therefore, a relatively complete process monitoring mechanism is needed to track the processing results of the reconciliation file in real time, and when the reconciliation file processing fails, a more intelligent and efficient method is needed to handle abnormal reconciliation files.

[0003] In the prior art, most of the reconciliation file processing flow is linear processing, and the coupling degree of each functional module is relatively high. Therefore, when an exception occurs in any step of the reconciliation file processing flow, the entire reconciliation file processing flow fails, causing the initial reconciliation file to be marked as an abnormal reconciliation file. However, since there is no refined state in the prior art to mark the location where the abnormal reconciliation file processing fails, and if the abnormal reconciliation file is processed later, it is impossible to determine which data processing operation step failed to cause the abnormal reconciliation file, and the processing steps of the abnormal reconciliation file can only be executed from the beginning, resulting in inefficient abnormal reconciliation file processing and excessive resource occupation. Therefore, how to achieve accurate monitoring of each processing flow of the reconciliation file and achieve subsequent intelligent processing of abnormal reconciliation files is a problem that urgently needs to be solved. Summary of the invention

[0004] The embodiments of the present invention provide a method, device, equipment and medium for processing the entire process of a reconciliation file, which can realize accurate monitoring of each processing process of the reconciliation file and realize the subsequent intelligent processing of abnormal reconciliation files.

[0005] In a first aspect, an embodiment of the present invention provides a method for processing a reconciliation file in the entire process, the method being applied to a reconciliation file receiving end, the method comprising:

[0006] Performing data processing operations on the initial reconciliation file through a file processing module to obtain a data processing result file;

[0007] Storing the data processing result file through a file storage module;

[0008] The process monitoring module receives the processing result of the data processing operation, and converts the format of the processing result to obtain the corresponding processing status;

[0009] The processing state is stored in the form of a state code by a state matrix module;

[0010] If an abnormal reconciliation file appears during the data processing operation of the initial reconciliation file, the status code in the status matrix module is obtained, and the status code is processed by the exception processing module to obtain the processing status corresponding to the abnormal reconciliation file; and the subsequent data processing operation is matched for the abnormal reconciliation file according to the processing status corresponding to the abnormal reconciliation file, so as to complete the processing of the abnormal reconciliation file.

[0011] In a second aspect, an embodiment of the present invention further provides a device for processing a reconciliation file in the entire process, the device being applied to a receiving end of the reconciliation file, the device comprising:

[0012] A file processing module, used to perform data processing operations on the initial reconciliation file to obtain a data processing result file;

[0013] A file storage module, used to store the data processing result file;

[0014] A process monitoring module is used to receive the processing result of the data processing operation and convert the format of the processing result to obtain the corresponding processing status;

[0015] A state matrix module, used for storing the processing state in the form of a state code;

[0016] The exception processing module is used to obtain the status code in the status matrix module if an abnormal reconciliation file appears during the data processing operation of the initial reconciliation file, process the status code to obtain the processing status corresponding to the abnormal reconciliation file; and match the subsequent data processing operation for the abnormal reconciliation file according to the processing status corresponding to the abnormal reconciliation file to complete the processing of the abnormal reconciliation file.

[0017] In a third aspect, an embodiment of the present invention further provides a computer device, the computer device comprising:

[0018] one or more processors;

[0019] a storage device for storing one or more programs,

[0020] When the one or more programs are executed by the one or more processors, the one or more processors implement the full-process processing method for reconciliation files as described in any embodiment of the present invention.

[0021] In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium on which a computer program is stored, characterized in that when the program is executed by a processor, a full-process processing method for reconciliation files as described in any embodiment of the present invention is implemented.

[0022] The technical solution of the embodiment of the present invention monitors the process of performing data processing operations on the initial reconciliation file and records the processing results corresponding to each step, then converts the processing results into corresponding processing states, and stores the processing states in the form of status codes in a state matrix module. When the abnormal reconciliation file is processed again, the processing state corresponding to the abnormal reconciliation file is obtained through the status code of the abnormal reconciliation file, and the subsequent data processing operations are matched for the abnormal reconciliation file according to the processing state corresponding to the abnormal reconciliation file, so as to complete the processing of the abnormal reconciliation file, thereby solving the problems of insufficient granularity of monitoring the processing flow of the reconciliation file and the inability to continuously process the abnormal reconciliation file in the prior art, and realizing accurate monitoring of each processing flow of the reconciliation file and realizing continuous intelligent processing of the abnormal reconciliation file, thereby improving the processing rate of the reconciliation file. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] Figure 1 It is a flow chart of a method for processing reconciliation files in the prior art;

[0024] Figure 2a It is a flow chart of a method for processing a reconciliation file in its entirety provided by an embodiment of the present invention;

[0025] Figure 2b is a flow chart of a method for processing a reconciliation file provided by an embodiment of the present invention;

[0026] Figure 2c It is a flow chart of a method for monitoring a reconciliation file processing flow provided by an embodiment of the present invention;

[0027] Figure 3a It is a flow chart of a method for processing a reconciliation file in its entirety provided by an embodiment of the present invention;

[0028] Figure 3b It is a flow chart of a method for processing abnormal reconciliation files provided by an embodiment of the present invention;

[0029] Figure 4a It is a structural schematic diagram of a preferred full-process processing device for reconciliation files provided by an embodiment of the present invention;

[0030] Figure 4bThis is a workflow diagram of a preferred full-process processing device for reconciliation files provided by an embodiment of the present invention;

[0031] Figure 5 It is a structural schematic diagram of a full-process processing device for reconciliation files provided by an embodiment of the present invention;

[0032] Figure 6 It is a structural schematic diagram of a computer device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0033] The present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It is to be understood that the specific embodiments described herein are only used to explain the present invention, rather than to limit the present invention. It should also be noted that, for ease of description, only parts related to the present invention, rather than all structures, are shown in the accompanying drawings.

[0034] Nowadays, in important financial transaction systems, in order to ensure the accuracy and consistency of accounts, inter-system reconciliation is an indispensable link. In the reconciliation scenario, transaction information between two or more systems is usually exchanged in the form of reconciliation files and relevant account verification is completed to ensure that the accounts of all parties remain consistent.

[0035] like Figure 1 The figure is a flow chart of a method for processing reconciliation files in the prior art. Figure 1 As shown, in the prior art, the processing of the reconciliation file is usually performed linearly in the order of "P1: file download -> P2: file decompression -> P3: file sorting -> P4: reconciliation". When an exception occurs in any of the above steps, the entire processing flow fails, and there is no refined status to mark the location where the reconciliation file processing failed. If the abnormal reconciliation file that failed to be processed is processed later, it is impossible to determine at which step the reconciliation file failed, and the reconciliation file processing flow from P1 to P4 can only be executed from the beginning.

[0036] However, in the scenario of reconciliation file processing, since the previous steps need to be re-executed after the Pn step of the reconciliation file processing fails, a large part of time will be wasted on the previous steps that were originally processed successfully, resulting in inefficient processing of abnormal reconciliation files and excessive occupation of resources. For example, when P3 processing fails, the abnormal reconciliation file reprocessing steps are: P1->P2->P3->P4.

[0037] Therefore, the embodiment of the present invention provides a method for processing the entire process of reconciliation files, which can realize accurate monitoring of each processing process of the reconciliation files and realize the subsequent intelligent processing of abnormal reconciliation files, thereby improving the processing rate of the reconciliation files.

[0038] Figure 2aA flowchart of a method for processing a reconciliation file throughout the entire process provided by an embodiment of the present invention. This embodiment can be applied to a reconciliation file receiving end, and can be suitable for monitoring the processing flow of the reconciliation file and for subsequent processing of abnormal reconciliation files. The method can be executed by a reconciliation file full-process processing device, which can be implemented in hardware and / or software, and can generally be integrated in a computer device.

[0039] like Figure 2a As shown, a full-process processing method for reconciliation files provided by an embodiment of the present invention includes the following specific steps:

[0040] S210: Performing data processing operations on the initial reconciliation file through a file processing module to obtain a data processing result file.

[0041] The initial reconciliation file may refer to a reconciliation file obtained from a file storage server of a reconciliation file provider system. The data processing operation may refer to an operation of converting the format of the initial reconciliation file according to actual application requirements to obtain a reconciliation file consistent with the reconciliation file provider system, such as operations such as downloading the initial reconciliation file or decrypting the initial reconciliation file, as well as processing operations for reconciliation. The data processing result file may refer to a result file generated during the data processing process, such as an initial reconciliation file generated during the initial reconciliation file download operation or a decrypted reconciliation file generated during the initial reconciliation file decryption operation.

[0042] In an optional embodiment, the data processing operation on the initial reconciliation file by the file processing module to obtain the data processing result file includes: downloading the corresponding initial reconciliation file from the file storage of the reconciliation file provider system by the file download unit in the file processing module; decrypting the initial reconciliation file by the file decryption unit in the file processing module to obtain a compressed reconciliation file; decompressing the compressed reconciliation file by the file decompression unit in the file processing module to obtain the reconciliation file; merging and sorting the reconciliation file by the merging and sorting unit in the file processing module to obtain the source reconciliation file; obtaining the target reconciliation file at the reconciliation file receiving end by the data extraction unit in the file processing module; and comparing the target reconciliation file with the source reconciliation file by the financial verification unit in the file processing module to complete the reconciliation operation. Among them, the decryption key can refer to a secret information used to complete cryptographic applications such as encryption, decryption or integrity verification; in order to prevent others from stealing the reconciliation file information and ensure the security of the reconciliation file, the reconciliation file provider and the reconciliation file receiver need to use the key to encrypt and decrypt the reconciliation file respectively. Merge sort may refer to a sorting method implemented using the merge idea. The algorithm uses the classic divide-and-conquer strategy to decompose the problem into several fragments and then solve it recursively, and merge the results of each fragment together to obtain the final result. The source reconciliation file may refer to a reconciliation file that is consistent with the system of the reconciliation file provider; the target reconciliation file may refer to the reconciliation file of this system in the reconciliation file receiving end; comparing the target reconciliation file with the source reconciliation file may refer to comparing the contents of the target reconciliation file with the source reconciliation file according to the transaction serial number, transaction amount or transaction date. Therefore, by obtaining the initial reconciliation file and downloading, decrypting, decompressing and merge sorting the initial reconciliation file to obtain a source reconciliation file that is consistent with the system of the reconciliation file provider, and comparing the source reconciliation file with the target reconciliation file, the reconciliation operation can be completed.

[0043] In another optional embodiment, the decrypting the initial reconciliation file by the file decryption unit in the file processing module to obtain the compressed reconciliation file includes: obtaining a corresponding decryption key from the key storage module, and using the decryption key to decrypt the initial reconciliation file by the file decryption unit in the file processing module to obtain the compressed reconciliation file. The decryption key is a key agreed upon by the reconciliation file recipient and the reconciliation file provider for decrypting the initial reconciliation file. In this way, the security of the initial reconciliation file can be guaranteed, so that only the reconciliation file provider and the reconciliation file recipient can operate on the initial reconciliation file.

[0044] S220: storing the data processing result file through a file storage module.

[0045] Storing the data processing result file through the file storage module may refer to correspondingly storing the result file generated in the process of data processing.

[0046] Specifically, Figure 2b FIG. 1 is a flow chart of a method for processing a reconciliation file provided by an embodiment of the present invention. Figure 2b As shown, first, the file download unit accesses the file storage server of the reconciliation file provider system through the file transfer protocol, determines whether the initial reconciliation file exists, downloads the initial reconciliation file of the specified date, and stores the initial reconciliation file in the file storage module; then, the file decryption unit obtains the decryption key in the key storage module, decrypts the initial reconciliation file by the decryption key, obtains the compressed reconciliation file, and stores the compressed reconciliation file in the file storage module; then, the compressed reconciliation file is decompressed by the file decompression unit to obtain the reconciliation file, and the reconciliation file is stored in the file storage module; and the reconciliation file is merged and sorted by the merging and sorting unit to obtain the source reconciliation file, and the source reconciliation file is stored in the file storage module; finally, the target reconciliation file of the reconciliation file receiving end is obtained by the data extraction unit, and the file contents of the target reconciliation file and the source reconciliation file are checked item by item by the financial checking unit to complete the reconciliation operation.

[0047] Among them, the processing results of the data processing operations can be used to display the processing results of each data processing operation after the corresponding processing of the reconciliation file. For example, taking the download operation of the initial reconciliation file as an example, the corresponding processing results may be the initial reconciliation file download completed, the initial reconciliation file does not exist, the initial reconciliation file download interrupted, the connection failed, and the file download unit abnormality, etc.

[0048] S230: receiving the processing result of the data processing operation through the process monitoring module, and converting the format of the processing result to obtain a corresponding processing status.

[0049] The format conversion may refer to classifying the processing result into a corresponding processing state according to the state category of the processing result. The processing state may be success, failure or exception.

[0050] In an optional embodiment, the process monitoring module receives the processing result of the data processing operation and converts the processing result into a format to obtain the corresponding processing state, including: receiving the processing result of the data processing operation in real time through the message receiving unit in the process monitoring module; converting the processing result of the data processing operation into a corresponding processing state according to the state conversion rule through the state conversion unit in the process monitoring module. Wherein, the state conversion rule may refer to a pre-set rule for converting the processing result of the data processing operation into a corresponding processing state. For example, if the data processing operation is the initial reconciliation file download, and the processing result of the data processing operation is the completion of the file download, the processing state of the successful processing state may be converted according to the pre-set processing result of the completion of the file download. Thus, by monitoring the processing result of the data processing operation, the processing result of the data processing operation can be timely known, and the data processing flow of the initial reconciliation file can be tracked in real time. This solves the problem that the prior art only focuses on the final reconciliation file processing result, does not monitor a certain link in the reconciliation file processing flow, causes inadequate monitoring, and overly coarse monitoring granularity, and can more intuitively know the processing state corresponding to the processing result of the data processing operation.

[0051] S240: storing the processing status in the form of a status code through a status matrix module.

[0052] Among them, the status code may refer to a digital code used to store the processing status corresponding to different steps of the data processing operation, and the processing status corresponding to different data processing operation steps may be marked as a corresponding status code according to a preset state conversion rule.

[0053] As shown in Table 1, it is a state transition rule table applicable to the embodiment of the present invention. It can be seen from Table 1 that if the data processing operation is the initial reconciliation file download, if the processing result corresponding to the data processing operation is the completion of the initial reconciliation file download, the corresponding processing state is success, and the corresponding status code is 00. Taking this as an example, the processing states corresponding to the different processing results of the remaining data processing operations and the status codes corresponding to the different processing states of the remaining data processing operations can be known.

[0054] Table 1 State transition rules table

[0055]

[0056] Specifically, Figure 2c FIG. 1 is a flow chart of a method for monitoring a reconciliation file processing flow according to an embodiment of the present invention. Figure 2cAs shown, first, the process monitoring module is started; then, the file processing module performs data processing operations such as downloading, decrypting, decompressing, merging and sorting, data extraction, and reconciliation on the initial reconciliation file, and generates the processing result of the data processing operation. At this time, the process monitoring module monitors the processing result of the generated data processing operation in real time, and the message receiving unit receives the processing result. When the message receiving unit receives the processing result, the state conversion unit converts the processing result into the corresponding processing state according to the state conversion rule; finally, the state matrix module stores the processing state in the form of a state code. In this way, the processing process of the data processing operation is monitored in real time and the execution state of the data processing operation is stored, which is convenient for the implementation of subsequent work.

[0057] S250: If an abnormal reconciliation file appears during the data processing operation of the initial reconciliation file, the status code in the status matrix module is obtained, and the status code is processed by the exception processing module to obtain the processing status corresponding to the abnormal reconciliation file; and the subsequent data processing operation is matched for the abnormal reconciliation file according to the processing status corresponding to the abnormal reconciliation file, so as to complete the processing of the abnormal reconciliation file.

[0058] Among them, the abnormal reconciliation file may refer to the initial reconciliation file whose data processing process is interrupted during the data processing operation of the initial reconciliation file. The subsequent data processing operation may refer to the data processing operation of the abnormal reconciliation file that is interrupted when the data processing operation is performed for the first time and the data processing operation thereafter. Exemplarily, when the data processing operation is performed on the abnormal reconciliation file again, the status code of the abnormal reconciliation file in the state matrix module is obtained, and the status code of the abnormal reconciliation file is processed by the abnormal processing module to obtain the corresponding processing state, and finally, the subsequent data processing operation is matched for the abnormal reconciliation file according to the processing state, and the processing of the abnormal reconciliation file is completed. Specifically, if the status code of the abnormal reconciliation file in the state matrix module is obtained as 21 when the data processing operation is performed on the abnormal reconciliation file again, the processing state corresponding to the status code 21 can be obtained through the abnormal processing module as "failed to decompress the compressed reconciliation file", and then the abnormal reconciliation file is matched with "decompressing the compressed reconciliation file" and the subsequent data processing operation according to the processing state to complete the subsequent processing of the abnormal reconciliation file and improve the processing rate of the reconciliation file.

[0059] The technical solution of the embodiment of the present invention monitors the process of performing data processing operations on the initial reconciliation file and records the processing results corresponding to each step, then converts the processing results into corresponding processing states, and stores the processing states in the form of status codes in a state matrix module. When the abnormal reconciliation file is processed again, the processing state corresponding to the abnormal reconciliation file is obtained through the status code of the abnormal reconciliation file, and the subsequent data processing operations are matched for the abnormal reconciliation file according to the processing state corresponding to the abnormal reconciliation file, so as to complete the processing of the abnormal reconciliation file, thereby solving the problems of insufficient granularity of monitoring the processing flow of the reconciliation file and the inability to continuously process the abnormal reconciliation file in the prior art, and realizing accurate monitoring of each processing flow of the reconciliation file and realizing continuous intelligent processing of the abnormal reconciliation file, thereby improving the processing rate of the reconciliation file.

[0060] Figure 3a A flowchart of a full-process processing method for a reconciliation file provided by an embodiment of the present invention. In this embodiment, optionally, if an abnormal reconciliation file appears during the data processing operation of the initial reconciliation file, the status code in the status matrix module is obtained, and the status code is processed by the exception processing module to obtain the processing status corresponding to the abnormal reconciliation file, including: if an abnormal reconciliation file appears during the data processing operation of the initial reconciliation file, the status code in the status matrix module is obtained; the status code that meets the abnormal processing conditions is screened out by the status screening unit in the exception processing module; the status code that meets the abnormal processing conditions is parsed by the status parsing unit in the exception processing module to obtain the processing status corresponding to the abnormal reconciliation file.

[0061] Optionally, matching the abnormal reconciliation file with a subsequent data processing operation according to the processing status corresponding to the abnormal reconciliation file, completing the processing of the abnormal reconciliation file includes: if the processing status corresponding to the abnormal reconciliation file is that the first step of the data processing operation has failed, executing all steps of the data processing operation; if the processing status corresponding to the abnormal reconciliation file is that steps other than the first step of the data processing operation have failed, obtaining a data processing result file corresponding to the data processing operation step, and executing subsequent steps of data processing corresponding to the processing status.

[0062] like Figure 3a As shown, a full-process processing method for reconciliation files provided by an embodiment of the present invention includes the following specific steps:

[0063] S310: Performing data processing operations on the initial reconciliation file through a file processing module to obtain a data processing result file, and storing the data processing result file through a file storage module.

[0064] S320: receiving the processing result of the data processing operation through the process monitoring module, and converting the format of the processing result to obtain a corresponding processing status.

[0065] S330: storing the processing status in the form of a status code through a status matrix module.

[0066] S340: If an abnormal reconciliation file appears during the data processing operation of the initial reconciliation file, a status code in the status matrix module is obtained.

[0067] Specifically, when the abnormal reconciliation file is processed again, the status code of the abnormal reconciliation file in the status matrix module is first obtained, without directly performing data processing operations, thereby avoiding the problems of inefficient processing rate and excessive resource occupation caused by directly performing data processing operations when the abnormal reconciliation file is large.

[0068] S350: Filter out status codes that meet the exception handling conditions through the status screening unit in the exception handling module.

[0069] Among them, the status code that meets the exception handling conditions may refer to a status code that can be transformed in the subsequent data processing operation process. For example, as shown in Table 1, if the status code is 19, it means that the initial reconciliation file decryption is abnormal, and it is known that the cause of the initial reconciliation file decryption abnormality may be that the initial reconciliation file itself is abnormal or the decryption is abnormal, etc. This reason cannot be solved in the subsequent data processing operation process, resulting in the status code will not change in the subsequent data processing operation process. Therefore, the status code that does not meet the exception handling conditions needs to be screened out.

[0070] In an optional embodiment, filtering out status codes that meet the exception handling conditions through the status screening unit in the exception handling module includes: filtering out status codes indicating that the processing status is not abnormal through the status screening unit in the exception handling module, and retaining them. Among them, the non-abnormal status code may refer to the status code corresponding to the successful or failed execution status. Specifically, as shown in Table 1, if the status code is 09, 19, 29, 39, 49 or 59, the status code is screened out, and if it is other status codes, it is retained, thereby reducing unnecessary waste of resources during data processing operations and improving the processing rate of abnormal reconciliation files.

[0071] S360: The status parsing unit in the exception handling module parses the status code that meets the exception handling condition to obtain the processing status corresponding to the exception reconciliation file.

[0072] Among them, parsing the status code that meets the exception processing conditions may refer to the process of obtaining the processing status corresponding to the abnormal reconciliation file according to the status code that meets the exception processing conditions. For example, by parsing the status code 11 that meets the exception processing conditions, it can be learned that the processing status of the abnormal reconciliation file is that the initial reconciliation file decryption failed.

[0073] S370: Determine whether the processing status corresponding to the abnormal reconciliation file is the failure of the first step of the data processing operation; if so, execute S380; if not, execute S390.

[0074] The first step of the data processing operation may refer to a step of downloading an initial reconciliation file.

[0075] S380: Execute all steps of the data processing operation.

[0076] Specifically, if the processing status corresponding to the abnormal reconciliation file is that the initial reconciliation file download of the data processing operation fails, all steps of the data processing operation are directly performed.

[0077] S390: Obtain the data processing result file corresponding to the data processing operation step, and execute the subsequent steps of the data processing corresponding to the processing status.

[0078] Exemplarily, if the processing status corresponding to the abnormal reconciliation file is not the failure of the initial reconciliation file download of the data processing operation, the corresponding data processing operation is matched according to the processing status corresponding to the current abnormal reconciliation file. Specifically, if the processing status corresponding to the abnormal reconciliation file is the failure of the reconciliation file merging and sorting, the data processing operations of reconciliation file merging and sorting, target reconciliation file extraction and reconciliation are matched for the abnormal reconciliation file, and the data processing operations before the reconciliation file merging and sorting may not be performed, thereby realizing the intelligent continuous processing of the abnormal reconciliation file and improving the processing speed of the abnormal reconciliation file.

[0079] It is worth noting that after the abnormal reconciliation file module in the embodiment of the present invention is started, data processing is only performed once on the abnormal reconciliation. If it fails, the abnormal processing module ends and no longer restarts.

[0080] like Figure 3b FIG. 1 is a flow chart of a method for processing abnormal reconciliation files provided by an embodiment of the present invention. Figure 3bIn the process, when the abnormal reconciliation file is processed again, first, the state matrix module is accessed to obtain the state code in the state matrix module; then, the state code is screened by the state screening unit in the abnormal processing module. If the state code does not meet the abnormal processing conditions, the abnormal reconciliation file subsequent processing is directly terminated; if the state code meets the abnormal processing conditions, the state parsing unit in the abnormal processing module parses the state code that meets the abnormal processing conditions, and determines whether the processing state corresponding to the abnormal reconciliation file is the failure of the initial reconciliation file download. If so, the initial reconciliation file download step is executed, and the subsequent data processing operation is performed after the initial reconciliation file is successfully downloaded; if not, the file storage module is accessed to obtain the data processing result file of the corresponding data processing operation step, and the subsequent data processing operation is performed until the subsequent processing of the abnormal reconciliation file is completed.

[0081] The technical solution of the embodiment of the present invention monitors the process of performing data processing operations on the initial reconciliation file and records the processing results corresponding to each step, then converts the processing results into corresponding processing states, and stores the processing states in the form of status codes in the state matrix module. When the abnormal reconciliation file is processed again, the status code in the state matrix module is first obtained, and the status code that meets the abnormal processing conditions is parsed to obtain the processing state corresponding to the abnormal reconciliation file. Then, it is determined whether the processing state corresponding to the abnormal reconciliation file is the failure of the first step of the data processing operation, and the subsequent processing of the abnormal reconciliation file is completed according to the corresponding judgment result. The problem of insufficient granularity of monitoring the processing flow of the reconciliation file and the inability to continuously process the abnormal reconciliation file in the prior art is solved, and accurate monitoring of each processing flow of the reconciliation file and subsequent intelligent processing of the abnormal reconciliation file can be achieved, thereby improving the processing rate of the reconciliation file.

[0082] Figure 4a Schematic diagram of a preferred full-process processing device for reconciliation files provided by an embodiment of the present invention. Figure 4aAs shown, the preferred reconciliation file full-process processing device includes a file processing unit (i.e., a file processing module), a storage unit, an exception handling unit (i.e., an exception handling module), and a process monitoring unit (i.e., a process monitoring module). Among them, the file processing unit includes a file downloader (i.e., a file download unit), a file decryptor (i.e., a file decryption unit), a file decompressor (i.e., a file decompression unit), a merge sorter (i.e., a merge sorter unit), a data extractor (i.e., a data extraction unit), and a financial verifier (i.e., a financial verification unit), which are mainly used for initial reconciliation file download, decryption, decompression, sorting, extraction, and reconciliation operations; the storage unit includes a file storage device (i.e., a file storage module), a key storage device (i.e., a key storage module), and a state matrix (i.e., a state matrix module), wherein the file storage device is used to store the downloaded initial reconciliation file and the additional reconciliation files generated by each file processor, such as compressed reconciliation files, etc., the key storage device is used to store the key sequence number required for decrypting the initial reconciliation file, and the state matrix is ​​used to store the key sequence number required for decrypting the initial reconciliation file. The processing status of processors such as the storage file downloader and the file decryptor; the exception handling unit includes a state filter (i.e., a state filter unit) and a state parser (i.e., a state parsing unit), which are mainly used to process the abnormal reconciliation file separately, and the state code in the state matrix is ​​filtered by the state filter for processing, and the state parser is used to parse the abnormal reasons for the abnormal reconciliation file and the subsequent required processing steps, and the two are combined to realize the continuous processing of the abnormal reconciliation file; the process monitoring unit includes a message receiver (i.e., a message receiving unit) and a state converter (i.e., a state conversion unit), wherein the message receiver is used to receive the processing result of the file processing unit, and the state converter is used to convert the processing result of each processor in the file processing unit into a corresponding processing state, so as to realize the conversion of event results and states. Specifically, the file processing unit is connected to the storage unit and the process monitoring unit, the process monitoring unit is connected to the storage unit and the exception handling unit, and the storage unit and the exception handling unit are also connected.

[0083] Figure 4b This is a workflow diagram of a preferred full-process processing device for reconciliation files provided by an embodiment of the present invention. Figure 4bAs shown, the workflow of the preferred reconciliation file full-process processing device is specifically as follows: first, start the monitor to start monitoring the processing results of each file processor in the file processing unit; then, execute the initial reconciliation file download, and store the downloaded initial reconciliation file in the file storage; then obtain the decryption key from the key storage to decrypt the initial reconciliation file to obtain a compressed reconciliation file, decompress the compressed reconciliation file to obtain the reconciliation file, merge and sort the reconciliation files to obtain the source reconciliation file, and then extract the target reconciliation file at the reconciliation file receiving end, complete the reconciliation of the source reconciliation file with the target reconciliation file, and send the processing result of each file processor to the message receiver of the process monitoring unit; after receiving the processing result, the message receiver converts the processing result into a corresponding processing state, such as success, exception or failure, through the state converter, and stores the converted processing state in the state matrix; when the file processor fails to execute, the exception processing unit is triggered, the status code in the state matrix is ​​obtained, the processing status is parsed, the file storage is accessed to obtain the data processing result file and the subsequent data processing operation steps are executed to complete the abnormal reconciliation file continuation processing.

[0084] Figure 5 The present invention provides a schematic diagram of a full-process processing device for reconciliation files, which can execute the full-process processing method for reconciliation files involved in the above embodiments. The device can be implemented in software and / or hardware, such as Figure 5 As shown, the whole process processing device of the reconciliation file specifically includes: a file processing module 510, a file storage module 520, a process monitoring module 530, a state matrix module 540, and an exception handling module 550.

[0085] The file processing module 510 is used to perform data processing operations on the initial reconciliation file to obtain a data processing result file;

[0086] A file storage module 520, used to store the data processing result file;

[0087] The process monitoring module 530 is used to receive the processing result of the data processing operation and convert the format of the processing result to obtain the corresponding processing status;

[0088] A state matrix module 540, for storing the processing state in the form of a state code;

[0089] The exception processing module 550 is used to obtain the status code in the status matrix module if an abnormal reconciliation file appears during the data processing operation of the initial reconciliation file, process the status code to obtain the processing status corresponding to the abnormal reconciliation file; and match the subsequent data processing operation for the abnormal reconciliation file according to the processing status corresponding to the abnormal reconciliation file to complete the processing of the abnormal reconciliation file.

[0090] The technical solution of the embodiment of the present invention monitors the process of performing data processing operations on the initial reconciliation file and records the processing results corresponding to each step, then converts the processing results into corresponding processing states, and stores the processing states in the form of status codes in a state matrix module. When the abnormal reconciliation file is processed again, the processing state corresponding to the abnormal reconciliation file is obtained through the status code of the abnormal reconciliation file, and the subsequent data processing operations are matched for the abnormal reconciliation file according to the processing state corresponding to the abnormal reconciliation file, so as to complete the processing of the abnormal reconciliation file, thereby solving the problems of insufficient granularity of monitoring the processing flow of the reconciliation file and the inability to continuously process the abnormal reconciliation file in the prior art, and realizing accurate monitoring of each processing flow of the reconciliation file and realizing continuous intelligent processing of the abnormal reconciliation file, thereby improving the processing rate of the reconciliation file.

[0091] Optionally, the exception handling module 550 may specifically include a status code acquisition unit, a status screening unit, and a status parsing unit;

[0092] The status code acquisition unit is used to acquire the status code in the status matrix module if an abnormal reconciliation file appears during the data processing operation of the initial reconciliation file;

[0093] A status screening unit, used to screen out status codes that meet the exception handling conditions;

[0094] The status parsing unit is used to parse the status code that meets the exception processing conditions to obtain the processing status corresponding to the abnormal reconciliation file.

[0095] Optionally, the exception handling module 550 may specifically include a subsequent processing unit, which is used to execute all steps of the data processing operation if the processing status corresponding to the abnormal reconciliation file is the failure of the first step of the data processing operation; if the processing status corresponding to the abnormal reconciliation file is the failure of steps other than the first step of the data processing operation, obtain the data processing result file corresponding to the data processing operation step, and execute subsequent steps of data processing corresponding to the processing status.

[0096] Optionally, the file processing module 510 may specifically include a file download unit, a file decryption unit, a file decompression unit, a merging and sorting unit, a data extraction unit, and a financial verification unit;

[0097] The file downloading unit is used to download the corresponding initial reconciliation file from the file storage of the reconciliation file provider system;

[0098] A file decryption unit, used to decrypt the initial reconciliation file to obtain a compressed reconciliation file;

[0099] A file decompression unit, used to decompress the compressed reconciliation file to obtain a reconciliation file;

[0100] A merging and sorting unit, used for merging and sorting the reconciliation files to obtain a source reconciliation file;

[0101] A data extraction unit, used for acquiring a target reconciliation file from a reconciliation file receiving end;

[0102] The financial verification unit is used to compare the target reconciliation file with the source reconciliation file to complete the reconciliation operation.

[0103] Optionally, the process monitoring module 530 may specifically include a message receiving unit and a state conversion unit;

[0104] Wherein, the message receiving unit is used to receive the processing result of the data processing operation in real time;

[0105] The state conversion unit is used to convert the processing result of the data processing operation into a corresponding processing state according to the state conversion rule.

[0106] Optionally, the file decryption unit may be specifically configured to obtain a corresponding decryption key from the key storage module, and decrypt the initial reconciliation file to obtain a compressed reconciliation file.

[0107] Optionally, the status screening unit may be specifically configured to screen out status codes indicating that the processing status is not abnormal, and retain the status codes.

[0108] The full-process processing device for reconciliation files provided in the embodiment of the present invention can execute the full-process processing method for reconciliation files provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method.

[0109] Figure 6 A schematic diagram of the structure of a computer device provided by an embodiment of the present invention is shown in FIG. Figure 6 As shown, the computer device includes a processor 610, a memory 620, an input device 630, and an output device 640; the number of the processor 610 in the computer device can be one or more. Figure 6 A processor 610 is taken as an example; the processor 610, memory 620, input device 630 and output device 640 in the computer device can be connected via a bus or other means. Figure 6 The example of connecting through bus is taken in the following.

[0110] The memory 620, as a computer-readable storage medium, can be used to store software programs, computer executable programs and modules, such as program instructions / modules corresponding to the full-process processing method for reconciliation files in the embodiment of the present invention (for example, the file processing module 510, the file storage module 520, the process monitoring module 530, the state matrix module 540 and the exception handling module 550 in the full-process processing device for reconciliation files). The processor 610 executes various functional applications and data processing of the computer device by running the software programs, instructions and modules stored in the memory 620, that is, realizes the above-mentioned full-process processing method for reconciliation files.

[0111] The memory 620 may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system and at least one application required for a function; the data storage area may store data created according to the use of the terminal, etc. In addition, the memory 620 may include a high-speed random access memory, and may also include a non-volatile memory, such as at least one disk storage device, a flash memory device, or other non-volatile solid-state storage device. In some instances, the memory 620 may further include a memory remotely arranged relative to the processor 610, and these remote memories may be connected to the computer device via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0112] The input device 630 may be used to receive input digital or character information and generate key signal input related to user settings and function control of the computer device. The output device 640 may include a display device such as a display screen.

[0113] An embodiment of the present invention further provides a storage medium comprising computer executable instructions, wherein the computer executable instructions are used to execute a full-process processing method for reconciliation files when executed by a computer processor, the method comprising:

[0114] Performing data processing operations on the initial reconciliation file through a file processing module to obtain a data processing result file;

[0115] Storing the data processing result file through a file storage module;

[0116] The process monitoring module receives the processing result of the data processing operation, and converts the format of the processing result to obtain the corresponding processing status;

[0117] The processing state is stored in the form of a state code by a state matrix module;

[0118] If an abnormal reconciliation file appears during the data processing operation of the initial reconciliation file, the status code in the status matrix module is obtained, and the status code is processed by the exception processing module to obtain the processing status corresponding to the abnormal reconciliation file; and the subsequent data processing operation is matched for the abnormal reconciliation file according to the processing status corresponding to the abnormal reconciliation file, so as to complete the processing of the abnormal reconciliation file.

[0119] Of course, the storage medium containing computer executable instructions provided in an embodiment of the present invention is not limited to the method operations described above, and can also execute related operations in the full-process processing method of reconciliation files provided in any embodiment of the present invention.

[0120] Through the above description of the implementation methods, the technicians in the relevant field can clearly understand that the present invention can be implemented by means of software and necessary general hardware, and of course can also be implemented by hardware, but in many cases the former is a better implementation method. Based on such an understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, can be embodied in the form of a software product, and the computer software product can be stored in a computer-readable storage medium, such as a computer floppy disk, read-only memory (ROM), random access memory (RAM), flash memory (FLASH), hard disk or optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, server, or network device, etc.) to execute the methods described in each embodiment of the present invention.

[0121] It is worth noting that in the embodiment of the above-mentioned reconciliation file full-process processing device, the various units and modules included are only divided according to functional logic, but are not limited to the above-mentioned division, as long as the corresponding functions can be achieved; in addition, the specific names of the functional units are only for the convenience of distinguishing each other, and are not used to limit the scope of protection of the present invention.

[0122] Note that the above are only preferred embodiments of the present invention and the technical principles used. Those skilled in the art will understand that the present invention is not limited to the specific embodiments described herein, and that various obvious changes, readjustments and substitutions can be made by those skilled in the art without departing from the scope of protection of the present invention. Therefore, although the present invention has been described in more detail through the above embodiments, the present invention is not limited to the above embodiments, and may include more other equivalent embodiments without departing from the concept of the present invention, and the scope of the present invention is determined by the scope of the appended claims.

Claims

1. A method for processing the entire process of reconciliation files, characterized in that: The method is applied to a reconciliation file receiving end, and the method comprises: Perform data processing operations on the initial reconciliation file through the file processing module to obtain a data processing result file; Storing the data processing result file through a file storage module; The process monitoring module receives the processing result of the data processing operation, and converts the format of the processing result to obtain the corresponding processing status; The processing state is stored in the form of a state code by a state matrix module; If an abnormal reconciliation file appears during the data processing operation of the initial reconciliation file, the status code in the status matrix module is obtained, and the status code is processed by the abnormal processing module to obtain the processing status corresponding to the abnormal reconciliation file; and the subsequent data processing operation is matched for the abnormal reconciliation file according to the processing status corresponding to the abnormal reconciliation file, so as to complete the processing of the abnormal reconciliation file; Wherein, if an abnormal reconciliation file appears during the data processing operation of the initial reconciliation file, the status code in the status matrix module is obtained, and the status code is processed by the exception processing module to obtain the processing status corresponding to the abnormal reconciliation file, including: if an abnormal reconciliation file appears during the data processing operation of the initial reconciliation file, the status code in the status matrix module is obtained; the status code that meets the abnormal processing condition is screened out by the status screening unit in the exception processing module; the status code that meets the abnormal processing condition is parsed by the status parsing unit in the exception processing module to obtain the processing status corresponding to the abnormal reconciliation file; The matching of the abnormal reconciliation file with a subsequent data processing operation according to the processing status corresponding to the abnormal reconciliation file to complete the processing of the abnormal reconciliation file includes: if the processing status corresponding to the abnormal reconciliation file is that the first step of the data processing operation fails, executing all steps of the data processing operation; if the processing status corresponding to the abnormal reconciliation file is that steps other than the first step of the data processing operation fail, obtaining a data processing result file corresponding to the data processing operation step, and executing subsequent steps of the data processing corresponding to the processing status.

2. The method according to claim 1, characterized in that The data processing operation is performed on the initial reconciliation file by the file processing module to obtain a data processing result file including: Downloading the corresponding initial reconciliation file from the file storage of the reconciliation file provider system through the file downloading unit in the file processing module; Decrypting the initial reconciliation file by a file decryption unit in the file processing module to obtain a compressed reconciliation file; Decompressing the compressed reconciliation file by a file decompression unit in the file processing module to obtain a reconciliation file; The merging and sorting unit in the file processing module merges and sorts the reconciliation files to obtain a source reconciliation file; Acquire the target reconciliation file of the reconciliation file receiving end through the data extraction unit in the file processing module; The target reconciliation file is compared with the source reconciliation file by the financial reconciliation unit in the file processing module to complete the reconciliation operation.

3. The method according to claim 1, characterized in that The process monitoring module receives the processing result of the data processing operation and converts the format of the processing result to obtain the corresponding processing status, including: Receiving the processing result of the data processing operation in real time through the message receiving unit in the process monitoring module; The processing result of the data processing operation is converted into a corresponding processing state according to the state conversion rule by the state conversion unit in the process monitoring module.

4. The method according to claim 2, characterized in that: The decrypting the initial reconciliation file by the file decryption unit in the file processing module to obtain a compressed reconciliation file comprises: A corresponding decryption key is obtained from the key storage module, and the initial reconciliation file is decrypted by a file decryption unit in the file processing module using the decryption key to obtain a compressed reconciliation file.

5. The method according to claim 1, characterized in that The state code that meets the exception handling condition is screened out by the state screening unit in the exception handling module, including: The status code indicating that the processing status is not abnormal is screened out by the status screening unit in the exception processing module and is retained.

6. A full-process processing device for reconciliation files, characterized in that: The device is applied to a reconciliation file receiving end, and the device comprises: The file processing module is used to perform data processing operations on the initial reconciliation file to obtain a data processing result file; A file storage module, used to store the data processing result file; A process monitoring module is used to receive the processing result of the data processing operation and convert the format of the processing result to obtain the corresponding processing status; A state matrix module, used for storing the processing state in the form of a state code; The exception processing module is used to obtain the status code in the status matrix module if an abnormal reconciliation file appears during the data processing operation of the initial reconciliation file, process the status code to obtain the processing status corresponding to the abnormal reconciliation file; and match the subsequent data processing operation for the abnormal reconciliation file according to the processing status corresponding to the abnormal reconciliation file to complete the processing of the abnormal reconciliation file; The exception handling module specifically includes a status code acquisition unit, a status screening unit and a status parsing unit; the status code acquisition unit is used to acquire the status code in the status matrix module if an abnormal reconciliation file appears during the data processing operation of the initial reconciliation file; the status screening unit is used to screen out the status code that meets the exception handling conditions; the status parsing unit is used to parse the status code that meets the exception handling conditions to obtain the processing status corresponding to the abnormal reconciliation file; The exception handling module specifically includes a subsequent processing unit, which is used to execute all steps of the data processing operation if the processing status corresponding to the abnormal reconciliation file is the failure of the first step of the data processing operation; if the processing status corresponding to the abnormal reconciliation file is the failure of steps other than the first step of the data processing operation, obtain the data processing result file corresponding to the data processing operation step, and execute the subsequent steps of the data processing corresponding to the processing status.

7. A computer device, characterized in that: The computer device comprises: one or more processors; a storage device for storing one or more programs, When the one or more programs are executed by the one or more processors, the one or more processors implement the full-process processing method for reconciliation files as described in any one of claims 1-5.

8. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the full-process processing method for reconciliation files as described in any one of claims 1 to 5 is implemented.

Images