How To Add A Help Icon To Internet Expenses Screens To Access User

Activate the personalize self-service definition system profile option and change the personalize region

The ‘Help’ button will appear in the personalize region screen

To show the help button in all iExpense screens

1) Define a Function say OIE_HELP


Maintenance Mode Support = None

Context Dependence = Responsibility

Form, Application, Parameters = blank

HTML call = <refer to step2 to build the url>

Secured = blank

Encrypt Parameter = blank

Host Name = blank

Agent = blank

Icon = email_greyscale.gif

Object, Region Application, Region Code = blank

2) The Url of the Function MUST be of format “;

Note: The Url MUST start with “Http://”, otherwise it is taken

as a relative url

To Define an absolute url, the url MUST start with Http://”

3) Attach the Function with any Menu Component
To add a global button attach it to the menu : OIE_EXPENSES_GLOBAL

4) Bounce Apache

How to remove / hide the ‘Edit Navigator’ button on the Homepage

The purpose of this button is only to provide the user a way to personalize (only show / hide) the list of responsibilities in the Navigator on his Homepage.

This button can be hidden using the following Personalization:

1. Enable Personalization by setting the System Profile option ‘Personalize Self Service Defn’ to ‘Yes’ at the required level
2. Navigate to the Homepage and click on the ‘Personalize Page’ link in the top right corner
3. Under ‘Personalization Structure’, click on the ‘Expand All’ link
4. Search for the item Name ‘Button: Edit Navigator’
5. Click on the ‘Personalize’ pencil icon against this item
6. In the resulting page, set the ‘Rendered’ property to ‘false’, at the required level
7. ‘Apply’ the changes and on the resulting page, ‘Return to Application’
8. The ‘Edit Navigator’ button is no longer visible

Please Note, this does not actually remove the button, but only hides it from the user and can be made visible by setting the ‘Rendered’ property to ‘true’, through Personalization if Personalization is enabled for the user.

Global Policy Link Does Not Open A New Browser Window

The Global Policy link is tied to a standard menu and not self-service menu. due to the standard menu definition, this link will never open a new browser window.
The coding for Global Policy link is using the AK format and not using new MDS (personalization)
format; which is why the link is not queryable using OA Personalizations in the OAFooter.xml.

To implement the solution, please execute the following steps:

1. Right click the Global Policy Link to open new in new window


2. Code your Global Policy page to call open.window, for example:




Thanks – Shiv

Oracle 11i/ R12 – Contact Us Link – in Internet Expenses

“A Contact Us global button is available so your users can submit questions or comments as necessary. To enable this feature, complete the following steps (from user guide):

1. Log into Oracle Applications using Application Developer responsibility.
2. Navigate to Application > Function.
3. Query the function OIE_CONTACT_US.
4. Select the Web HTML tab.
5. Enter the desired email address right after mailto: (no spaces) in the HTML Call field. The following example demonstrates the format of the email address:”

After completing the steps, log into Internet Expenses and navigate to Expense Entry. Click on the Contact Us link and this launches Outlook Express

Tips For Personalizing The E-Business Suite 11i Login Page (AppsLocalLogin)

You would like to personalize the AppsLocalLogin.jsp login page to add specific text, change the logo, etc. This document describes the supported and non supported methods to achieve one’s ends.

1. Attributes of the login page

It is possible to control the display of some attributes of the login page, for instance user name or password hints, language switchers, forgot password link, corporate policy message, etc. For this, you need to set the profile option ‘Local Login Mask’ (FND_SSO_LOCAL_LOGIN_MASK) with a number being the sum of the mask values described in the table below:

Description Mask value
Hint for Username (USERNAME_HINT) 01
Hint for Password (PASSWORD_HINT) 02
Cancel button (CANCEL_BUTTON) 04
Forgot Password link (FORGOT_PASSWORD_URL) 08
Registration link (REGISTER_URL) 16
Language Images (LANGUAGE_IMAGES) 32
Corporate Policy Message (SARBANES_OXLEY_TEXT) 64

* For instance the value 32 (default) displays only the language icons and value 127 will show all the attributes on the page. Please see the attached screen shots as an example. * The change takes effect immediately after re-login to E-Business Suite.

2. Message texts

It is possible to modify or add text on the login page by changing the value of some messages. The following table shows the related messages and their default value:

Description Default value
FND_SSO_COPYRIGHT_TEXT Copyright (c) 2007, Oracle. All rights reserved.
FND_SSO_SARBANES_OXLEY_TEXT Corporate Policy Message

To change the value of a message:

1. Go to “Application Developer” responsibility
2. Select “Messages” from the menu
3. Query  the message name and then enter your message text in the “Current Message Text” field
4. Save changes and exit
5. Clear cache and bounce Apache to see the change

* Note that some messages can be used elsewhere that in the login page and can be updated by a patch , * If you want to change also the default branding ‘E-Business Suite’ on other pages, to match the text on the login page (defined by FND_SSO_EBIZ_SUITE message),
then follow the steps below:

