Download Jasper Report with Dynamic Names from Oracle Apex
This document is to download jasper report with dynamic names from oracle apex. Technology and Tool Used : Oracle Apex Jasper Reports Javascripts HTML Use Case : If a requirement…
Read MoreIntegrating JavaScript map chart with APEX
Integrating JavaScript map chart with APEX This document talks about how to Integrate APEX with JavaScript map chart. Technologies and Tools used: The following technologies has been used to…
Read More5 Things not do with APEX 5.0 for Easy upgrading
5 Things not do with APEX 5.0 for Easy upgrading These are below following high level observations on the bottle neck factors while upgrading Apex 5 to the latest versions. They are Should use the Apex In build Utilities. Should not Use any…
Read MoreImage issue in Apex (Images Not working properly)
Description: TO Solve Image loading issue in Apex (Images Not working properly). Steps: Query and steps to find the Apex user details. ROOT@AWSCLD_DEV> select username from dba_users where username like…
Read MoreHow to export and import oracle apex application and workspace from command line
Query to identify applications/workspace information of your Oracle apex Application COLUMN workspace FORMAT A20 COLUMN workspace_id FORMAT 99999999999999999999 COLUMN application_id FORMAT A14 COLUMN application_name FORMAT A20 — List applications. SELECT…
Read MoreHow to enable trace/debug in tomcat and which log we need to analyze when there is any issue reported
The default log files and logging levels are defined in logging.properties file under the below location /home/oracle/tomcat_09_Aug_2020/apache-tomcat-9.0.36/conf. The list is arranged in order by level of detail from the least…
Read MoreScript to Find Apex Page hits
Below script is for finding the Apex page hits ********************************************************************************************************** /home/oracle/backup/scripts/pagehits.sh . /home/oracle/db.env export SC_LOG=/Backup/pagehits/fms_`date +%d_%b_%H_%M_%Y`.log sqlplus -s <<EOF >>/usr/tmp/tmp1.log connect /as sysdba spool \$SC_LOG select flow_id,step_id,count(*) from FLOWS_030100.WWV_FLOW_ACTIVITY_LOG where…
Read MoreScript to Find Apex Page Time
Below script is for finding the Apex Page Time ********************************************************************************************************** /home/oracle/backup/scripts/pagetime.sh . /home/oracle/db.env export SC_LOG=/Backup/pagetime/fms_`date +%d_%b_%Y_%H_%M`.log sqlplus -s <<EOF >>/usr/tmp/tmp2.log connect /as sysdba spool \$SC_LOG select flow_id,step_id,sum(elap)/count(*) “Average” from FLOWS_030100.WWV_FLOW_ACTIVITY_LOG…
Read MoreQR Code Creator – Oracle Apex
QR Code Creator QR Code is defines that a machine-readable code consisting of an array of black and white squares, typically used for storing URLs or other information for reading…
Read MoreInstallation and Configuration of Oracle Application Express with Oracle REST Data Services and Apache Tomcat
Installation and Configuration of Oracle Application Express with Oracle REST Data Services and Apache Tomcat Installed Softwares (requirement may vary) Oracle Application Express 5.1.4 Apache Tomcat 7.0.96 Oracle Rest Data Service ORDS…
Read More