APEX – Report Rows Clickable to detailed page
Description: This document describes how to make an Apex Reports clickable to a detailed page with an option of entire row selection. In Apex, Report is an important…
Read MoreHow to JQuery Id selector in ADF
Description: The ADF components will render with some mixed special characters. For this case, if you want to find the id, We need do add ‘\\’ before to the special character. Example: ADF Actual Rendered ID:pt1:r1:0:pgl13 JQuery ID selector: $(“#pt1:r1:0:pgl13”);———-It doesn’t work $(“#pt1\\:r1\\:0\\:pgl13”)——-It works. Summary: The…
Read MoreAR Receipt Query: AR XLA GL
Description: The below steps describe the responsibilities to check the AR Receipt Query on AR XLA GL. SELECT glcc.segment1 company, glcc.segment2 LOCATION, glcc.segment3 cost_center, glcc.segment4 ACCOUNT, glcc.segment5 product,…
Read MoreHow to Set Interactive Report Filter with URL Parameters
Description: Interactive Reports are very powerful; the end-user can set filters, highlighting, add computed columns, do control breaks or groupings, and much more. As a Developer, you might sometimes have…
Read MoreAR Receipt Distribution Query: AR XLA GL
Description: The below process explains the responsibilities of AR Receipt distribution query on AR XLA GL SELECT glcc.segment1 co, glcc.segment2 loc, glcc.segment3 cc, glcc.segment4 acct, glcc.segment5 prod, glcc.segment6 chan,…
Read MoreHow to Highlight Tabular Form Rows on addition from Pop-up
Description: This is often used to show additional information about a row, particularly when you wish to convey more information about a row than there is space for in the…
Read MoreAR Receipt Distribution Query: AR XLA GL
Description: The below process explains the responsibilities of AR Receipt distribution query on AR XLA GL SELECT glcc.segment1 co, glcc.segment2 loc, glcc.segment3 cc, glcc.segment4 acct, glcc.segment5 prod, glcc.segment6 chan,…
Read MoreAR Adjustments Query: AR XLA GL
Description: The below post explains the code and step to create AR Adjustments Query of AR XLA GL SELECT glcc.segment1 company, glcc.segment2 LOCATION, glcc.segment3 cost_center, glcc.segment4 ACCOUNT, glcc.segment5 product_line,…
Read MoreAppend the DataBase value to Tabular Form Select List
Description: Ajax(Application Process) used to Get the value from Database Return value as node and attribute. Example : l_Opt_Xml.firstChild.nodeValue and l_Opt_Xml.getAttribute(‘value’). Create the Element of OPTION Example : var l_Opt = document.createElement(“option”); Add the OPTION to Target Select List and Append the OPTION to Target Select List Example : pSelect.options.add(l_Opt); pSelect.appendChild(l_Opt); Insert the select list content to OPTION and Append the select list content to OPTION Example : l_Opt.innerText = pContent; l_Opt.appendChild(document.createTextNode(pContent)); Summary; This…
Read MoreAppend the DataBase value to Tabular Form Read-only Column
Description: “Tabular format” is simply information presented in the form of a table with rows and columns. Most office productivity software programs. The below steps explains how to append the database value…
Read More