Oracle iStore - Quick How To Part 1

Q1. How to get Error stack for the Application Error message from the iStore customer UI?

Option 1: Right click on the Application error screen and select the view source from the options available.
Option 2: Click on View from the browser menu and select source.

Q2. What if the error stack is not available for the Application error?

Make ensure that the profile FND: Debug Log Enabled is set to Yes.

Q3. How to get the Template Name for the associated JSP file?

Use the below query to get the Template name for the associated JSP file.
SELECT I.ACCESS_NAME, A.FILE_NAME FROM JTF.JTF_AMV_ATTACHMENTS A, APPS.JTF_AMV_ITEMS_VL I, IBE.IBE_DSP_LGL_PHYS_MAP M, IBE.IBE_MSITES_TL S WHERE A.ATTACHMENT_ID = M.ATTACHMENT_ID AND I.ITEM_ID = M.ITEM_ID AND M.MSITE_ID = S.MSITE_ID and a.FILE_NAME like 'Jsp file name here'

Same query can be little modified to get the File name from the Template name.

SELECT I.ACCESS_NAME, A.FILE_NAME FROM JTF.JTF_AMV_ATTACHMENTS A, APPS.JTF_AMV_ITEMS_VL I, IBE.IBE_DSP_LGL_PHYS_MAP M, IBE.IBE_MSITES_TL S
WHERE A.ATTACHMENT_ID = M.ATTACHMENT_ID AND I.ITEM_ID = M.ITEM_ID AND M.MSITE_ID = S.MSITE_ID and I.ACCESS_NAME like ‘template name here’

Q4. How to change the Company Logo in the Customer UI?
Map the template STORE_LOGO_MAIN with the desired image. The Mapping can be done in the iStore Administrator UI using the navigation iStore Admin UI --> Advanced --> Template Manager.

Q5. Query to get the Price list associated with the Order.
select distinct(name) from QP_LIST_HEADERS_TL where LIST_header_id = (select PRICE_LIST_ID from oe_order_headers_all where order_number = &Order_Number)