Integrating React Native with SQLite
1. Overview This document explains how to integrate React native with SQLite DB. 2. Technologies and Tools Used The following technologies and tools have been used to create a sample react application…
Read MoreSet Session State Value for APEX Application Item
1. Overview This blog talks about the setting session state value for application item using the JavaScript function in Oracle APEX. 2. Technologies and Tools Used The following technologies have been used to achieve this…
Read MoreSet Session State Value for Oracle APEX Page Item
1. Overview This document talks about the setting session state value for page item using the JavaScript function in Oracle APEX. 2. Technologies and Tools Used The following technologies have been used to achieve this…
Read MoreSubmission of Concurrent request from OAF
Consider a scenario like we need to submit a concurrent request when submit button in clicked. Code to submit concurrent request should be added in AM so that it can…
Read MoreStale Data Error in OAF
Sometimes when we perform multiple transactions to EO, we may get error like below. Solution: Open the EO of the table. Navigate Attribute property of the primary key of the…
Read MoreInteractive Report Cell Highlight based on condition using Jquery Dynamically
This document is to give background color to cell or change font color of the cell from query using Jquery. Technology and Tool Used : o SQL o JQuery Use Case : If a requirement arise from user to highlight a cell based on dynamic condition from query or based on a column value or based on any calculation we can achieve it with this codes. In-built apex feature will highlight the entire row and user can also remove the row wise filter. But this can be overcome with the below codes. Steps to be followed: Step 1 : Create a simple report query with employee table or build a own report query and to that add your condition within case function SELECT ename,sal,CASE WHEN JOB = ‘PRESIDENT’ THEN ‘data-style=”color:green”‘ WHEN JOB = ‘CLERK’ AND sal <= 3000 THEN ‘data-style=”color:orange”‘ WHEN JOB = ‘SALESMAN’ THEN ‘data-style=”color:red”‘ ELSE NULL END css_style,job FROM emp Here ‘data-style=”color:green”‘ is the css condition that gives color the the cell. Note: If you want to change the background color of cell simply alter the statement to ‘data-style=”background-color:green”‘ Step 2 Now go to report column and select the column which you want the color to be applied and under html expression paste the following code to call the class name for the column. <span #CSS_STYLE#>#JOB#</span> Step 3 : Now go to page properties -> Execute when page loads and paste the below code. apex.jQuery(“span[data-style]”).each(…
Read MoreSet Scroll to last saved location after page submit
This document is to set the scroll to last saved location. Technology and Tool Used : Oracle Apex Javascripts Use Case : If a requirement arise from user to set scroll to the last saved location i.e before page submit a user might be somewhere in the middle of the page and once the page gets submit the cursor by default will go to the top of the page , to prevent this and to bring the cursor to the last spot where the cursor was before submitting the page, this code can be used. Steps to be followed: Step 1 : Create a page item in apex screen. Note : The item can be in hidden state also. Step 2 : Create multiple report region or any region. The condition is that the page you have must have at least two region. Note : In my case I have created 4 reports. Step 3 : Now create a javascript code to capture the last scroll location function scroll() { //var a = $(‘.t-Dialog-bodyWrapperIn’).scrollTop(); //Capture scroll of modal page. var a = $(window).scrollTop(); //Capture scroll of normal page. $(“#P7_SCROLL”).val(a); // Here P7_SCROLL is the item used to store the scroll location. } Step 4 : Now create a javascript to call the function scroll() before page submit. To achieve this create a dynamic action before page submit and select execute javascript action.…
Read MoreAR Adjustments Outbound from EBS
Introduction: This procedure is used to extract the adjustments from EBS for Cloud Import. create or replace PROCEDURE XXXX_AR_ADJ_EXTRACT_CLOUD ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_org_id IN NUMBER, p_trx_date_from…
Read MoreChange WEB Port on 12.2
Change WEB Port on 12.2 The steps to change the webport to 8000. Step-1:Start only Weblogic admin using adadminsrvctl.sh start on run file system Login to Enterprise Manager(em) Console using below…
Read MoreOracle Database Upgrade from 12c to 19c database Using Manual Upgrade
Introduction: There are different methods to upgrade an Oracle database from a lower version to a higher version. Oracle provides multiple methods to upgrade based on the version. A few…
Read More