Solution-Led Integration Architecture in Oracle EBS: A Dual Case Study from Foundational Enterprise Engagements
Main Article Content
Abstract
In this article, you will learn about two of the most high-profile enterprise implementations to have produced a comprehensive catalogue of skills regarding Oracle EBS Integration Architecture (EBSIA). The first implementation involved a large telecommunications company in Asia and delivered a solution-led integrated design through the use of Oracle Application Integration Architecture (AIA) design tools and OAGIS Business Object Document (BOD). Governed by BODs, this design delivered the infrastructure necessary to enable the two existing systems to be integrated without any modification to either system's existing technical infrastructure, as well as the ability for existing users to access both systems independently. The author served as the solution lead on this project and was responsible for all aspects of the technical design, implementation of a proof-of-concept, and delivery of the solution (which achieved zero-touch order automation via the sales order process). The second project was with a global technology company and involved the technical configuration of the Oracle EBS financial applications to support their business operations. The key deliverables for this enterprise project included the AUTOLOCKBOX interface to receive payment data from banks, migrating the data from Accounts Payable to other financial modules, and creating custom reports that supported the Order to Cash process. Both enterprise projects reinforced the need for organizations to employ ERP expertise in two distinct areas: strategic architectural design implementations and technical execution of the architectural designs using an Oracle AIA and AIM hybrid method. The results achieved provided the author with valuable lessons for his future career opportunities and will assist organizations with managing their talent pool of ERP implementation professionals.
Article Details
Section
How to Cite
References
1. “Liquid Technologies - OAGIS Schema Documentation”, https://schemas.liquid-technologies.com/OAGIS/9.3/businessobjectdocumenttype.html.
2. Ben Prusinski and Gustavo Gonzalez, “Oracle E-Business Suite Financials Handbook”, Third Edition, McGraw-Hill, 2012, https://search.worldcat.org/zh-cn/title/1024268105.
3. Oracle Corporation. (2013). Oracle Fusion Applications Enterprise Deployment Guide for Financials, 11g Release 6 (11.1.6) (Part No. E27364-09). Oracle Help Center. https://docs.oracle.com/cd/E29597_01/fusionapps.1111/e27364/toc.htm.
4. RUFINO, R. (2004), “ERP Oracle Applications – Implementação segundo a metodologia AIM. Faculdade de Tecnologia de Americana,” https://ric-cps.eastus2.cloudapp.azure.com/handle/123456789/18624.
5. Thejas Prasad, 2024, “Automate the Reconciliation Process of Open Payables Invoices and Migration Extract During Data Conversion”, https://www.academia.edu/125439483/Automate_the_Reconciliation_Process_of_Open_Payables_Invoices_and_Migration_Extract_During_Data_Conversion.
6. Oracle Corporation. (2013). Oracle Fusion Applications Enterprise Deployment Guide for Financials, 11g Release 7 (11.1.7) (Part No. E27364-10). Oracle Help Center. https://docs.oracle.com/cd/E36909_01/fusionapps.1111/e27364/title_fn.htm.
7. Oracle Corporation. (2000). Oracle E-Business Suite Receivables User Guide, Release 11.5.9, https://docs.oracle.com/cd/A97501_03/acrobat/115arug.pdf.
8. Oracle Corporation. (2000). Oracle E-Business Suite Receivables User Guide, Release 11.5.9 (AutoLockbox Processing), https://docs.oracle.com/cd/A60725_05/pdf/ psarug.pdf.
9. Choudhury, S., & Das, M. (2020). AIM vs. AIA: A comparative study of Oracle implementation methodologies. Journal of Information Systems, 34(1), 15-32, https://doi.org/10.33093/jiwe.2025.4.1.3.
10. Oracle Corporation. (2014), “Oracle Payments User's Guide Release 12.2 Part No. E48766-02”, https://docs.oracle.com/cd/V46499_02/current/acrobat/122ibyug.pdf.