Overview 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 MoreDescription: SQL Server is the database management systems. If you want to protect your data and applications from hackers, malware, and other risks, you need to update and patch your…
Read MoreDescription: Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. database tables that can store and retrieve any amount of data…
Read MoreDatabase tables often contain sensitive information such as credit card details, contact information, and personal bank details, which require safeguarding against unauthorized access. To address this concern, Oracle 12c and…
Read MoreHow to load Chart of Accounts Mapping Introduction: This can be used as a reference document while we do the chart of accounts mapping. You can define chart of…
Read MoreMongodb on linux Mongodb version 3.4 Step -1 -Create a directory to keep the software – Give full permission to the directory for Execute Step -2 -Download software mongodb…
Read MoreIntroduction Oracle fusion comes with IDR Solution or Intelligent Document recognition solution. The integrated invoice imaging solution which is part of Oracle Cloud functionality can perform scanned image import, intelligent…
Read More1. Overview We know that the oracle apex have default collapsible option in reports ,in some case we have multiple region and if we wants to expand and collapse the region…
Read More