WIP Job Close via Apex Application
Introduction / Issue Closing a WIP job in EBS normally means going through the Discrete Jobs form manually — checking if all transactions are done, confirming the job status, and…
Read MoreIntegration of Payment and SSO in Oracle Apex
Introduction/ Issue: The ATS Resume Scanner app needed two things before a user could actually use it: a login that didn’t require yet another password, and a way to charge…
Read MoreATS Apex application with Ollama hosted in Cloud Fare
Introduction/ Issue: This is a walkthrough of the mini project that was built end to end in Oracle APEX – an ATS Resume Builder. It takes a user through…
Read MorePreventing Duplicate Form Submission in Oracle APEX
Introduction / Issue One of the common issues encountered while developing Oracle APEX applications is duplicate form submission. Users may unintentionally click the Save button multiple times due to slow network…
Read MoreUI Mistakes Oracle APEX Developers Should Avoid
Introduction / Issue Many Oracle APEX applications successfully meet business requirements but often overlook one critical aspect—the User Interface (UI) and User Experience (UX). Developers tend to focus primarily on…
Read MoreCalling Concurrent Program for Reference Document from APEX to EBS Application
Objective The objective of this document is to explain the process of invoking an Oracle EBS Concurrent Program from the Oracle APEX application using a PL/SQL procedure for report generation.…
Read MorePre-requisite for the Sales Orders purging
Introduction In the oracle EBS the concept of Purging and before purging the order management related tables, pre-requisite to be done for the smooth purging process. The below script will…
Read MoreItem Where-Used Analysis Report (Excel – PL/SQL)
Introduction: This blog has the SQL query that can be used for Item where used Report in Oracle Apps R12. Cause of the issue: Business wants a PLSQL excel based report…
Read MoreCentralized Content Management with APEX Shortcuts
Introduction: In Oracle APEX 21.2, managing label content across multiple pages can become inefficient and error-prone when updates are required. To centralize control and ensure consistency, we propose using APEX…
Read MoreThe Oracle Migration Challenge – Datatype Conversion Nightmares
When Database Migrations Go Wrong: Snowflake to Oracle Every database migration project starts with optimism: “We’ve mapped the tables, the data looks similar – how hard can it be to…
Read More