How To Personalize Home Page With Expanding Menus?

How to Personalize the Personal Home Page navigator menu to display the responsibilities and underlying functions as a cascaded or tree type of menu? Similar to the way the forms navigator works with the ‘+’ signs.

To Personalize the Personal Home Page navigator menu to display the responsibilities and underlying functions as a cascaded or tree type of menu, perform the following steps:
1. Make sure that the Framework pages can be Personalize:

– set System Profile option ‘Personalize Self-Service Defn’ to Yes to enable Personalize Regions
– set FND: Personalization Region Link Enabled to Minimal or Yes.

2. From the Personal Home Page, select: Personalize “Home Contenttable”

3. Expand All “Table Layout: Home Contenttable”

4. Select Personalize next to “Row Layout: (appsNavTreeRow)” set Render = True

5. Apply

6. Select Personalize next to “Row Layout: (responsibilityRow)” set Render = False

7. Apply

You will now see an expanding tree of responsibilities from the Personal Home Page.
Steps 2 through 5 will give you the expanding tree of responsibilities. Steps 6 and 7 will remove the old navigator from the
page. If you do not do steps 6 and 7 you will have both menus on the Personal Home Page.

How To Attach A Document Link To A Self Service Page Via Personalizations?

How to personalize a page in order to open a document in a new window ?

If you want to add a link in a page, you can do as below :

In the personalize Page link, add an item :
Item Style : Button
ID : My_Doc
Destination URI : http://………./document.pdf
Prompt : My doc

The above opens the document in a new window.

What Profiles Must Be Set For Personalizations Links To Appear And Take Effect In Self Service?

The following profiles must be set to the following values for personalization links to appear in Self Service

FND: Personalization Region Link Enabled set Yes

Personalize Self-Service Defn set to Yes

Disable self-service personal set to No

If any of the profile values need to be changed, once you set them the correct values please:

Log out of applications completely.
Shudown apache server
Start up apache server

‘Expenditure Organization Is Not Active Error’ When Entering Project Related Internet Expense Reports

When attempting to enter project related Internet Expense reports,  the following error occurs.

‘The expenditure organization is not active’


The Organization assigned to the Employee was not set up with a classification of  Project Expenditure/Event Organization.

“At the bottom of the Organization window is a section called Organization Classifications. In order to charge expense reports to the organization it must have a classification of Project Expenditure/Event Organization”

— To implement the solution, please execute the following steps::

1. Go into the appropriate Oracle Human Resources responsibility:

2. Navigate to Work Structures -> Organization -> Description

3. Query up the Organization which is tied to the assignment for the employee encountering
the error.

4. Set the organization up with a classification of Project Expenditure/Event Organization.

5. Save the changes

6. Bounce Apache

 Forms Personalization : How to Add a Web Link to the APPS Forms Menu

Forms personalization feature may be used to add a new field in the menus of the forms
in the e-business suite 11 i .

Below is the Forms Personalization code which will add a Web Link in the Tools menu  :
1) Login to your responsibility
2) Go to the Forms you need to personalize
3) Open personalizations forms :  Help/Diagnostics/Custom Code/personalize
4) Enter sequence as ‘1’ and in description enter ‘Init Web URL menu’
5) In condition tab, enter trigger event as ‘WHEN-NEW-FORM-INSTANCE’
6) Click on ‘Actions’ tab. Enter sequence as ‘1’ and Type = ‘Menu’.
7) Choose Menu Entry (any of the special menu entries). Eg. Special 12
Enter menu label ( eg: Web URL )
8 ) In ‘Enabled in Blocks’ field you can choose for which blocks the special menu needs to be enabled or leave blank to be enabled for all the blocks of the forms
9) Go back to the main block where you entered ‘Init Web URL menu’.
10) Enter a new record with sequence as ‘2’ and in description enter ‘Launch URL’
11)In Conditions tab, enter trigger event as ‘SPECIAL12’
12) Click on Actions tab. Enter sequence as ‘1’ and Type = ‘Builtin’.
13) Choose ‘Launch a URL’ for Builtin Type
13) Enter the argument as your URL ( eg : ) and click ‘Apply now’ button.
14 ) Save .
15) Exit form , logout , login and go to your Forms again.
16) Go to Tools menu. The new special menu ( Web URL ) entry will be displayed.
Click to launch URL.

How can we retrieve data from standard Oracle Applications view?

All views in release 11.5 are operating unit dependent. Before querying from the views, org context needs to be set.

1) Please launch the applications and select the appropriate responsibility

2) Then use Edit -> Preferences -> Profiles

3) Query for profile MO: Operating Unit

4) Place cursor in the field where the operating unit is specified (Default Value or User Value)

5) Then use Help > Diagnostics > Examine

6) Get this value and then set the context using SQL:
SQL> Exec dbms_application_info.set_client_info(&org_id)

7) Now run the query for the view

How To Run SQL as An Applications Mode in SQL*PLUS

  1. Login to SQL*PLUS as the ‘APPS’  application user.
  2. Obtain the user id, responsibility id, application id and security group for the intended applications user/responsibility combination you want to run the SQL with:
        WHERE USER_NAME = '&user_name')
        WHERE RESPONSIBILITY_NAME = '&resp_name');
  3. Execute the APPS_INITIALIZE function to authorize the user:
      1. exec FND_GLOBAL.APPS_INITIALIZE (user_id, resp_id, appl_id, security_group_id );
  4. Run any sql, result will based on result you get when u see it through Oracle Applications.