Oracle iStore - Browser Issue

One of my client’s user had problem in adding the product to the section through Sysadmin responsibility. When he clicks on the Add product icon (+), the pop up appears and he could be able to search for the product but when he selects the product and click on add, the pop page returns to the main page without adding the item to the section. There was no refresh as soon as the pop page closes.

Wherever he added something in the pop page, he faced this issue. To me , it looked like more of browser issue and he was able to perform the same action from some other system and browser.

So I have suggested the following action which resolved the issue.
Tools --> Internet options --> Programs --> Reset Web settings.

Which actually resets the web settings to default setting.

Oracle Apps – HTTP Trace

ieHTTPHeaders is an Explorer Bar for Microsoft Internet Explorer that will display the HTTP Headers sent and received by Internet Explorer as you surf the web.

This tool can be mainly used to understand the (HTTP) request that is being sent and the (HTTP) response received from the web server. The trace also helps to identify the basic cookies being set by the pages.

This is a generic tool and not specific to Oracle Applications, but can be mainly used to debug issues with self service page based modules in Oracle apps.

The trace has so many options where you can see all the included JSP or HTML files involved in the responses

You can download the recent version of the tool from the below link.
Download ieHTTPHeaders

Oracle OM – Advanced Pricing

We know Advanced Pricing has some additional features compared to Basic Pricing, but how do we say that either we are using Advanced pricing or Basic pricing.

When you have pricing module (QP) installed as shared then you are using only the limited functionalities of pricing - Basic pricing.
When you have pricing module (QP) installed as full then all the functionalities are available to you - Advanced Pricing.

How do I check whether QP is installed as Shared or Full?

Select status as “Installation Status” from fnd_product_installation where patch_level like '%QP%';

Oracle Apps – Debug method

Please find the below document drafted by me,I use the same procedure to debug all kind of error and warning messages in Oracle apps.
Message To Code Analysis

I hope this helps for you guyz as well.

If you have any issues in accessing the document, drop your mail in the comments so that I can mail you the document.

Oracle iStore – Cart to Quote

How do I convert my Shopping Cart to a Oracle Quote?

After adding items to the cart, click on the “Request for Salesrep Assistance” button to convert the shopping cart in to Quote. Then the Quote is assigned to a sales representative.

The “Request Salesrep Assistance” button is not always enabled in the checkout page, the profile IBE: Enable Salesrep assistance controls the display.

You should have Oracle Quoting integration to use this feature.

Oracle iStore - Clearing Cache

Understanding Cache : Cache is nothing but the compiled version of the JSP pages. All the JSP in the server are getting converted in to .java and .class file when compiled which is called as “Cache”. When you access the jsp files from the UI, the cache is getting invoked and not the JSP files.

When you modify an existing JSP files in Oracle iStore, the corresponding cache has to be cleared (deleted) to see the new changes. Clearing of cache is required even when you modify some of the .java files in iStore.

For 11i, the cache is stored under $COMMON_TOP/_pages, sometimes under
$COMMON_TOP/_pages/_oa__html, manual recompilation is not required to create the cache in 11i.

For R12, the cache is stored under $COMMON_TOP/_pages.
After clearing the cache, we have to recompile the JSP files manually since s_jsp_main_mode is set to justrun by default which is in turn updated in orion-web.xml.
To avoid manual compilation, the above parameter has to be set accordingly.

Caching clearance can be done from front end, steps as follows

Login as SYSADMIN Select "Functional Administrator" responsibility
Go to Core Services --> Caching Framework --> Tuning
Query the application (for example iStore) or by Name or code.
Select the component and clear the cache.

Oracle iStore – What is B2C , B2B and Guest User ?

Guest user – When the user is not logged in iStore, then you are treated as Guest user to browse the iStore sites.
The corresponding Guest user name is IBEGUEST. You can query the user in the Sysadmin-->User-->Define.

So to make iStore to work properly without logging in, you should have proper set up for the guest user otherwise you may hit an application error when you access the login page or Minisite lists page.

B2C : B2C is Business to Consumer user.
It is a user who is not tied to any organization and register themselves in iStore as “Register as an individual”
They are provided with Username and password to login iStore.

B2B: B2B is Business to Business User.
B2B users are always tied to some organization. They could be distributors or users of the organization. They register with the registry id of their organization.
Also a new organization can be registered using appropriate user types while registering.

What is registry id for B2B?
Registry id is nothing but the partner number of the organization.
Select partner_number as “Registry Id” from hz_parties where party_name like ‘’