MohanG's Oracle Blog

From EBS Forms to Oracle Redwood: The Evolution of Oracle ERP User Experience ORACLE REDWOOD • TECHNICAL DEEP DIVE From EBS Forms to Oracle Redwood: The Evolution of Oracle ERP User Experience From Oracle Forms and OAF to Fusion Cloud, Visual Builder and Redwood — explore how Oracle enterprise application experiences are evolving toward modern, role-based and intelligent user experiences. Explore the Journey ↓ Introduction For many years, Oracle ERP users interacted with enterprise applications through technologies such as Oracle Forms and Oracle Application Framework (OAF). These technologies provided powerful capabilities for implementing complex enterprise processes and business rules. But enterprise users have changed. Modern users expect applications to be intuitive, responsive, role-oriented and increasingly intelligent. The big question: Is Oracle Redwood simply a new user interface, or do...

Oracle EBS Meets Generative AI: Building an Intelligent Technical Support Assistant A practical architecture for combining Oracle E-Business Suite knowledge, Retrieval-Augmented Generation (RAG), Generative AI and Oracle APEX Oracle E-Business Suite & Emerging Technology Series This article explores how Generative AI can be combined with Oracle E-Business Suite technical knowledge to build an intelligent support assistant that helps consultants analyze errors, search technical documentation, identify likely causes and recommend diagnostic steps. What if your Oracle EBS support team had an AI technical assistant? Imagine an Oracle EBS consultant receiving a production error such as ORA-01427 , a concurrent request failure, an interface error or a custom PL/SQL exception. Instead of manually searching through documents, old emails, support tickets, SQL scripts and technical notes, the consultant could ask an AI assistant: Example Question: "Why is this ...

Oracle EBS Inventory: Understanding Material Transaction Costing and Interface Processing A practical guide to inventory transaction interfaces, transaction processing, costing and troubleshooting in Oracle E-Business Suite R12 Oracle E-Business Suite Technical Series This article explains the material transaction interface and costing process in Oracle E-Business Suite R12, with a practical focus on troubleshooting inventory transactions that are successfully interfaced but do not receive the expected cost. Table of Contents 1. Introduction 2. Understanding Oracle Inventory Transactions 3. Material Transaction Interface 4. Interface Processing Flow 5. Understanding Transaction Costing 6. Processing Transactions Using the API 7. Transaction Cost Details 8. A Practical Troubleshooting Scenario 9. Troubleshooting Approach 10. Performance Considerations 11. Troubleshooting Checklist 12. Lessons Learned 13. Conclusion 1. Introduction Oracle Inventory tran...

Migrating Oracle Discoverer Reports to R12 Blitz Reports – A Practical Approach A step-by-step approach to modernizing legacy Oracle E-Business Suite reporting using Blitz Report Oracle E-Business Suite Technical Series This article shares a practical approach for migrating Oracle Discoverer reports to Blitz Reports in Oracle E-Business Suite R12, including query analysis, parameter conversion, validation, and deployment considerations. Table of Contents 1. Introduction 2. Why Move Away from Discoverer? 3. What is Blitz Report? 4. Migration Approach 5. Step 1 – Assess the Discoverer Report 6. Step 2 – Extract and Review the SQL 7. Step 3 – Convert Parameters 8. Step 4 – Consider Oracle EBS Security 9. Step 5 – Create the Blitz Report 10. Step 6 – Validate the Results 11. Common Challenges 12. Discoverer vs Blitz Reports 13. Migration Checklist 14. Lessons Learned 15. Conclusion 1. Introduction Oracle E-Business Suite environments often contain years...

ORACLE R12 • OAF • PL/SQL Extract All OAF Personalizations Across Every Application in Oracle R12 A ready-to-run PL/SQL script that scans every installed application in your Oracle E-Business Suite R12 instance and reports only the customer-created OAF page personalizations — Oracle-seeded customizations are automatically filtered out. If you've ever tried to answer the question "what has actually been personalized on this instance?" , you already know the pain: Oracle Application Framework (OAF) personalizations are stored in MDS (Metadata Services), and by default a metadata dump mixes your team's custom personalizations together with Oracle's own seeded verticalization and translation layers . This script walks every installed application, lists every personalized document under its MDS path, and classifies each customizat...