About Oracle “Applications Start Page” Preference

“Applications Start Page” feature provides a user an option to set a particular page as his/her preferred start. The user will be taken to this page at login. A user can choose from the set of functions available under his/her responsibilities. The value is recorded in a profile option named “Applications Start Page (APPLICATIONS_START_PAGE)” as “functionId$$$respId$$$appId”.

Usage of the Feature

1. Make sure the profile “Self Service Personal Home Page Mode” is set to “Framework only” at site level or at user level for which user you intend to provide “Applications Start Page” feature.

2. Login to Applications as the End user.

3. Navigate to Preferences link on top of the page.

4. You can find a section “Start Page” under General Preferences page.  Select the Responsibility from which you would like to choose the Function (For e.g. Payables Super User). It then lists the functions available for this user under this responsibility.  Choose the Function as Start page (e.g, Invoices). Apply the changes.

5. Logout and Log back in. Your Start Page is now effective.

—————

After personalizing the ’start page’ to directly open a Form, how do I reset the User Preferences and the start page?

Disabling the Feature

1. When you are on Self-service Framework page, you can Navigate to Preferences Link and de-select the values (choose blank) for Responsibility and Page drop down lists.

2. When you are in Forms based Applications, navigate to menu  Edit => Preferences => Profile

3. Search for “Applications Start Page”, remove the value from User Value field and Save.

4. Next time when you login to Applications, you get Self-service Framework Homepage.

OR

After logging in, replace the login link with:
http://<initial part of path>/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE

This should get you to the Personal Home Page.

OR

Either use the Responsibility Hat to change to the System Administrator responsibility or Login as another user and have them use the System Administrator responsibility.

Then do a find for the Start Page profile option: Profile > System  for the User Name that is needing to reset their ‘Start Page’ profile.

Delete the start page for the user, save the changes.
This will allow the user to get back to the Personal Home Page, and then they can reset their ‘Start Page’.

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 : www.oracle.com ) 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.

OBTAINING ORG_ID AND SETTING CONTEXT
———————————————————
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
and then select $PROFILE_VALUES in block and then DEFAULT_PROFILE_VALUE or PROFILE_OPTION_VALUE as
field

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:
   1. 1. SELECT USER_ID,RESPONSIBILITY_ID,RESPONSIBILITY_APPLICATION_ID,
SECURITY_GROUP_ID
FROM FND_USER_RESP_GROUPS
WHERE USER_ID = (SELECT USER_ID
FROM FND_USER
WHERE USER_NAME = '&user_name')
AND RESPONSIBILITY_ID = (SELECT RESPONSIBILITY_ID
FROM FND_RESPONSIBILITY_VL
WHERE RESPONSIBILITY_NAME = '&resp_name');
3. Execute the APPS_INITIALIZE function to authorize the user:
   1. 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.