Oracle EBS – Top Ten List on Navigator form

Some Information on Top Ten List feature on Navigator form


The top ten is saved to the FND_USER_DESKTOP_OBJECTS table. The table is read from at sign on. It is updated from the API function FND_SIGNON.UPDATE_NAVIGATOR when the user logs out.

SQL> select user_id from fnd_user where user_name = ‘<USER>’;

select application_id, responsibility_id
from fnd_responsibility
where responsibility_key = ‘<<RESPNAME>>’;

Select function_name, object_name
from fnd_user_desktop_objects
where user_id = ‘<result from #1>’
and responsibility_id = ‘<result from #2>’
and application_id = ‘<result from #2>’=

Oracle EBS – Where are the attachments stored when using the attachment feature within the Applications?


The system profile value "Attachment File Directory", points to the directory on the Forms Server where the attachment files are stored.

To find this profile value, go into Applications using the System Administrator responsibility. Navigate to:

–> Profile –> System and search for “"Attachment File Directory" profile option


Oracle EBS – Set the Applications Context (FND_GLOBAL.APPS_INITIALIZE)

Setting the Applications Context (FND_GLOBAL.APPS_INITIALIZE)

Use the API FND_GLOBAL.APPS_INITIALIZE to set the applications context in standalone sessions that were not initialized through normal means. Typically, you would use this API in external custom programs that are establishing their own connections.

procedure APPS_INITIALIZE(user_id in number,resp_id in number, resp_appl_id in number security_group_id in number);

This procedure sets up global variables and profile values in a database session. Call this procedure to initialize the global security context for a database session. You can use it for routines such as PL/SQL or other programs that are not integrated with either the Oracle Applications concurrent processing facility or Oracle Forms (both of which already do a similar initialization for a database session). The typical use for this routine would be as part of the logic for launching a separate non–Forms session from an established Oracle Applications form session. You can also use this procedure to set up a database session for manually testing application code using SQL*Plus. This routine should only be used when the session must be established outside of a normal form or concurrent program connection.

Arguments (input)

USER_ID – The User ID number.

RESP_ID – The ID number of the responsibility.

RESP_APPL_ID – The ID number of the application to which the responsibility belongs.

SECURITY_GROUP_ID – The ID number of the security group. This argument is automatically defaulted by the API. The caller should not pass a value for it.

You can also use sql like the following to get the values from sqlplus (as apps):

select application_id, Responsibility_id, responsibility_name
from fnd_responsibility_vl
where responsibility_name like ‘<<RESPNAME>>’;

select user_id, user_name
from fnd_user
where user_name=’<<USER>>’

Oracle EBS – Documents Tab on the Navigator

What is the Functionality of the Documents Tab on the Navigator

image If you have a document, such as a particular purchase order, invoice, or sales order that you want to access later, you can create a link to the document using the Navigator’s Document feature.

The Navigator’s Document feature allows you to create as many links as you want and save them in the Documents region of the Navigator window. The links can be represented as icons in the window or may be viewed as a list. Documents are defined as "real–world” documents such as those listed above, but may also include such documents as employees or plans. When you use a link to open a document, Oracle Applications opens the document in the appropriate form window. You can access the Document region using the tab control.

Adding new Documents to the Navigator
1. Forms that support adding documents to the Navigator enable the Place on Navigator menu item in the File menu. Use this menu item to add your document to the Navigator.

Opening the Navigator’s Document Region
1. Choose Documents from the tab control in the Navigation window.
Once you create a link to a document, the Document region will open by default when you log on.
To open a form from the Document Region
1. Select the document link you want to open.
2. Choose Open or double–click it.

Renaming Documents in the Navigator
1. Select the document link you want to rename.
2. Choose the Rename… button, or double–click the label.
3. Enter the new name, then press OK.
Note: There is a limit of 80 characters for document names.

Removing Documents from the Navigator
1. Select the document link to be discarded.
2. Choose Remove.
Removing the document link from the Navigator has no effect on the actual document. However, if a record such as a purchase order is deleted in the ”Enter Purchase Orders” form, the link in our Navigator displays a message letting you know that your link is now invalid.

for more info – do refer — following extract from "Oracle Applications User Guide" –Using the Navigator’s Documents Region – Page 1 – 18

Oracle EBS – Why does Help > Tools > Examine ask for a password?

The system profile option Utilities:Diagnostics is set to ‘NO’.

This profile option controls whether normal users can use the Examine utility without restriction. The password prompted for is the APPS account password, so access can be restricted to only those users that know the APPS password.

If you want to use Examine utility without APPS password then set this profile option to YES.

Sometime , Diagnostics itself ( button/ menu entry in Help menu ) is not available or invisible, this is done by using profile option –“Hide Diagnostics Menu Entry “

Make this profile option as “NO”

Oracle Database -External Table – How to populate/ outbound file creation using External table

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> create directory my_dir as ‘/usr/abc’; —

Make sure Oracle OS user hasprivilege to write on this directory.

Step 2: – Grant permission to user SCOTT

SQL> grant read,write on directory my_dir to scott;

Step 3: – Create the External Table:

SQL> CREATE TABLE scott.extract_emp_dept



LOCATION (’emp.exp’))

reject limit unlimited


select e.ename,d.dname from emp e, dept d where


SQL> select * from scott.extract_emp_dept;

And you will find a file generated i.e. ’emp.exp’ in /usr/abc directory. Now you can take this file to the target database and create an external table and associate the file with that table.

Step 4: – to be performed on the source database

SQL> set long 2000

SQL> Select dbms_metadata.get_ddl(‘TABLE’,’EXTRACT_EMP_DEPT’) from dual;

The above command will give you the DDL command to create the table at target database.