Category Archives: Application Developer

Aside

let me intraduce SQL by statements type.here statements defines set of commands. Generally types statements are as followed. Data definition Language(DDL) Data Retrieval or Query Language(DQL or DRL) Data Manipulation Language(DML) Data Control Language(DCL) Transaction Control Language(TCL) let me continue … Continue reading

Aside

Hello Friends , here is some of quite commonly used AR ( receivables )tables and their usage. There are many other tables also in AR but here i am putting only few commonly used tables. for other table if needed we can … Continue reading

Aside

As you know we can load data from OS flat files into the Oracle environment,Now here showing how to create an external file / populating external table Lets take a simple example: – Step 1: – Create a directory SQL> … Continue reading

Aside

What are External Tables? External tables are like regular SQL tables with some exceptions:           – The metadata of external tables is created using the SQL "CREATE TABLE … ORGANIZATION EXTERNAL" statement.            – The data resides outside the database … Continue reading

Aside

Setting your Oracle Applications session: fnd_global.apps_initialize (org_id) The examples set up the session for SYSADMIN user, System Administrator responsibility. e.g. SQL*Plus   exec fnd_global.apps_initialize(0,20420,1); e.g. for PL/SQL, TOAD, SQLDeveloper, SQL Navigator etc.: begin fnd_global.apps_initialize(0,20420,1); end; The parameters used here are: 1.        … Continue reading

Aside

What is the ICX: Forms Launcher system profile option for? This profile option is used by the Self Service Web Applications Personal Home Page (also known as ICX) to determine the base URL needed to launch an application, which in … Continue reading

Aside

There are numerous scenarios for each customer to customize the standard Application. The following sample code demonstrate how to pop up an error message when customer business validation fails. This note provides a detail steps for customizing the standard application … Continue reading