Oracle APEX

Introduction:                 This blog explains a simple and practical approach to integrating the Cashfree payment gateway into an Oracle APEX 24.2 application. The implementation uses Cashfree’s JavaScript SDK and Oracle APEX AJAX callbacks to securely create payment orders, redirect users to the Cashfree checkout page, and return them back to the application after payment completion. This approach is suitable for handling UPI and card payments in a clean and page-level implementation.   Step 1: Create Cashfree account and API keys Create a Cashfree account and generate the Client ID and Client Secret from the dashboard. Use sandbox credentials for development and testing. Step 2: Create payment page in Oracle APEX In Oracle APEX 24.2, create a payment page. Add a number item P13_AMOUNT for entering the payment amount and hidden items P13_ORDER_ID and P13_CF_ORDER_ID to store order details. Step 3: Include Cashfree JavaScript SDK In the pa...

Tweaking the Toolbar for Better Control and Usability Introduction: Oracle APEX Interactive Grid provides a rich, feature-packed interface for working with tabular data. While the default toolbar offers many capabilities, not all of them are required in every application. In real-world projects, simplifying the toolbar and adding targeted custom actions improves usability and keeps the interface aligned with business requirements. This blog explains two Interactive Grid toolbar customizations implemented in Oracle APEX 24.2. The first customization removes the Finder Drop Down from the toolbar. The second customization adds a custom button to the Interactive Grid search bar and links it to a JavaScript action. All changes were implemented using standard Oracle APEX features without plugins. Topic 1: Tweak the Toolbar – Remove “Finder Drop Down” The Finder Drop Down in the Interactive Grid toolbar allows users to search, filter, and apply conditions on the grid data. In controlled ...

Introduction This blog demonstrates how I converted a spreadsheet containing school data into a fully functional web application using Oracle APEX 24.2 . The application includes a dashboard, interactive reports, faceted search, and a map page with search functionality. Spreadsheet Data The spreadsheet contained the following columns: Borough School Name Neighborhood Interest Method Total Students Graduation Rate Attendance Rate College Career Rate Latitude Longitude All data is uploaded directly using the Import Data option in Oracle APEX 24.2, which automatically reads and maps the spreadsheet columns. Step 1: Import Spreadsheet Using APEX 24.2 Navigation: App Builder → Utilities → Import Data Select the spreadsheet file Map columns automatically detected by APEX APEX creates an internal table to store the data for application use This approach eliminates manual table creation and allows immediate use of spreadsheet data. Step 2: Create Application with Dashboard Using Create Applic...

  Introduction In modern applications, Barcodes and QR Codes are widely used to identify products, track inventory, enable quick access to information, and simplify scanning operations. Oracle APEX does not provide built-in barcode or QR generation components, but with the help of JavaScript libraries and Interactive Reports , we can implement this feature efficiently. In this blog, I explain how I implemented Barcode Generator and QR Code Generator in Oracle APEX 24.2 , how data is stored and fetched from database tables, and how barcodes and QR codes are rendered dynamically in reports. Why Barcode and QR Code Are Needed Unique identification of products Faster scanning compared to manual entry Reduced human errors Easy integration with scanners and mobile devices Useful for inventory, billing, logistics, and asset tracking   Flow Create a Form Page to enter product details Save product data into database tables Display data using Interactive...

  Project Overview D2D Feed is a real-world e-commerce web application developed using Oracle APEX , designed to manage product ordering, cart handling, secure payments, and order tracking with barcode generation. The application supports role-based access , Google social login , and Stripe payment integration , making it a complete end-to-end solution. 1. User Registration & Authentication The application starts with a secure Sign Up and Login system . Only permitted associations/users are allowed to sign up Authentication methods: Normal username & password Google Social Sign-In Two user roles: Admin User This ensures controlled access and role-based functionality. 2. Home Page – Category-Based Navigation After successful login, the user lands on the Home Page , which displays multiple product categories using a Classic Report with Card Layout .  Available categories include: Vegetables Groceries Fruits Medicines (a...