a. Login with System Administrator responsibility
b. Navigate: Application —> Function
c. Query the function ‘FWK_HOMEPAGE_BRAND’
d. Replace the value of the ‘User Function Name’ with the desired text
c. Logout and login to see the change (you shouldn’t need to clear caches and bounce apache)
* The ‘FND_SSO_SARBANES_OXLEY_TEXT’ message is only displayed when the mask

3. Corporate branding logo

The Oracle logo is displayed on various E-Business Suite pages and can be changed by setting the
‘Corporate Branding Image for Oracle Applications’  (FND_CORPORATE_BRANDING_IMAGE) profile option to the full path name of an image file (.gif) that contains your corporate image.

However it is not possible to use this method for AppsLocalLogin.jsp since it is hard coded with the Oracle logo image file ‘FNDSSCORP.gif’.
The non supported solution consists in:

1. Go to the $OA_HTML directory
2. Backup the AppsLocalLogin.jsp file
3. Copy your own corporate branding image under $OA_MEDIA directory
4. Edit the AppsLocalLogin.jsp file :

from :

ImageBean imgBean1 = new ImageBean(“/OA_MEDIA/FNDSSCORP.gif”, FND_ORACLE_LOGO);

to :

ImageBean imgBean1 = new ImageBean(“/OA_MEDIA/<your image file name>”, FND_ORACLE_LOGO);

5. Clear caches and bounce Apache to see the change

* If you prefer the same corporate branding logo be displayed on all pages, including the login page, then you can backup the FNDSSCORP.gif file and modify it with your prefered graphic software.

4. Other modifications

AppsLocalLogin.jsp being a Java Server Page you can change the HTML or Java code (for instance with JDeveloper), create you own messages in the Messages Dictionnary thru AOL responsibility, etc., if you want to add other customizations. This is considered a customization and thus not supported by Oracle. If you apply patches replacing AppsLocalLogin.jsp the file will be overwritten.

The Invoice does not go on Hold with “Quantity billed exceeds quantity received” when Matched to a Purchase Order

Reason could be : No Goods Tolerance has been setup in the supplier site.

When a PO is created for 3 or 4 way match there are no holds placed on the invoice when the items have not been received.

— Steps To Reproduce:
1) Create PO 3 or 4 way match
2) Quick match PO to invoice
3) Validate the PO
4) No holds are placed on the Invoice
5) Expected hold is ‘QTY REC’, “Quantity billed exceeds quantity received”

Invoices are being paid when items have not been received.

Follow the steps below.

1) Setup a Goods Tolerance: 
    a) Accounts Payable – Setup > Invoices > Tolerances

2) To default the Goods Tolerance to suppliers:
    a) Accounts Payable – Setup > Options > Payables – Supplier tab
    b) Select the Goods Tolerance from step 1 
    c) This will now default to new suppliers created

3) For existing suppliers:
    a) Accounts Payable – Supplier > Query
    b) Go to the Supplier Site
    c) Go to the Controls tab
    b) Select the Goods Tolerance setup in step 1

To determine which supplier sites do not have a Goods Tolerance run the following select:
select vendor_name, vendor_site_code, s.creation_date date_site_created, s.created_by site_created_by, tolerance_id, vendor_type_lookup_code
from po_vendor_sites_all s, po_vendors v
where v.vendor_id = s.vendor_id
and tolerance_id is null
and nvl(inactive_date,sysdate + 1) > sysdate
and nvl(end_date_active,sysdate + 1) > sysdate
and pay_site_flag = ‘Y’
and purchasing_site_flag = ‘Y’
order by 1;

Dale Carnegie – Golden Rules for Success

Become a Friendlier Person
1. Don’t criticize, condemn or complain.
2. Give honest, sincere appreciation.
3. Arouse in the other person an eager want.
4. Become genuinely interested in other people.
5. Smile.
6. Remember that a person’s name is to that person the sweetest and most
important sound in any language.
7. Be a good listener. Encourage others to talk about themselves.
8. Talk in terms of the other person’s interests.
9. Make the other person feel important – and do it sincerely.

Win People to Your Way of Thinking
10. The only way to get the best of an argument is to avoid it.
11. Show respect for the other person’s opinion. Never say, “You’re wrong.”
12. If you are wrong, admit it quickly and emphatically.
13. Begin in a friendly way.
14. Get the other person saying “yes, yes” immediately.
15. Let the other person do a great deal of the talking.
16. Let the other person feel that the idea is his or hers.
17. Try honestly to see things from the other person’s point of view.
18. Be sympathetic with the other person’s ideas and desires.
19. Appeal to the nobler motives.
20. Dramatize your ideas.
21. Throw down a challenge.

Be a Leader
22. Begin with praise and honest appreciation.
23. Call attention to people’s mistakes indirectly.
24. Talk about your own mistakes before criticizing the other person.
25. Ask questions instead of giving direct orders.
26. Let the other person save face.
27. Praise the slightest improvement and praise every improvement. Be “hearty in your
approbation and lavish in your praise.”
28. Give the other person a fine reputation to live up to.
29. Use encouragement. Make the fault seem easy to correct.
30. Make the other person happy about doing the thing you suggest.