Description: The below Post indicates the responsibility to check the AR Transactions Query on AR XLA GL SELECT glcc.segment1 company, glcc.segment2 LOCATION, glcc.segment3 cost_center, glcc.segment4 ACCOUNT, glcc.segment5 product, glcc.segment6…
Read MoreDescription: Oracle XML/BI Publisher is a very good reporting tool, which outputs reports into many formats like Word, Excel, PowerPoint, PDF and even to Adobe Flash. This can deliver reports…
Read MoreDescription: Query to get the details of invoice with tax information’s select ctx.customer_trx_id, case when ( hrloc.address_line_1 is not null and ( hrloc.address_line_2 is not null or hrloc.address_line_3 is not…
Read MoreDescription: Displaying of 7 Consecutive Dates in Report Header Step 1: Create a date field for selecting the date. Step 2: Create a report for displaying the…
Read MoreDescription: 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 MoreDescription: 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 MoreDescription: 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 MoreDescription: 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 MoreDescription: 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 MoreDescription: “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