Creating Workers Oracle Fusion HCM API
Creating Workers in Oracle Fusion HCM via REST API Creating and Managing Workers in Oracle Fusion HCM Using REST APIs Instead of the Guided UI Flow Introduction / Issue Onboarding…
Read MoreStop Writing Fake INSERT Scripts in Oracle Apex during initial development: Generating Realistic Test Data in Oracle APEX with APEX_DG_DATA_GEN
Introduction / Issue Anyone who’s built in Oracle APEX for more than a few weeks knows this pain: the screens are done, the logic works, and every table is completely…
Read MoreBuilding a Multi-Level Approval Workflow in Oracle APEX Interactive Grid
Introduction Many enterprise applications require data to be reviewed and approved by multiple stakeholders before it becomes final. Oracle APEX provides an excellent platform for implementing such approval workflows using…
Read MoreFixing PDF Overwrites in JasperReports with Dynamic File Naming
Introduction: – When building PDF generation into a JSP application using JasperReports, a common bug shows up: every generated report is saved under the same file name, so each new…
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 MoreHow to Implement LDAP-Based Single Sign-On (SSO) in Oracle APEX Using HTTP Header Authentication
Introduction: – In enterprise environments, users expect seamless access to applications without repeatedly entering their credentials. Oracle APEX supports this through Single Sign-On (SSO) by integrating with Active Directory (LDAP)…
Read MoreNatural Language Filtering in Oracle APEX 26.1 Using Cohere AI
Introduction When working with data-dense Oracle APEX Interactive Grids, users often struggle with standard filter menus—especially when navigating complex datasets with multiple columns. Traditional UI filtering requires users to manually…
Read MoreImplementing Auto Submit Assessment on Timer Expiry in Oracle APEX
Introduction / Issue In an online assessment, candidates are given a fixed duration to complete the exam. If the timer expires before the candidate clicks the Submit button, the assessment may remain incomplete and the entered responses may not be saved. To overcome this issue, an automatic submission mechanism can be implemented. Why We Need to Do / Cause of the Issue During an online examination, candidates may forget to submit the assessment, close the browser, or lose track of the remaining time. This can result in incomplete submissions and loss of responses. Implementing an auto-submit feature ensures that all attempted answers are saved and evaluated when the allotted time expires. How Do We Solve Step 1: Create a Timer Region Create a Static Content region to display the countdown timer on the assessment page. The timer becomes visible as soon as the candidate starts the exam. <div class="exam-timer"> ⏳ Time Left : <span id="timer">02:00</span> </div> Step 2: Start the Countdown Timer On Page Load, use JavaScript to start the timer. Store the remaining time in sessionStorage so that the timer continues correctly even if the page refreshes. var timeLeft = sessionStorage.getItem("examTimer"); if(timeLeft === null){ timeLeft = 120; }else{ timeLeft = parseInt(timeLeft); } Step 3: Save Candidate Answers In the Dynamic Content region, save each selected option using sessionStorage. sessionStorage.setItem( "Q" + apex.item("P5_CURRENT_QN").getValue(), optionId ); Step 4: Restore Selected Answers When navigating between questions, retrieve the saved answer from sessionStorage and automatically check the previously selected option. var selectedOption = sessionStorage.getItem("Q" + currentQn); Step 5: Auto Submit on Timer Expiry…
Read MoreBuilding an AI-Powered Question Generator in Oracle APEX
Introduction/ Issue: Creating interview or assessment questions manually is a time consuming process, especially when maintaining a large question bank for multiple technical skills such as SQL, PL/SQL, Python, Java, and…
Read MoreEnforcing Dynamic Line Limits on APEX Interactive Grids
Introduction When building transactional forms in Oracle APEX—such as sales orders, requisition lines, or booking forms—business logic often requires capping the maximum number of detail lines a user can add…
Read More