通信企业供应链管理订单库存子系统的设计与实现

通信企业供应链管理订单库存子系统的设计与实现北京理工大学工程硕士学位论文I摘要随着企业信息化发展及互联网络普及，传统企业正在积极运用云计算、互联网技术实现智慧企业管理。信息化建设将经历三个阶段发展。阶段一：物资资源、人力资源、财务资源等三方面企业资源管理信息化；阶段二：商业智能信息化发展。包括数据收集、搭建数据仓库、数据挖掘和报表展示，通过商业智能技术，将企业现有的数据知识转换为企业的核心竞争力；阶段三：外围系统精细化管理。随着企业发展，对企业精细化管理要求更高，对资产管理系统、采购管理系统、项目管理系统和客户关系管理等系统的需求也不断加强。国内某大型通信企业福建分公司拥有良好的企业信息化建设基础，已经形成了一套完整的物资管理、项目管理、财务管理、人力资源管理、采购管理的企业管理软件群。但目前各软件系统呈现出松耦合、数据关联度不高的局势。各软件系统之间的数据共享程度不高，甚至出现信息系统之间数据脱节现象，形成“信息孤岛”，为企业管理的时效性、全局性带来阻碍。本文以国内某大型通信企业福建分公司采购管理信息化建设为背景，借助SOA平台技术进行系统间接口开发，打通采购管理系统与库存管理系统、财务管理系统之间阻碍，实现业务管理、财务核算和企业管理等多方面融合。本文分析FJ公司订单库存的管理现状，界定在FJ公司内部订单管理子系统的边界，在此范围内规划订单库存系统的模块功能和系统设计与开发，并总结Oracle-EBS系统二次化开发常用方法及开发流程。文章最后对本文中的开发进行测试，验证了本系统对FJ公司的供应链订单、库存管理的有效性。关键词：企业信息化，供应链，信息孤岛，二次开发北京理工大学工程硕士学位论文IIAbstractEnterpriseinformatizationisbeingwidelyusedintheareaofcorporationmanagementandtheprogressofevaluatewiththespeedingdevelopmentofcomputer,networktechnologyandtherisinglevelofinformativesociety.CloudcomputingandInternettechnologyareactivelyappliedbytraditionalcorporations,andpushthemintointelligententerprise.Enterpriseinformatizationconstructionwillgothroughthefollowingthreestages:First,thematerialsresource,thehumanresourceandfinancialresourcearecontrolledbyERPsystem;Second,businessintelligentwillexperienceaperiodofprosperity,especiallyenterprise-classreportformsarewidelyapplied.Throughthedatacollection,datawarehousebuilding,dataminingandreportformstheexistingdataknowledgetransformationasthecorecompetitivenessofenterprises.Third,thedemandofdelicacymanagement.Asthedevelopmentofcorporation,firmhastheobligationtomanagethefixedassets,orders,inventory,contracts,fundandsoon.So,thedemandofperipheralsystems-suchaspurchasingmanagementsystem-areexpanded.Thelargedomestictele-communicationenterpriseFujianbranchhasshapedanexcellentfoundationofinformationconstruction.However,thecorporationcanonlygetmaximumbenefitfromthesystemssetofsoftwareiftheyimplementthesystemsvalidly.Hence,thestronginteractionofdataamongeverysystemswillsupportandacceleratetheconstructionprocessofintelligentcorporation.ThispapertakestheprocurementmanagementinformationsystemofalargedomesticcommunicationcorporationFujianBranchasthebackground.TheinterfacebetweencorporationmanagementsystemsaredevelopedbySOAtechonology.Withtheseinterfaces,alinkisestablishedamongprocurementmanagementsystem,inventorymanagementsystemandfinancialmanagementsystem.Finally,integrationofbusinessmanagement,financialaccountingandenterprisemanagementcanbenrealized.Fromatechnicalperspective,thecriticalpointofinterfacedesignishowtoanalysislogicalrelationshipofdatabetweentwosetsofsystemandensureefficiencyandeffectofinterfaceoperation.Fromoneside,namingconventionsofdata,fieldformat,userinterfaceandsoonneedtobeconsidered.Hence,inthispaper,theformandlogicofinputandoutputdataarecarefullyanalyzed.Intheotherside,theinterfaceisdevelopedbytoolof北京理工大学工程硕士学位论文IIIPL/SQLDeveloper,programlanguageofPL/SQL,thenitistestedbyserveralbusinessprocess.Allthesestepsareensuredtheinterfacesystemcanrunefficiencyandeffect.Throughtheoptimzationoforderandstockmanagementsub-system,internalmanagementisconsolidated.AndInthispaper,throughtheoptimizationofsupplychainmanagementsystem,internalcontrolrulesofcuring,andfinancialcontrolandrunsthroughthewholeprocessofbusinessactivities,soastoensuretheaccurate,data,andthroughthedataassociationbetweensystems,datacanbetracedbacktodobusiness,tomeettheexternalsupervisionandinternalcontrolrequirements.KeyWords:enterpriseinformationnization,supplychainmanagement,islandsofinformation,seconddevelopment北京理工大学工程硕士学位论文IV目录第1章绪论..............................................................................................11.1课题背景及研究目的................................................................................11.2国内外研究现状及发展趋势....................................................................21.3论文结构....................................................................................................4第2章相关背景及概念.........................................................................52.1Oracle-EBS二次开发简介..........................................................................52.2Oracle-EBS二次开发环境..........................................................................62.3Oracle-EBS二次开发常用方法..................................................................72.4Oracle-EBS二次开发流程..........................................................................8第3章订单库存管理现状分析与优化需求.........................................93.1FJ公司概况..................................................................................................93.2FJ公司订单库存管理现状........................................................................103.3FJ公司订单库存的管理瓶颈....................................................................133.3.1FJ公司订单库存子系统中“信息孤岛”现象................................133.3.2“信息孤岛”现象对FJ公司的影响...............................................153.4订单库存子系统优化需求......................................................................173.4.1订单库存子系统边界界定...............................................................173.4.2EBS-订单模块二