Design And Implementation Of Physical And Chemical Index Test Andanalysis System Based On Oracle EBS

In order to improve the efficiency and the level of modernization management oflaboratory work as well as realize the report data sharing, building a physicochemicalindex analysis information management system has an important significance. Thispaper detailly analyzes the physicochemical laboratory analysis business process,using Oracle EBS development tools, design and implemen the physicochemical indextest and analysis system.Firstly, detailed description of the physical and chemical indexes analysisprocesses is given, based on management workflow, analysis and management oftesting index definitions, classification and analysis report page definition, unknownsample analysis, the standard sample input data analysis, data entry, data review,analysis of data query, quality control and alarm business chart, abnormal data needsphysicochemical index test are discussed in detail. System’s operation environment aswell as the overall system function structure is discussed.Secondly, after a detailed description of the system requirements analysis, designthe system network structure of physicochemical index test, designed the functionalstructure of the system of physicochemical index test, designed the database logicalstructure analysis of key business system of material management, testing standards,testing and analysis report to management management science index of thelaboratory, the physical implementation of the database.Finally, the paper discusses the system development environment, discusses theconfiguration process of OC4J application server, realization of the system usingOracle Forms Builder programming, to achieve the main classes of the system ispresented, the system maintenance management, intelligent instruments, laboratoryanalysis data import, test management, statistical analysis of assay index analysis thecore functions of the system interface.Successful implementation of the system, realizing the laboratory all inspectionbusiness process management; implementation of the analytical instrument networkconnection and data acquisition; provides information query function rich, to makethe laboratory to the automatic operation, information management and paperlessoffice; to realize the automatically generated from the sample, sample code, resultsentry, login analysis of the whole process auditing data and samples retained, tracking and inspection reports; to realize the automatic judgment, sample approval,unqualified sample tracking, analysis of data WEB publishing process management;automatic generation of test reports, changes the traditional manual mode of operation,greatly improving the detection efficiency, reduces the operation of laboratory thecost of laboratory.