Category Archives: Application Developer

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

Aside

Here is a sample code could be used to make all the responsibilities read only for a specific user. I am sure we can use it in different variations. 1. Open the Custom.pll in the Form Builder. 2.Add the following … Continue reading

Aside

I am sure you like to test your program or need to run them in batch mode/ back end. here is a sample, you can use them using sql*plus or any editor. This sample code will call "Submit Accounting" (Program … Continue reading