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 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 MoreIntroduction This Post illustrates the steps required to Period and Daily Exchange Rates in Fusion Application. Script to Period and Daily Exchange Rates in Fusion SELECT gper.set_of_books_id ,gl_set_of_books.name || gper.period_name…
Read MoreDescription: Profile Option values control the behavior of Oracle Apps; in other words, they determine how Oracle Apps should run. The value for a profile option can be changed at…
Read MoreIntroduction This post is about to get an opening, purchasing, receive, sales, and closing quantity of items query. Script to get opening, purchasing, receive, sales and closing quantity of…
Read MoreIntroduction This Post is about to Sales Order details with India Localization tax in Oracle EBS R12. Script to Sales Order details with India Localization tax SELECT h.header_id header_id,…
Read MoreIntroduction This Post illustrates the steps required to Update and assign project Roles using PA_PROJECT_PARTIES_PUB in Oracle EBS. Script to Update and assign project Roles using PA_PROJECT_PARTIES_PUB DECLARE l_project_id_PREM …
Read More