Introduction : The navigation menu is a critical part of the user interface, enabling users to easily access various features and pages of the application. However, the default navigation options may…
Read MoreIntroduction : Oracle APEX simplifies web app development, while JavaScript adds real-time interactivity. Together, they offer a powerful solution for capturing and validating Aadhaar numbers—India’s unique 12-digit ID. Why we need…
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 More1. Overview If we need to generate our report with the APEX_DATA_EXPORT this Document will Explain you how to generate the report with the APEX_DATA_EXPORT 2. Technologies and Tools Used The following technology has been used to achieve the same. Javascript OracleApex 1 Pl/Sql code 3. Use Case It will help us to generate a report with with the APEX_DATA_EXPORT to…
Read More1. Overview If we have a requirement to show the text field page item into the slider page item then this Document will Explain How to customize text field into slider page item. 2. Technologies and Tools Used The following technology has been used to achieve the same. Javascript` Oracle Apex 1…
Read More1. Overview This Document will Explain How to call a API using java script in oracle apex. Technologies and Tools Used The following technology has been used…
Read More1. Overview This Document will Explain How to create fixed column header with scrollbar in classic report Technologies and Tools Used The following technology has been…
Read More