APEX

Create Customize POPUP LOV for APEX

Javascript Used to Get the Tabular Form Id Example : var eleTables = document.getElementsByTagName(“table”);for (var i=1;ivar tId = eleTables[i].id;if(tId.substring(0,7)!=”){if(tId.substring(0,7)==’report_’){var originalId = i;var tableIds = eleTables[i].id;tableId = tableIds;return tableId;} } }  Create the POPUP Image on tabular column  Example : var link = document.createElement(‘a’);var image = document.createElement(‘img’);var span = document.createElement(‘span’);link.setAttribute(‘href’,’javascript:genList0_f16_0(“‘+a1+'”,”‘+filters+'”)’);link.className=”dark”;image.setAttribute(‘src’,’/i/list_gray.gif’); Customize the Window open Example : w = open(“wwv_flow_utilities.gen_popup_list” +“?p_filter=” +“&p_name=” + escape(filters) + “&p_element_index=” + escape (a1) +“&p_form_index=” + escape(‘0’) + “&p_max_elements=” + escape(”) +“&p_escape_html=” + escape(”) + “&p_ok_to_query=” + escape(‘YES’) +“&p_flow_id=” + escape(appId) + “&p_page_id=” + escape(pageId) +“&p_session_id=” + escape(l_field) + “&p_eval_value=” + escape(”) +“&p_translation=” + escape(‘NO’) + “&p_lov_checksum=Dynamicchecksum“winLov”, “Scrollbars=1,resizable=1,width=400,height=450”);if (w.opener == null) w.opener = self; w.focus();Based on Custom POPUP(Head No Column) append the value to Select list(Product) and read only column(Description and Drawing No)Here Return value(M2595) also customized then return to Tabular Column.

Read More

Dynamically Generate the Checksum id to solve the apex vulnerability problem

 Ajax(Application Process) used call the Oracle Query of APEX_ITEM.MD5_CHECKSUMJava method of  Math.random used to get Random no  Random no used to get the Attribute value from Select list  Example : thisObj = objs[rand_no]; if(thisObj){ checksumId=thisObj.getAttribute(‘value’); return checksumId; Apex Generate the checksum id per day only one time, I have customized and generated the   checksum id per each page refresh. Here show the checksum id screenshot,

Read More

To put the Company logo in each APEX page

l Go to Shared Components then click the images link and upload the image to application. l Click the Definition write the image name to logo text field as #WORKSPACE_IMAGES#company_logo.gif l Go to Page Template and add the LOGO prefix at table

Read More

APEX upgrade from 4.0 to 4.2 – Technical Issues

           1. Problem: Login issue – unable to login to the Apex application.                Solution: Remove the old APEX user (4.0)…

Read More

Oracle Application Express in Oracle Database 12c

Oracle Application Express in Oracle Database 12c Oracle Application Express Release 4.2.0.00.08 is installed by default in Oracle Database 12c. One of the major new capabilities introduced in Oracle Database…

Read More