Posts by Venkatesh Balasubramanian

Append 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 More

Append 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

Period and Daily Exchange Rates Query – FUSION

Introduction 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 More

How to query profile options and values API

Description: 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 More

Query to get opening, purchasing, receive, sales and closing quantity of items

Introduction 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 More

Apex used to call the Oracle JOB scheduler and Java

Description: The below steps describe who Apex used to call the Oracle JOB scheduler and Java users to create in oracle EBS with examples.   l Create the HTML link on…

Read More

Sales Order details with India Localization tax

Introduction 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 More

Update and assign project Roles using PA_PROJECT_PARTIES_PUB

Introduction 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

Oracle EBS Table Suffixes

introduction You have a lot of tables ending with different suffixes in the Oracle Apps database. Listed below are the different types of tables. ALL: Table ending with _ALL means it…

Read More

APEX upgrade from 4.0 to 4.2 – Technical Issues

Description: Upgrading Oracle Application Express creates new database objects in a new schema and migrates the application metadata to the latest release. Problem:Login issue – unable to login to the…

Read More