Interoperability study for upgrading ERP applications

该项目将支持McCoy Drilling and完井-Farr公司（McCoy）与Alberta大学之间的持续研究合作，研究可扩展的互操作性技术，用于在关键业务转型中升级企业资源规划（ERP）应用程序，从独立的内部制造到开放的全球供应链生产。复杂的产品装配结构和配置以及动态制造过程必须以通用的方式建模，以便由现有ERP工具生成或开发的数据结构可以与现有ERP工具无缝集成或迁移到新的数据结构中，而这些数据结构又可以与新的ERP工具进行接口。研究的重点是现有和新的ERP系统之间的互操作性，以及不同供应商和合作伙伴在供应链模型中的协作方案。研究内容包括基于分布式制造管理需求的制造过程建模和ERP接口的再开发；动态供应链系统中资源规划与作业调度的通用计算方法中性数据模式的定义，为ERP的自动化数据迁移或集成提供了依据，最后，提出了一种新的ERP实施框架下的成本工程方法。相应的可交付成果是通用和可接受的制造外包和内部流程模型和程序，以标准化操作数据表和与新ERP系统集成的计算机化管理接口的形式；在考虑现有能力和资源的情况下，生成和修改主生产计划的工作计算机程序；更新或迁移基于现有ERP数据内容的数据文件，使其能够被新的ERP系统有效访问和使用；与新的ERP软件集成的一套有效的工作程序和计算机程序，以便可以定量地模拟和比较供应链背景下成本工程的不同场景。

This proposed project supports the continued research collaboration between McCoy Drilling and Completion -Farr (McCoy) and the University of Alberta to investigate the scalable interoperability technology for upgrading Enterprise Resources Planning (ERP) applications in a critical business transition, from self-dependent and in-house manufacturing to an open and global supply chain based production. Complex product assembly structures and configurations as well as the dynamic manufacturing processes have to be modeled in a generic manner so that the data structures generated by, or developed in the past with, the existing ERP tool can be seamlessly integrated with, or migrated into a new data structures which are in turn to be interfaced with a new ERP tool. The research focus is on the interoperability between the existing and a new ERP systems, as well as the collaboration scheme among different suppliers and partners in a supply chain model. The research activities include manufacturing process modeling and redevelopment of the ERP interfaces for the new scenarios with the distributed manufacturing management requirement; generic computational solution for the resources planning and job scheduling in a dynamic supply chain system; neutral data schema definition for the automated ERP data migration or integration, and finally, the development of a cost engineering method under the new framework of ERP implementation. The corresponding deliverables are the generic and acceptable manufacturing outsource and in-house process models and procedures in the form of standardized operation data forms and computerized management interfaces integrated with the new ERP system; a working computer program to generate and modify master production schedule with the consideration of available capabilities and resources; Updated or migrated data files based on the existing ERP data contents that can be accessed and used effectively by the new ERP system; A set of effective working procedures and a computer program that is integrated with the new ERP software such that different scenarios of cost engineering in the context of supply chains can be quantitatively simulated and ompared.