Abstract

As multinational organizations expand across jurisdictions, managing indirect taxes within Enterprise Resource Planning (ERP) systems has become increasingly complex. Many enterprises rely on specialized third-party tax engines to handle real-time tax calculations, regulatory updates, and multi-country compliance requirements. However, integrating these external engines with large ERP environments can create unintended system behavior, particularly when tax rules configured for one accounting process affect unrelated financial workflows. This paper presents an automation framework developed within Oracle E-Business Tax (EBTax) to address a critical integration issue involving the unintended application of third-party tax rates within the Accounts Payable (AP) process. The solution uses database-level event triggers and Oracle private APIs to automatically identify and exclude selected tax engines from specific payable transactions without disrupting broader tax operations. The implementation reduced manual configuration effort by approximately 95%, eliminated repetitive data-correction cycles, and improved the reliability of global Value-Added Tax (VAT) reporting and recovery processes. The study demonstrates how targeted ERP automation can strengthen tax governance while supporting scalable global compliance operations.

References

• O. Okunogbe and F. Santoro, "Increasing Tax Collection in African Countries: The Role of Information Technology," Journal of African Economies, vol. 32, no. Supplement_1, pp. i57–i83, 2023.
• T. Guerth, Business Model Driven ERP Customization. Vienna: ReposiTUm, TU Wien, 2014.
• S. R. Magal and J. Word, Integrated Business Processes with ERP Systems. New York, NY: Wiley, 2012.
• H. C. Lee, "Can Electronic Tax Invoicing Improve Tax Compliance? A Case Study of the Republic of Korea's Electronic Tax Invoicing for Value-Added Tax," World Bank, Washington, DC, Policy Research Working Paper 7592, 2016.
• J. Manyika et al., "A Future That Works: Automation, Employment, and Productivity," McKinsey Global Institute, Jan. 2017.
• G. J. Arnold, Corporate Financial Management. 5th ed. Harlow, UK: Pearson Education, 2013.
• B. S. S. S. S. Rao, Oracle E-Business Suite Financials Handbook. 3rd ed. New York, NY: McGraw-Hill Education, 2013.
• Oracle, "Oracle E-Business Tax User Guide, Release 12.2," Oracle Corporation, Part No. E48771-04, 2015.
• R. Kaplan and D. Norton, "The Balanced Scorecard: Measures That Drive Performance," Harvard Business Review, vol. 70, no. 1, pp. 71–79, 1992.
• M. Al Najjar, R. Mahboub, B. Nakhal, and M. G. Ghanem, "Exploring the Role of AI in Improving VAT Reporting Quality: Experimental Study in Emerging Markets," Journal of Risk and Financial Management, vol. 17, no. 11, p. 477, 2024.