Design And Implementation Of Report Module Based On Oracle-erp System

In the context of the global economy, the domestic enterprises want to keep their competitiveness, it is bound to need more information and modernization of enterprises, so enterprises should own development need the introduction of oracle ERP system becomes follow, along with the development of Chinese enterprise constantly, expand, each enterprise should own demand is different, need to ERP system can be the development of the enterprise itself for custom development to meet customer business requirements, oracle-report module of ERP system are produced in this way, the oracle-ERP report module design and implementation of expounds the requirement analysis of the report module, report form module system architecture design, report forms module system design in detail, the report module implementation and testing. And application of oracle-report module of ERP system can greatly improve the efficiency of the relevant personnel, reduce the probability of error, and can prevent human modify report data and improve the accuracy of the report output, because of the particularity of requirements development report of group C, C group belongs to the state, but also has 32 branches,11 subsidiaries of large enterprises, involved including investment, real estate, insurance, insurance, urban construction, funds, securities and other aspects of the business, the business scope is very broad, so complex and diverse demand, its own business can be a very good reaction oracle ERP customization module advantage:report module has the following function point, report template definition, rapid code, etc.In demand research phase, after the company cooperation, first has carried on the demand research. Cinda, head of the headquarters of the company’s branch and key users and key users to Beijing to attend the meeting demand analysis, according to a warm communication, fully understand the customer to report module system functional requirements and performance requirements, through the analysis of demand, determine the business process of the report module, business needs, and scope of the report, etc. Analysis the demand of the group’s mother company, summed up the reporting system of overall demand. In system design and implementation phase, the development team to use foreground form, form builder tool drawing system, using PLSQL developer tools to create database objects, packages, writing system design report, and on the ERP system, which involved in the analysis database table and the relationship between tables, consider how to define a package, view, sequence, etc.; Write a user manual, VISIO are used to draw data flow diagram, write the system function design document and detailed design documents. In the testing phase, first write the test cases and test plan, system after the basic development, released to the test environment, and in the business running after repeated tests, the test problems directly fix the system, the test at the same time, for some of the original function optimization, through the follow-up after the development of the user in preparing and finishing initial data. After checked using dataload and webadi tools import formal environment, users start to use the system. Work to support phase, opened 400 hotline, users encountered problems in business operations can telephone contact operations staff, at any time by the operations staff to help user to repair data, guide operation; Technical problems in the system, operational and technical personnel repair system; And aiming at the problems in the system of on-line and users in the use of problems existing in the process of repeated training, has reached to allow customers faster understanding of the system, skilled application system.By the project team agree on understanding and consensus, demand for software architecture design, complete system design, test cases, installation deployment operations, and write the user manual, organization customer special training, and users have problems in the process of using the system, we systematically launched after optimization.