Modern applications rely on One-Time Password (OTP) verification for secure authentication. These inputs are typically designed as multiple input boxes, each accepting a single character, providing a structured and user-friendly experience. Oracle APEX does not provide a native OTP input component. This article demonstrates how to build a fully configurable OTP Input Item Plugin from scratch, tested on APEX 24.2. Overview Configurable number of input boxes (1 to 12) Customizable size and colors per instance Supports numeric-only or alphanumeric input modes Auto-advance to next box after each entry Backspace moves back and clears the previous box Arrow key navigation between boxes Paste distributes characters across all boxes automatically Blur validation — empty boxes turn red when user leaves the component Page submit validation — blocks form submission if any box is empty Plugin Creation Navigation: Shared Components → Plug-ins → Create ...
In modern business applications, role-based input restrictions are common. For example: Certain users can select only a limited number of options in multi-select fields. Others have no restriction. Sometimes, selection depends on another field value, like a designation. Implementing such dynamic validations in Oracle APEX can be done efficiently using JavaScript functions combined with Dynamic Actions, keeping logic reusable and maintainable. Key Components Global Validation Function: A single JavaScript function that validates any multi-select LOV based on a controlling field (e.g., designation). Dynamic Action on LOV Items: Executes the validation function whenever a user changes selection. Safety Dynamic Action on Controlling Field: Clears dependent LOVs if the controlling value changes to prevent invalid data. Benefits: Centralized and reusable logic...