Due to many columns in the report the data will be wrapped automatically. Resolution: 1. In report attributes, assign the static ID for the column that you want not be shrink. 2. Add the following code in the page header to remove the wrapping. $(function() { $(“td[headers=column_name’]”).attr(“nowrap”,”nowrap”); }); Output:
Read MoreWith the below code we can send individual emails to the users with an ICS file as attachment. ICS is a global format for calendar files widely being utilized by various calendar and email programs including Google Calendar, Apple iCal, and Microsoft Outlook. These files enable users to share and publish information directly from their calendars over email or via uploading it to the world wide web. Step 1 : Compile the below code CREATE OR REPLACE FUNCTION ical_events ( p_summary IN VARCHAR2, p_description IN VARCHAR2, p_start_date IN DATE, p_end_date IN DATE ) RETURN VARCHAR2 AS lv_desc VARCHAR2 (20000); lv_summary VARCHAR2 (10000); lv_dtstart VARCHAR2 (100); lv_date VARCHAR2 (100); lv_dtend VARCHAR2 (100); l_retval VARCHAR2 (32767); l_lf CHAR (1) := CHR (10); BEGIN lv_summary := ‘SUMMARY:’ || p_summary; lv_date := ‘DTSTAMP:’ || TO_CHAR (SYSDATE, ‘RRRR-MM-DD’) || ‘T’ || TO_CHAR (SYSDATE, ‘HH24:MI:SS’); lv_dtstart := ‘DTSTART:’ || TO_CHAR (p_start_date, ‘RRRR-MM-DD’) || ‘T’…
Read MoreHidden column cannot be downloaded in classic report if, Display As : Hidden Include In Export : Yes This can be achieved using the PLSQL Expression: Column attributes-> Display As : Display as Text Column attributes-> Conditional display-> Condition Type : PLSQL Expression Expression : apex_application.g_excel_format = TRUE
Read MoreStep:1 : Create items to set count of rows and display item to represent pagination. Also create buttons to navigate different pages. PXX_FROM – From Value PXX_TO – To Value PXX_MAX – Max Value PXX_PAGINATION – Rows per page PXX_PAGINATION_DISPLAY – Pagination Display Buttons: Save and Next,Save and Previous, First Page,Last Page Step:2: Restrict data with specified range in report query, Query is displayed as follows SELECT master_item_id, master_item_id_display, master_pdvd_id, item_id, col1, col2, col3, col4, col5, col6, col7, col8, col9, NULL, “Check”, active_ind, SEQUENCE, “replicate_of” FROM (SELECT ROWNUM rm, master_item_id, master_item_id_display, master_pdvd_id, item_id, col1, col2, col3, col4, col5, col6, col7, col8, col9, NULL, “Check”, active_ind, SEQUENCE, “replicate_of” FROM (SELECT c001 master_item_id, seq_id master_item_id_display, c002 master_pdvd_id, c003 item_id, c004 col1, c005 col2, c006 col3, c007 col4, c008 col5, c009 col6, b.c010 col7, c011 col8, NULL col9, NULL, NULL “Check”, c012 active_ind, (SELECT display_order FROM pdvd_tb_lov_dict WHERE lov_id = b.c008) SEQUENCE,…
Read MoreStep:1: On Submit, Before Computation and Validation – Insert into Collections. BEGIN apex_collection.add_member (p_collection_name => ‘PDVD_MASTER_ITEM_DTLS’, p_c001 => apex_application.g_f03 (i), p_c002 => NVL (:p77_master_pdvd_id, NULL ), p_c003 => apex_application.g_f04 (i), p_c004 => apex_application.g_f05 (i), p_c005 => apex_application.g_f06 (i), p_c006 => apex_application.g_f07 (i), p_c007 => apex_application.g_f08 (i), p_c008 => apex_application.g_f09 (i), p_c009 => apex_application.g_f10 (i), p_c010 => lv_v_master_repli_of, p_c011 => lv_v_delivery_types, p_c012 => apex_application.g_f15 (i) ); EXCEPTION…
Read MoreStep:1: On-change of items, insert into locks table. Dynamic Action : On-Change Selector : JQuery Selector [name=f05] Execute Javascript Code, /* Getting the Program Name Details*/ var c=($(this.triggeringElement ).attr(‘name’).substr(0,3)); var d=this.triggeringElement.id; //alert(d); var str = d.substring(4,8); if(c==”f05″) { // Assigning PDVD Type var p_pdvd_type=”Master”; //alert(p_pdvd_type); //getting column header value idheader =”#f05_0001_LABEL” ; var p_field_name = $(idheader).closest(“label”).html(); //alert(p_field_name); //getting Master PDVD ID var p_pdvd_id=$(‘#P77_MASTER_PDVD_ID’).val(); //alert(p_pdvd_id); //getting Item ID var p_item_id=$(this.triggeringElement ).attr(‘id’); //alert(p_item_id); //getting Item value var p_item_val=$x(p_item_id).value;…
Read MoreThis page explains the steps involved in generating the Colombia Third party report balances. This process ensures the passage of the third party details to GL. This is mandatory in…
Read MoreCompanies in Brazil use bank services to collect customers. The Brazilian Electronic File Transfer for Receivables (CLL F034) provides the functionality to electronically transfer collection documents to banks using files…
Read MoreCompanies in Brazil use bank services to collect customers. The Brazilian Electronic File Transfer for Receivables (CLL F034) provides the functionality to electronically transfer collection documents to banks using files…
Read MoreFor Merging cells in Excel and for other CSS in download property, i.e to create down loadable XLS formatted sheets from any version of APEX use the following steps: 1. Create a new blank page in the application using Customized template. In that customized template remove all the contents in the page, like navigation menus, APEX page Toolbar, and others , since by putting this in a Before Header process on a page, the entire page will be downloaded as a native Excel Spreadsheet. 2. Create PLSQL Region with no template. — Should use recursion for a full tree, but we only need executives. DECLARE l_dirtotal NUMBER (12, 2); BEGIN HTP.p (‘<table border=1 white-space=nowrap><tr style=”background-color:silver;”> <th colspan=5>Employee</th><th>Title</th><th>Salary</th> <th>Direct Report Total</th></tr>’ ); FOR c_exec IN (SELECT * FROM employee WHERE direct_report_id IS NULL) LOOP SELECT SUM (salary) INTO l_dirtotal FROM employee WHERE direct_report_id = c_exec.ID; HTP.p ( ‘<tr height=80><th align=right><img src=”‘ || c_exec.image || ‘”></th><th colspan=4 style=”white-space:nowrap;font-size:36px;color:green;background-color:#CCFFCC;”>’ || c_exec.NAME || ‘</th><th>’ || c_exec.title || ‘</th> <th style=”font-size:36px;”>’…
Read More