Overview In Oracle APEX, a interactive grid had a concept of adding multiple row. Here in some cases the specific requirement here is to insert only one record at a…
Read MoreProblem: Traditional batch processing setups often face resource inefficiencies, as they are provisioned statically, leading to underutilization during low-demand periods and potential bottlenecks during peak times. Manually adjusting resources is…
Read MoreProblem: In a rapidly evolving and dynamic IT environment, managing complex infrastructure configurations across various projects and environments can be daunting. A monolithic approach to Terraform scripts may lead to…
Read MoreOracle EBS – PO Report with Bursting https://doyensys.com/wp-content/uploads/2024/01/oracle-ebs-po-report-with-bursting.doc
Read More1.Overview This document explains about how to create dynamic quick picks for page items in Oracle Apex. 2.Technologies and Tools Used The following technology has been used to dynamic quick…
Read MoreOverview A new page item introduced in APEX 23.2 is the QR Code Generator. This brings QR code generation native to APEX, previously only possible using third-party libraries. The page…
Read MoreOverview The new combo box in Oracle APEX 23.2 introduces exciting possibilities for building dynamic and user-friendly applications. They are akin to the classic select list and Popup LOV, but they…
Read MoreOverview In Oracle APEX 23.2, the Image Upload Page Item revolutionizes image management. It offers a contemporary interface for users to preview and modify images before uploading, aligning with modern…
Read More1. Overview In this we are going to see about how to check the character in the numeric page item on lose focus and also going to check the decimal length on lose focus. 2. Technologies and Tools Used The following technology has been used to achieve the same. Ø Java script` Ø Oracle Apex 22.1 3. Use Case There will be automatic validation for checking the number field but it will work only on clicking the button but we can also show the error on lose focus of the item when entering the characters in to it by using the below method.And also in this we are checking length of the decimal numbers in the lose focus. Architecture. Step 1: Create new page in oracle application and create a new region Step 2: Create a new page item as number field. Step 3: Create a dynamic action select javascript code and paste the following code. CODE : var a = $v(‘P3_NUMBER’); if(isNaN(a)) { apex.message.clearErrors(); if ( $(“#P3_NUMBER_error”).length == 0) { apex.message.showErrors([ { type: “error”, location: [ “page”, “inline” ], pageItem: “P3_NUMBER”, message: “Number Must be a Numeric.”, unsafe: false } ]) }…
Read More1. Overview In this we are going to update the details in the master table and the request will send to the request table we will show both forms in single screen with highlighted the changes in the request region and make the master region as read only. 2. Technologies and Tools Used The following technology has been used to achieve the same. Ø Java script` Ø Oracle Apex 22.1 3. Use Case If we have a requirement for approval workflow. The data will maintain in master and request table.If we update the details in the master table and the request will be send through the request table.we will show both forms in single screen with highlighted the changes page item in the request region and make the master region as read only in approver screen . Architecture. Step 1: Create new page in oracle application with report and form Step 2: Create a new region as report make row id enabled and make it as primary key. Step 3: Create one request table for the master table. Create another region for request table,enable the row id and make it as primary key for the region. Step 4: In form page disable the start new row for request region. Step 5: Write a insert process for request table in update condition. Step 6: In page load make a dynamic action with server side condition where status flag is update. CODE: var a1 = $v(‘P3_EMPNO’); var b1 = $v(‘P3_EMPNO_1’); var a2 = $v(‘P3_ENAME’); var b2 = $v(‘P3_ENAME_1’); var a3 = $v(‘P3_JOB’); var b3 = $v(‘P3_JOB_1’); var a4 = $v(‘P3_HIREDATE’); var b4 = $v(‘P3_HIREDATE_1’); var a5 = $v(‘P3_SAL’); var b5 = $v(‘P3_SAL_1’); var a6 = $v(‘P3_COMM’);…
Read More