API to create party and link to the Supplier
Introduction / Issue As part of TCA, the supplier needs to be linked to the party. This API establishes the link between the Party and the Supplier. Why We Need…
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 MorePushing OIC Activity Stream Logs directly to OCI Log Analytics
Introduction: OCI Log Analytics is a great value add to OIC monitoring, especially in respect of OIC fleet management. Previously, we needed to send the logs via OCI Logging, and,…
Read MoreFrom 4 Minutes to 2: Building a Desktop HITL Assistant for SharePoint Vendor Validation
Introduction / Issue Anyone who has supported a Human-in-the-Loop (HITL) validation workflow knows the friction: an AI model extracts invoice data, a human validator must confirm every field against the…
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 MoreSeeing Inside the Black Box: Building a Visualizer for RAG Chunks
Introduction / Issue Anyone who has worked with a Retrieval-Augmented Generation (RAG) pipeline has run into the same frustrating moment: the model returns an answer, and somewhere behind it a…
Read MoreSql Query to get Item wise lot quantity
Introduction/ Issue: This query will help us to get item wise lot quantity. Why we need to do / Cause of the issue: When we need to validate the lot quantity item wise, we…
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