External iSupplier User

We have faced a issue during our implementation, where the registered external isupplier users were not able to login to the portal.

When they log in, they get the 'Page not found error' though the POS: External URL has been set to external web server.

Later we found that setting up POS: External URL will not be sufficient and below are mandatory set ups to be performed to make external users to log in to the Supplier portal.


1. Set the profile option POS: External URL to:
http or https://(external web server machine):(port)/
2. Set the profile option POS: Internal URL to :
http or https://(internal web server machine):(port)/
3. After setting the above profile options

please run the following script using user APPS through sqlplus:
$POS_TOP/patch/115/sql/pos_upg_usr.sql
The above script updates the user level values of below profiles for all supplier users using the new values in the profile option POS: External URL

-> Applications Framework Agent
-> Application Web Agent
-> Apps Servlet Agent

Important : Every time the value of profile option POS: External URL is changed, it is necessary to run this script.

Oracle Apps - Quick How Tos

Q) How to find the Oracle Apps instance version ?
Ans - select RELEASE_NAME from fnd_product_groups

Q) How to find the Oracle Apps Database version ?
Ans - select version from v$instance

Q) How to find the hostname of an oracle apps instance ?
Ans - select host_name from v$instance

Q) How to find the instance name of an oracle apps instance ?
Ans - select instance_name from v$instance

Oracle iStore - Hide Tax Exemption

Oracle iStore determines whether to display the tax exempt part of the customer UI in the checkout billing pages based on the Oracle Receivables (AR) settings for Tax Exemptions at Customer level.

Release 11i

To disable the Customer Exemptions flag

Responsibility: Receivables Manager
Navigation: Setup > System > System Options
Go to the Tax Defaults and Rules Tab
Uncheck the "Use Customer Exemptions" field

Release 12

E-Biz Tax Module > Defaults and Controls > Select Operating Unit and Application Receivables > Application Tax Options
Uncheck the Allow overide and entry of Customer exemptions.

OA Personalization Migration

Steps to be performed at the Source Instance :

1. Set the profile option “FND: Personalization Document Root Path”.

The value of this profile option will be the directory name on mid-tier
Ensure that this directory exists on mid-tier machine of the destination environment and have proper read/write access.


2.Navigate to Functional Administrator Responsibility --> Personalization --> Import/Export.


3.Search the desired personalizations for the application name.

4.Extract the personalilzations.

5.Login to linux/unix mid-tier and cd to directory specified in profile option.

6.Do tar –cvf XXXOAPersonalizations.tar ./*

Steps to be performed at the Destination Instance :

1. Set profile option “FND: Personalization Document Root Path”.

The value of this profile option will be the directory name on mid-tier
Ensure that this directory exists on mid-tier machine of the destination environment and have proper read/write access.

2. FTP the XXXOAPersonalizations.tar to the directory specific in above profile option.


3.Cd to that directory

4.tar –xvf XXXOAPersonalizations.tar *****

5.Navigate to Functional Administrator Responsibility --> Personalization --> Import/Export

6. Select and Import the personalizations that have been imported.