Abstract

Managing fixed assets in large global ERP systems is a crucial part of financial operations, yet the retirement of assets often remains a highly manual and time-consuming process. In Oracle E-Business Suite (R12), the standard out-of-the-box functionality for mass asset retirement becomes inefficient when assets do not share uniform selection criteria, forcing organizations to rely on extensive manual intervention. This paper presents a practical functional architecture developed for Oracle E-Business Suite (R12) that addresses this challenge through a custom API-driven “stamping” framework. The approach consolidates heterogeneous asset records into a single processing batch by repurposing unused application fields and integrating Oracle’s public APIs. The implementation significantly streamlined the retirement process for nearly 15,000 global assets, reducing the manual processing effort from approximately 95 hours to just 5 hours per quarter, resulting in a 95% improvement in operational efficiency while maintaining complete data integrity. Beyond its immediate operational impact, the study demonstrates how targeted API-based customization can enable scalable “last-mile” automation within legacy ERP environments, contributing to broader discussions in Financial Technology (FinTech) and enterprise process optimization.

References

• H. Klaus, M. Rosemann, and G. G. Gable, "What is ERP?," Information Systems Frontiers, vol. 2, no. 2, pp. 141-162, 2000.
• S. Rahim and H. Basuki, "Fixed Asset Audit and Depreciation Corrections: Discrepancies in Accounting Standards," Golden Ratio of Community Service and Devotion, vol. 4, no. 2, pp. 105-118, 2024.
• L. A. Odell et al., "Beyond Enterprise Resource Planning (ERP): The Next Generation Enterprise Resource Planning Environment," Defense Technical Information Center, 2012.
• C. S. Fultineer, "A Case Study and Literature Review: How Effective IT Governance Correlates with ERP Deployment Successes," University of North Carolina at Chapel Hill, 2015.
• M. Sheldon, "Tracking Tangible Asset Ownership and Provenance with Blockchain," SSRN Electronic Journal, 2020. https://doi.org/10.2139/ssrn.3669326
• "Optimizing Financial Processes through UML Activity to Sequence Diagram Transformation and EVA Integration," International Research Journal of Multidisciplinary Scope, vol. 7, no. 1, Jan. 2026.
• "SAP S/4HANA Finance on Cloud: AI-Powered Deployment and Extensibility," International Journal of Science, Engineering and Technology, 2025.
• J. Brands, "Implications of Emerging Technologies on the Accounting Profession," Digital Commons@ETSU, 2021.
• T. R. Eikebrokk and D. H. Olsen, "Robotic Process Automation and Consequences for Knowledge Workers; a Mixed-Method Study," Lecture Notes in Computer Science, vol. 12066, pp. 114-125, 2020. https://doi.org/10.1007/978-3-030-44999-5_10.
• H. Jo and D.-H. Park, "Mechanisms for successful management of enterprise resource planning from user information processing and system quality perspective," Scientific Reports, vol. 13, no. 1, 2023. https://doi.org/10.1038/s41598-023-39787-y