Electric power marketing inspection work order intelligent management method based on robot process automation
RPA-based intelligent management of power marketing audit work orders addresses inefficiencies and errors by automating processes, enhancing management quality and customer satisfaction while reducing costs.
Patent Information
- Application Number
- CN202411042544.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-07-31
- Publication Date
- 2024-12-27
AI Technical Summary
The existing power marketing audit process consumes significant manpower, financial, and material resources, is prone to errors, and lacks effective management, leading to economic losses and inefficiencies.
An intelligent management method for power marketing audit work orders using Robotic Process Automation (RPA) to automate work order generation, distribution, reminders, review, and archiving, improving efficiency and accuracy.
Enhances management quality and efficiency, reduces costs, and prevents errors and omissions, promoting digitalization and intelligence in power marketing audit processes.
Smart Images

Figure CN119204973A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of business management of power systems, and in particular to an intelligent management method for audit work orders based on robotic process automation applied to power marketing. Background Art
[0002] At present, with the accelerated construction of my country's national power grid, against the background of the construction of a new power system, with the increase in market players, changes in trading rules and the liberalization of user choices, these measures have brought huge challenges to the business development, marketing model, management system, etc. of the national power grid, and the requirements for the service level of marketing business are getting higher and higher, and the work pressure faced by marketing business work is also increasing.
[0003] The power marketing systems of my country's State Grid are diverse, including: "new installation, capacity increase and change of electricity consumption", "meter reading management", "accounting management", "electricity fee collection and account management", "line loss management", "asset management", "metering point management", "metering system management", "electricity information collection", "power supply and use contract management", "power consumption inspection management", "95598 business processing", "customer relationship management", "customer contact", "market management", "energy efficiency management", "orderly electricity consumption management", "audit and work quality" and "customer file information management", etc. There are as many as 19 thematic businesses, and there are also many complex branch businesses under them.
[0004] In the process of marketing audit, a large number of work orders with different themes will be generated. The management of these work orders not only consumes a lot of manpower, financial and material resources, but also consumes a lot of energy of grassroots teams. In addition, the existing management methods are prone to errors and omissions in the management process, causing economic losses to the country.
[0005] Although the "Two-Year Action Plan for Deepening the Construction of Marketing Audit and Quality Supervision System of State Grid Corporation of China (2020-2021)" proposed to strengthen the construction of digital audit and improve the level of intelligent audit; "Guiding Opinions of State Grid Corporation of China on the Construction of Digital Internal Control System for Marketing Business Risks" (State Grid Marketing
[2021] No. 266) also requires the standardized management of marketing business, digital management and quality evaluation, and the establishment of a digital internal control mechanism for marketing business risks; in addition, the "Marketing Audit, Monitoring and Operation Management Measures of State Grid Corporation of China" also proposed to rely on marketing audit-related platforms to carry out multi-dimensional and cross-platform data fusion analysis to identify and judge marketing business risks.
[0006] However, in the face of the above-mentioned defects, there is no effective solution in the existing technology. Therefore, in this context, power companies urgently need a new intelligent management method based on the promotion and application of Robotic Process Automation (RPA) technology for digital transformation, which can be of great significance to the management and competitiveness of power companies, reduce costs and effectively avoid errors and omissions. Summary of the invention
[0007] In order to solve the problem that a large number of work orders in the power marketing audit process under the existing technology consumes a lot of manpower, financial and material resources, consumes a lot of energy of grassroots teams, and is prone to errors and omissions, the present invention automates and intelligently improves the power marketing audit work order management process, and provides an intelligent management method for power marketing audit work orders based on robotic process automation. The RPA technology is used to achieve efficient generation of work orders, automatic distribution and reminders, automatic review and archiving, improve the efficiency and accuracy of work order management, effectively improve the management quality and efficiency of marketing audit work orders, and promote the transformation of marketing audit work to digitalization and intelligence, thereby improving the overall quality and customer satisfaction of power marketing audit work and strengthening the risk management and control capabilities of power marketing.
[0008] The intelligent management method of power marketing audit work orders based on robotic process automation of the present invention is specifically described as follows:
[0009] 1. The intelligent management method of power marketing audit work orders based on robotic process automation is as follows:
[0010] Including the order of settings:
[0011] 1) Log in to the marketing system module: open the digital audit system webpage through this module, enter the login password and log in;
[0012] 2) Work order generation module: according to different audit topics, form the work order template of the topic, and then according to the system audit rules, capture the relevant topic data and generate the audit work order;
[0013] 3) Order dispatching module: dispatching audit work orders according to audit subject and processing personnel. After the work order is dispatched successfully, it will enter the audit work order processing stage;
[0014] 4) Order reminder module: sort the work orders according to the remaining processing time of the work orders, verify the information about the expected processing time of the sorted audit work orders, and send reminder information.
[0015] 5) Audit module: Determine the abnormal rectification of users through the output results of the mapping relationship, and give the corresponding rollback situation and rollback reasons for different approval results;
[0016] 6) Archive module: archive the topic;
[0017] Through the above six modules, work orders are generated and automatically dispatched. The automatic reminder module automatically reminds the dispatched work orders, and finally automatically reviews and archives them.
[0018] According to the intelligent management method of power marketing audit work orders based on robotic process automation of the present invention, it is characterized in that the login to the marketing system module in the step 1) is specifically to automatically enter a preset user name and password on the login page, and the user name and password are saved in an encrypted database in reverse order and in a dislocated garbled form. Through the automatic clicking, automatic input, and automatic identification function commands of the robotic process automation platform, it is possible to automatically open the digital audit system webpage, automatically click the login button after entering the login password, and form an automatic login.
[0019] According to the intelligent management method of power marketing audit work orders based on robotic process automation of the present invention, it is characterized in that the work order generation module of the step 2) specifically enters the pending task module and refreshes the latest work order list after logging into the marketing system module in step 1), and then batch matches the field information of work orders with different audit subjects to form a work order template for the subject, and finally captures the relevant subject data according to the system audit rules to generate an audit work order.
[0020] According to the intelligent management method of power marketing audit work orders based on robotic process automation of the present invention, it is characterized in that the "batch matching of field information of different audit subject work orders" in the work order generation module of step 2) is field information that specifically includes basic information of unit number and user number and special information of each subject field.
[0021] According to the intelligent management method of power marketing audit work orders based on robotic process automation of the present invention, it is characterized in that the dispatching module of step 3) is specifically the audit work order generated by the work order generation module of step 2), and the dispatching information is completed according to the processing recipient set according to the subject and the default configuration. The dispatching information includes dispatching opinions and required feedback time. Finally, the audit work order is dispatched according to the audit subject and processing personnel. After the work order is successfully dispatched, it enters the audit work order processing link.
[0022] This step greatly reduces the workload of audit specialists and reduces costs.
[0023] According to the intelligent management method of power marketing audit work orders based on robotic process automation of the present invention, it is characterized in that the order urging module of step 4) is specifically that the work order that enters the audit work order processing link after being dispatched in step 3) first refreshes and queries the processed work orders, checks the business status, and sorts the work orders according to the remaining processing time of the work orders, and verifies the information about the expected processing time of the sorted audit work orders in turn. At the same time, this step will send a prompt message to the processing personnel corresponding to the audit work order according to the information verification result.
[0024] According to the intelligent management method of power marketing audit work orders based on robotic process automation of the present invention, it is characterized in that the reminder module of step 4) sends prompt information to the processing personnel corresponding to the audit work order, which is specifically as follows:
[0025] 1) Collect the current time t1, and calculate the remaining processing time T = t2-t1 according to the expected processing time t2 of the work order;
[0026] 2) Determine the remaining processing time of the work order. If 0h<T<24h, send a reminder message of the upcoming overdue time to the person in charge by phone, and record the target work order that is about to be overdue in the statistics table of the work orders that are about to be overdue;
[0027] 3) If the remaining processing time of the work order is determined to be T≤0, a reminder message of the overdue time is sent to the person in charge by phone, and the overdue target work order is recorded in the statistics table of the work orders that are about to be overdue.
[0028] According to the intelligent management method of power marketing audit work orders based on robotic process automation of the present invention, it is characterized in that the audit module of step 5) specifically identifies the subject information field of the work order after the work order is dispatched by the dispatching module of step 3) and the rectified work order is fed back, stores it in temporary data, and establishes an information mapping relationship with the standard information field of the subject audit logic rule, judges the user's abnormal rectification situation through the output result of the mapping relationship, and gives corresponding rollback situation and rollback reason for different approval results.
[0029] According to the intelligent management method of power marketing audit work orders based on robotic process automation of the present invention, it is characterized in that in the audit module of step 5), "the abnormal rectification of the user is judged by the output result of the mapping relationship, and the corresponding rollback situation and rollback reason are given for different approval results", which is specifically as follows:
[0030] 1) Set n subject field sets {s1, s2, ...sn} in the receipt and the subject standard field set {k1, k2 ...kn} in the digital audit system;
[0031] 2) Establish a two-dimensional mapping table. If the subject field s of the receipt is consistent with the content of the subject standard field k in the audit system, the mapping relationship (sn, kn) = 1, otherwise (sn, kn) = 0;
[0032] 3) Determine whether the subject field information of the receipt is correct based on the mapping relationship. If the mapping relationships (sn, kn) are both 1, it is determined that the user has rectified the abnormal situation and the receipt has passed the review; if any mapping relationship (sn, kn) = 0, it is determined that the user has not completed the rectification of the abnormal situation and the review has failed;
[0033] 4) If the review fails, return to the audit work order dispatching module in step 3), and after processing again, the order will be dispatched to the audit work order processing link.
[0034] According to the intelligent management method of power marketing audit work orders based on robotic process automation of the present invention, it is characterized in that the archiving module of step 6) is specifically to automatically archive the work orders that have been reviewed and approved by the review module of step 5) according to different topics.
[0035] The overall idea of the intelligent management method of power marketing audit work orders based on robotic process automation of the present invention is:
[0036] First, after authorizing the process automation robot, enter the account information of the audit business personnel and automatically log in to the digital audit system, enter the pending task module, refresh the work order list, capture relevant data, and automatically generate audit work orders with different themes. Automatically dispatch orders according to the processing recipient set by the work order theme and the dispatch information completed by the default configuration. Regularly check the business status of work orders that have been issued and not returned, and automatically urge work orders that have expired or are about to expire. Based on the audit logic, automatically review work orders with different themes, judge abnormal rectification situations, and return work orders that fail the review to the audit work order processing link, and record the reason for the return. Work orders that pass the review are automatically archived. Overall, improve the management quality and efficiency of marketing audit work orders.
[0037] The intelligent management method for power marketing audit work orders based on robotic process automation of the present invention has the following beneficial effects:
[0038] 1. The intelligent management method of power marketing audit work orders based on robotic process automation of the present invention can effectively improve the efficiency and accuracy of work order management, improve the management quality and efficiency of marketing audit work orders, and promote the transformation of marketing audit work to digitalization and intelligence, thereby improving the overall quality and customer satisfaction of power marketing audit work and strengthening the risk management and control capabilities of power marketing;
[0039] 2. The intelligent management method of power marketing audit work orders based on robotic process automation of the present invention can effectively reduce costs and effectively avoid errors and omissions. BRIEF DESCRIPTION OF THE DRAWINGS
[0040] Figure 1 It is a structural sequence diagram of the intelligent management method of power marketing audit work orders based on robotic process automation of the present invention;
[0041] Figure 2 It is a detailed flow chart of the intelligent management method of power marketing audit work orders based on robotic process automation of the present invention. DETAILED DESCRIPTION
[0042] The following is a further description of the technical means, creative features, objectives and effects achieved by the intelligent management method of power marketing audit work orders based on robotic process automation of the present invention in combination with the accompanying drawings and embodiments.
[0043] Example
[0044] like Figure 1-2 As shown, the intelligent management method of power marketing audit work orders based on robotic process automation of the present invention is specifically implemented as follows:
[0045] The intelligent management method of power marketing audit work orders based on robotic process automation includes the following sequence settings:
[0046] 1) Log in to the marketing system module: open the digital audit system webpage through this module, enter the login password and log in;
[0047] 2) Work order generation module: according to different audit topics, form the work order template of the topic, and then according to the system audit rules, capture the relevant topic data and generate the audit work order;
[0048] 3) Order dispatching module: dispatching audit work orders according to audit subject and processing personnel. After the work order is dispatched successfully, it will enter the audit work order processing stage;
[0049] 4) Order reminder module: sort the work orders according to the remaining processing time of the work orders, verify the information about the expected processing time of the sorted audit work orders, and send reminder information.
[0050] 5) Audit module: Determine the abnormal rectification of users through the output results of the mapping relationship, and give the corresponding rollback situation and rollback reasons for different approval results;
[0051] 6) Archive module: archive the topic;
[0052] Through the above six modules, work orders are generated and automatically dispatched. The automatic reminder module automatically reminds the dispatched work orders, and finally automatically reviews and archives them.
[0053] The login marketing system module of step 1) specifically includes automatically inputting a preset user name and password on the login page. The user name and password are saved in an encrypted database in reverse order and in a dislocated garbled form. Through the automatic clicking, automatic input, and automatic identification function commands of the robotic process automation platform, the digital audit system webpage is automatically opened, and the login button is automatically clicked after the login password is entered, thereby forming an automatic login.
[0054] The work order generation module of step 2) specifically includes: after logging into the marketing system module of step 1), entering the pending tasks module and refreshing the latest work order list, then batch matching the field information of work orders of different audit subjects to form a work order template for the subject, and finally, according to the system audit rules, capturing relevant subject data to generate an audit work order.
[0055] In step 2), in the work order generation module, the field information of "batch matching of different audit subject work orders" is specifically the basic information including the unit number, user number and the special information of each subject field.
[0056] The dispatching module of step 3) is specifically the audit work order generated by the work order generation module of step 2), the dispatching information completed according to the processing recipient set by the subject and the default configuration, the dispatching information includes the dispatching opinion and the required feedback time, and finally the audit work order is dispatched according to the audit subject and the processing personnel. After the work order is successfully dispatched, it enters the audit work order processing link.
[0057] The order reminder module of step 4) specifically includes: for the work orders that enter the audit work order processing link after being dispatched in step 3), firstly refresh and query the processed work orders, check the business status, and sort the work orders according to the remaining processing time of the work orders, and then verify the information about the expected processing time of the sorted audit work orders in turn. At the same time, this step will send a prompt message to the processing personnel corresponding to the audit work order according to the information verification result.
[0058] The reminder module in step 4) sends a reminder message to the processing personnel corresponding to the audit work order, which is as follows:
[0059] 1) Collect the current time t1, and calculate the remaining processing time T = t2-t1 according to the expected processing time t2 of the work order;
[0060] 2) Determine the remaining processing time of the work order. If 0h<T<24h, send a reminder message of the upcoming overdue time to the person in charge by phone, and record the target work order that is about to be overdue in the statistics table of the work orders that are about to be overdue;
[0061] 3) If the remaining processing time of the work order is determined to be T≤0, a reminder message of the overdue time is sent to the person in charge by phone, and the overdue target work order is recorded in the statistics table of the work orders that are about to be overdue.
[0062] The audit module of step 5) specifically identifies the subject information field of the work order that has been dispatched and rectified by the dispatch module of step 3), stores it in temporary data, and establishes an information mapping relationship with the standard information field of the subject audit logic rule. The output result of the mapping relationship is used to judge the user's abnormal rectification situation, and corresponding rollback situation and rollback reason are given for different approval results.
[0063] In the review module of step 5), "the output result of the mapping relationship is used to determine the abnormal rectification of the user, and the corresponding rollback situation and rollback reason are given for different approval results", which is as follows:
[0064] 1) Set n subject field sets {s1, s2, ...sn} in the receipt and the subject standard field set {k1, k2 ...kn} in the digital audit system;
[0065] 2) Establish a two-dimensional mapping table. If the subject field s of the receipt is consistent with the content of the subject standard field k in the audit system, the mapping relationship (sn, kn) = 1, otherwise (sn, kn) = 0;
[0066] 3) Determine whether the subject field information of the receipt is correct based on the mapping relationship. If the mapping relationships (sn, kn) are both 1, it is determined that the user has rectified the abnormal situation and the receipt has passed the review; if any mapping relationship (sn, kn) = 0, it is determined that the user has not completed the rectification of the abnormal situation and the review has failed;
[0067] 4) If the review fails, return to the audit work order dispatching module in step 3), and after processing again, the order will be dispatched to the audit work order processing link.
[0068] The archiving module of step 6) specifically automatically archives the work orders approved by the review module of step 5) according to different topics.
[0069] The intelligent management method of power marketing audit work orders based on robotic process automation of the present invention can effectively improve the efficiency and accuracy of work order management, enhance the management quality and efficiency of marketing audit work orders, and promote the transformation of marketing audit work towards digitalization and intelligence, thereby improving the overall quality of power marketing audit work and customer satisfaction, and strengthening power marketing risk management and control capabilities; and the intelligent management method of power marketing audit work orders based on robotic process automation of the present invention can effectively reduce costs and effectively avoid errors and omissions.
[0070] Those skilled in the art should recognize that the above embodiments are only used to illustrate the present application, and are not intended to limit the present application. As long as they are within the spirit of the present application, any changes or modifications to the above embodiments will fall within the scope of the claims of the present application.
Claims
1. The intelligent management method of power marketing audit work orders based on robotic process automation is as follows: Including the order of settings: 1) Log in to the marketing system module: open the digital audit system webpage through this module, enter the login password and log in; 2) Work order generation module: according to different audit topics, form the work order template of the topic, and then according to the system audit rules, capture the relevant topic data and generate the audit work order; 3) Order dispatching module: dispatching audit work orders according to audit subject and processing personnel. After the work order is dispatched successfully, it will enter the audit work order processing stage; 4) Order reminder module: sort the work orders according to the remaining processing time of the work orders, verify the information about the expected processing time of the sorted audit work orders, and send reminder information. 5) Audit module: Determine the abnormal rectification of users through the output results of the mapping relationship, and give the corresponding rollback situation and rollback reasons for different approval results; 6) Archive module: archive the topic; Through the above six modules, work orders are generated and automatically dispatched. The automatic reminder module automatically reminds the dispatched work orders, and finally automatically reviews and archives them.
2. The intelligent management method for power marketing audit work orders based on robotic process automation according to claim 1, characterized in that: The login marketing system module of the step 1) is specifically to automatically enter a preset username and password on the login page. The username and password are saved in an encrypted database in reverse order and in a dislocated garbled form. Through the automatic clicking, automatic input, and automatic recognition function commands of the robotic process automation platform, the digital audit system webpage is automatically opened, and the login button is automatically clicked after the login password is entered, thereby forming an automatic login.
3. The intelligent management method for power marketing audit work orders based on robotic process automation according to claim 1, characterized in that: The work order generation module of step 2) is specifically, after logging into the marketing system module in step 1), entering the pending task module and refreshing the latest work order list, then batch matching the field information of work orders of different audit subjects to form a work order template for the subject, and finally, according to the system audit rules, capturing relevant subject data to generate an audit work order.
4. The intelligent management method for power marketing audit work orders based on robotic process automation according to claim 3, characterized in that: The "batch matching of field information of different audit subject work orders" in the work order generation module of step 2) is specifically the basic information including unit number, user number and special information of each subject field.
5. The intelligent management method for power marketing audit work orders based on robotic process automation according to claim 1, characterized in that: The dispatching module of step 3) is specifically the inspection work order generated by the work order generation module of step 2), the dispatching information completed according to the processing recipient set by the subject and the default configuration, the dispatching information includes the dispatching opinion and the required feedback time, and finally the inspection work order is dispatched according to the inspection subject and the processing personnel. After the work order is successfully dispatched, it enters the inspection work order processing link.
6. The intelligent management method for power marketing audit work orders based on robotic process automation according to claim 1, characterized in that: The order urging module of the step 4) is specifically that, after the work order is dispatched in step 3) and enters the audit work order processing link, it first refreshes and queries the processed work orders, checks the business status, and sorts the work orders according to the remaining processing time of the work orders, and verifies the information about the expected processing time of the sorted audit work orders in turn. At the same time, this step will send a prompt message to the processing personnel corresponding to the audit work order according to the information verification result.
7. The intelligent management method for power marketing audit work orders based on robotic process automation according to claim 6, characterized in that: The reminder module of step 4) sends a prompt message to the processing personnel corresponding to the audit work order, which is as follows: 7.1) Collect the current time t1, and calculate the remaining processing time T = t2-t1 according to the expected processing time t2 of the work order; 7.2) Determine the remaining processing time of the work order. If 0h<T<24h, send a reminder message of the upcoming overdue time to the person in charge by phone, and record the target work order that is about to be overdue in the statistics table of the work orders that are about to be overdue; 7.3) If the remaining processing time of the work order is determined to be T≤0, a reminder message of the overdue time is sent to the person in charge by phone, and the overdue target work order is recorded in the statistics table of work orders that are about to be overdue.
8. The intelligent management method for power marketing audit work orders based on robotic process automation according to claim 1, characterized in that: The audit module of step 5) is specifically for identifying the subject information field of the work order that has been dispatched and fed back as rectified by the dispatch module of step 3), storing it in temporary data, and establishing an information mapping relationship with the standard information field of the subject audit logic rule, judging the user's abnormal rectification situation through the output result of the mapping relationship, and giving corresponding rollback situations and rollback reasons for different approval results.
9. The intelligent management method for power marketing audit work orders based on robotic process automation according to claim 8, characterized in that: In the review module of step 5), "the user's abnormal rectification situation is judged by the output result of the mapping relationship, and the corresponding rollback situation and rollback reason are given for different approval results", which is specifically as follows: 9.1) Set n subject field sets {s1, s2, ...sn} in the receipt and the subject standard field set {k1, k2 ...kn} in the digital audit system; 9.2) Establish a two-dimensional mapping table. If the subject field s of the receipt is consistent with the content of the subject standard field k in the audit system, the mapping relationship (sn, kn) = 1, otherwise (sn, kn) = 0; 9.3) Determine whether the subject field information of the receipt is correct based on the mapping relationship. If the mapping relationships (sn, kn) are both 1, it is determined that the user has rectified the abnormal situation and the receipt has passed the review; if any mapping relationship (sn, kn) = 0, it is determined that the user has not completed the rectification of the abnormal situation and the review has failed; 9.4) If the review fails, return to the audit work order dispatching module in step 3), and after processing again, the order will be dispatched to the audit work order processing link.
10. The intelligent management method for power marketing audit work orders based on robotic process automation according to claim 1, characterized in that: The archiving module of step 6) is specifically to automatically archive the work orders approved by the review module of step 5) according to different topics.
Citation Information
Cited By
Online inspection automatic RPA system
CN114399192A
Intelligent reply method for electric power marketing inspection work order
CN121434256A
