System and method for generating a report in real-time from a resource management system

Patent metadata

Field	Value
Publication number	US-9876699-B2
Application number	US-201514961476-A
Country	US
Kind code	B2
Filing date	Dec 7, 2015
Priority date	Oct 21, 2015
Publication date	Jan 23, 2018
Grant date	Jan 23, 2018

Abstract

A system and method for generating a report in real-time from a resource management system includes: receiving a plurality of parameters related to the report from a user; identifying required data from the resource management system based on the plurality of parameters; extracting refined data from the resource management system based on the identified required data using a data mining algorithm; and generating a report in real-time based on the extracted refined data.

First claim

What is claimed is:

1. A method for generating a report from a resource management system, the method comprising:
receiving, by a processor, a plurality of parameters relating to a report to be generated;
initiating, by the processor, a learning process to identify required data from a resource management system based on the plurality of parameters and intelligence data gathered from one or more performed activities executed during one or more accesses of the resource management system, wherein the resource management system relates to supply chain management (SCM) and planning;
extracting, by the processor, refined data from the resource management system based on the identified required data using a data mining algorithm; and
generating, by the processor, the report in real-time based on the extracted refined data, wherein the report comprises at least one of a bill of material report, a batch status report, a job status report, a job processing report, an inventory report, a demand plan, a supply plan, or a production plan.

2. The method of claim 1 , further comprising providing, by the processor, access to the resource management system based on provided authentication information.

3. The method of claim 1 , wherein the received plurality of parameters correspond to information sought to be included in the report and the method further comprises building, by the processor, one or more queries based on the received plurality of parameters.

4. The method of claim 1 , wherein the extracting the refined data further comprises retrieving, by the processor, data available in a plurality of log tables pertaining to one or more processes from the resource management system.

5. The method of claim 1 , wherein the generating the report further comprises analyzing the extracted refined data to derive at least one of a forecast, a plan, or a strategy.

6. The method of claim 1 , further comprising storing, by the processor, the generated report for subsequent access.

7. A report management computing device comprising:
at least one processor;
a memory coupled to the processor and configured to be capable of executing programmed instructions comprising and stored in the memory to:
receive a plurality of parameters relating to a report to be generated;
initiate a learning process to identify required data from a resource management system based on the plurality of parameters and intelligence data gathered from one or more performed activities executed during one or more accesses of the resource management system, wherein the resource management system relates to supply chain management (SCM) and planning;
extract refined data from the resource management system based on the identified required data using a data mining algorithm; and
generate the report in real-time based on the extracted refined data, wherein the report comprises at least one of a bill of material report, a batch status report, a job status report, a job processing report, an inventory report, a demand plan, a supply plan, or a production plan.

8. The device of claim 7 , wherein the processor is further configured to be capable of executing one or more programmed instructions stored in the memory to provide access to the resource management system based on provided authentication information.

9. The device of claim 7 , wherein the received plurality of parameters correspond to information sought to be included in the report and the processor is further configured to be capable of executing programmed one or more instructions stored in the memory to build one or more queries based on the received plurality of parameters.

10. The device of claim 7 , wherein the processor is further configured to be capable of executing programmed one or more instructions stored in the memory to extract the refined data that further comprises an instruction to retrieve data available in a plurality of log tables pertaining to one or more processes from the resource management system.

11. The device of claim 7 , wherein the processor is further configured to be capable of executing programmed one or more instructions stored in the memory to generate the report that further comprises an instruction to analyze the extracted refined data to derive at least one of a forecast, a plan, or a strategy.

12. The device of claim 7 , wherein the processor is further configured to be capable of executing programmed one or more instructions stored in the memory to identify the required data that further comprises an instruction to store the generated report for subsequent access.

13. A non-transitory machine readable medium having stored thereon instructions for generating a report from a resource management system, the stored instructions comprise machine executable code, which when executed by at least one processor, causes the processor to:
receive a plurality of parameters relating to a report to be generated;
initiate a learning process to identify required data from a resource management system based on the plurality of parameters and intelligence data gathered from one or more performed activities executed during one or more accesses of the resource management system, wherein the resource management system relates to supply chain management (SCM) and planning;
extract refined data from the resource management system based on the identified required data using a data mining algorithm; and
generate the report in real-time based on the extracted refined data, wherein the report comprises at least one of a bill of material report, a batch status report, a job status report, a job processing report, an inventory report, a demand plan, a supply plan, or a production plan.

14. The non-transitory machine readable medium of claim 13 , wherein the machine executable code, when executed by the at least one processor, further causes the processor to provide access to the resource management system based on provided authentication information.

15. The non-transitory machine readable medium of claim 13 , wherein the received plurality of parameters correspond to information sought to be included in the report and the machine executable code, when executed by the at least one processor, further causes the processor to build one or more queries based on the received plurality of parameters.

16. The non-transitory machine readable medium of claim 13 , wherein the machine executable code, when executed by the at least one processor, further causes the processor to extract the refined data that further comprises an instruction to retrieve data available in a plurality of log tables pertaining to one or more processes from the resource management system.

17. The non-transitory machine readable medium of claim 13 , wherein the machine executable code, when executed by the at least one processor, further causes the processor to generate the report that further comprises an instruction to analyze the extracted refined data to derive at least one of a forecast, a plan, or a strategy.

18. The non-transitory machine readable medium of claim 13 , wherein the machine executable code, when executed by the at least one processor, further causes the processor to identify the required data that further comprises an instruction to store the generated report for subsequent access.

Assignees

• Wipro Ltd

Inventors

• Rao Arjun Kumar
• Kumar Karthik
• Dhakshinamoorthy Nagadhilipan

Classifications

• G06Q10/0631 Primary

  Resource planning, allocation, distributing or scheduling for enterprises or organisations · CPC title

• H04L63/083

  using passwords (cryptographic mechanisms or cryptographic arrangements for entity authentication using a predetermined code H04L9/3226) · CPC title

• G06Q10/087

  Inventory or stock management, e.g. order filling, procurement or balancing against orders · CPC title

• H04L41/5032

  Generating service level reports · CPC title

• H04L43/10 Primary

  Active monitoring, e.g. heartbeat, ping or trace-route · CPC title