Summary:
Oracle iStore enables the creation and maintenance of high quality web stores which is based on Oracle Database with full integration 
with Oracle E-Business Suite 11i. Since Oracle iStore has look and feel of a website, it allows easier collaboration with customers, suppliers,
distributors etc. Oracle iStore is fully integrated with Oracle Order Management. Oracle iStore use Java Server Pages (JSP) technologies
to implement web features. Using same product database based on Oracle inventory, Oracle iStore provides development of different
websites for different customers.
Oracle iStore Overview:
Oracle iStore consists of two distinct but integrated user interfaces viz. Administrative Application and Customer Application
Administrative Application is used for :
- Create Unlimited Number of Sites
- Setup Pricelists, Shipping Methods etc.
- Build Product Catalog using Oracle Inventory
- Change site look and Feel by selecting different Section Templates and Product Display Templates
- View and Configure Workflow notifications
- View Business and Operational Reports
Customer Application is full web based Shopping Application. It has various features viz.
- Online shopping and orders processed into Oracle Order Management
- Saves and Share Carts, Quotes etc
- Track Orders
- Cancel Orders
- Submit Return Orders
- Store and access user addresses and credit card data
Order iStore is an integrated part of E-Business Suite. It communicates with various Oracle EBS modules.
Oracle iStore Include following components:
- Business Objects- The schema for storing customer orders, product catalog and presentation element (IBE & ASO Database Schema)
- Runtime Services & APIs- These include PLSQL and Java based APIs which manipulate the Business Objects (Data)
- Configurable Customer Application Templates- All customer application menus and pages are customizable using logical template names
- Processing and Routing Templates- In combination with display templates, these templates contain logic and appropriate business flows
- Oracle BLAF (Browse Look And Feel) compliant user interface for Administrative and customer application
Mandatory Modules for Oracle iStore
Oracle Receivables: AR is need to acces Customer and related information viz. Customer Details, Calculate Taxes, Generates Invoices
Oracle General Ledger: GL is needed for providing Business Unit Information to iStore and setting up of Chart of Account , Calendar, Currencies and Business Unit
Oracle Human Resources: HR Stores information related to organization and needed for tasks like setting up of Business Group, Locations, Legal Entities, Operating Unit, Employees, Bill-To and Ship-To Countries
Oracle Inventory: Stores all products (also called as items in inventory terminology)
Oracle Order Management- iStore is can be called as WEB based Order Management for Order capture. iStore uses OM to track and process customer orders and shipping details. iStore uses Order Capture APIs and Schema to communicate with OM. OM is required include setting of System Parameters, Transaction Types, Workflows, Order Number sequence, defaulting rules, flag shipping methods as web enables, payment types
Oracle CRM Technology Foundation -This must be implemented in order for iStore to work properly.
Important Responsibilities
Following responsibilities are needed to implement Oracle iStore
- iStore Administrator - Required for Setup content, section, site, templates etc
- iStore Concurrent Program Administrator-Required for Execute concurrent programs for data refresh
- IBE_CUSTOMER :-Required for Placing Orders using iStore website
- CRM HTML Administrator (with all available ROLES):-Required for Setting business users and associate them to appropriate receivables account, Create Roles
- Application Developer:- Required for Setting message codes and message text
- Application Developer Common Modules (AK_DEVELOPER):-Setup regions, region items/attributes used for Post Sales (Order Tracking)
Important Profiles
Profile Option Name | Value |
IBE:Category Set | Valid Value from LOV |
IBE:Item Master Organization | Valid Value from LOV |
MO:Operating unit | Valid Value from LOV |
IBE:Price Event For Shopping Cart | Batch Processing |
IBE:Create Order In Entered State if It has errors while Booking | Yes |
IBE:Shopping Event Before Shopping Cart | Enter Order Line |
IBE:Default Payment Term | Valid Value from LOV |
JTF_PROFILE_DEFAULT_APPLICATION | 671 |
|
|
JTF_PROFILE_DEFAULT_CSS | jtfucss.css |
|
|
JTF_PROFILE_DEFAULT_CURRENCY | USD |
JTF_PROFILE_DEFAULT_RESPONSIBILITY | 21819 (iStore Admin at Application Level) |
ASO:Automatic Numbering | Yes |
ASO:Credit Card Authorzation | Yes (if CC Allowed) |
ASO:Default Quote Status | Store Draft |
ASO:Default Order State | Booked |
ASO:Default Order Type | Mixed |
ASO:Default Sales Rep | No sales credit |
ASO:Enable TCA Changes | Yes |
ASO:OM Defaulting | Yes or No (based on OM Defaulting Rules) |
HZ:Generate Party Number | Yes (ApplicationLevel) |
HZ:Generate Party Site Number | Yes (ApplicationLevel) |
Sequential Numbering | Yes (Site Level) |
QP:Item Validation Organization | Valid Master Org |
ASO : ATP Default Customer | Valid Customer |
IBE: Retrieve Price When Displaying Items | Yes |
IBE: Use Price list associated with Specialty Site | Yes |
iStore Setup - Concurrent Programs
Login as iStore Concurrent Program Manager
Execute Following Concurrent Programs
- iStore Search Insert (To Populate iStore Item Search Table)- Generally executed only once or for complete refresh
- iStore Section Search Refresh (Can be executed multiple times)
iStore Setup - Web Server
Oracle iStore is a JSP based application hence there is a need of bouncing of Web Server for various occasions
- Setting up defaulting rules in order management
- Modifying text messages in oracle forms
- Modifying lookups in oracle forms
- Running Oracle Pricing Concurrent Programs, Building sourcing rules
- Adding new items to inventory as well as attribute changes
- Setting Site level profile options
- Setting up discoverer reports
- Applying Patches
Customer Application Display Components
iStore utilizes JSPs (java server pages) along with APIs to retrieve dynamic data along with static HTML data. iStore uses templates and other components to present customer application viz.Display Templates, Section and Product Hierarchy and Content - images and HTML content
iStore Setup- Catalog Creation
Login as with responsibility iStore Administrator using regular oracle applications link or using following URL
http://<Host Name>:<port>/html/jtflogin.jsp and use following steps to create a catalog
- Navigate to Catalog Tab to see Hierarchy.
- Click Section image in Accessories Section which is root section. This will create a new section and open up a page to set the various properties.
- Select Accessories as parent section and mark the Status as Published.
- Update other fields viz. Section name, Section Code, Description etc.
- There are Mandatory Product (inventory ) Attributes setup in Oracle inventory viz. Web Status Flag - Published, Orderable on web - Yes, OE Translatable - Yes, Customer Order Enabled- Yes.
- Similarly all iStore products should be present in pricelist used while iStore Site Creation setup and Order Management Workflow should be assigned to the order type used in iStore (order type profile option)
iStore Setup- Site Creation
Following few steps will create an iStore website.
- Click Sites tab at the top page
- Click Create Sites Button to open page 'Update Site Details" Update the Site Name, Description fields
- Set Default Language to "American English"
- Set Default Currency to "US Dollar"
- Set Walk-in Pricelist to "CKMS Pricelist" or any valid pricelist
- Set Catalog Root Section to Newly Created Section in previous slides
- Check all check boxes except (Restrict customer access by responsibility)
- Click Apply to save the changes
- Click Payment Link on LHS of update sites screen. Add the necessary payment type (invoice/credit card etc).
- Click Apply to save changes
- Click Shipment Link on LHS of update Sites Screen
- Add necessary Shipping methods
- Click Apply to Save the changes
- Click Responsibility link on LHS of Update Sites Screen and add IBE_CUSTOMER responsibility and click apply to save the changes
- Click Access Link on LHS and Select No Restrictions button and save the changes
iStore -Using iStore Customer Website
Browse the newly created iStore site using URL http://<host>:<post>/html/ibezhome.jsp and login using user id which has IBE_CUSTOMER responsibility, Add the Products to the Cart and Place the Order. After receiving Order Confirmation screen, Order will land in Oracle Order Management with Flow_Status_code as ENTERED or BOOKED based on iStore Setups. iStore JSPs internally call Order Capture APIs (ASO APIs) and ASO tables for transferring Order Information from iStore to Order Management.
iStore Customizations- Tips
- If User Interface requirements are not fulfilled by seeded templates the JSP customizations will be required.
- The new JSPs will be created based on seeded JSPs which will be attached to seeded Display Templates using Template Manager screen of iStore Administrative site
- To reflect any changes in JSPs, Item Attributes, Prices etc. Web server will have to be bounced.
- To view source code of class files used in JSPs developer needs to have following tools
- Java Decompilers e.g.DJ Java Decompiler 3.9, Jcavaj , JSP editor like JDeveloper or even text editor editplus is sufficient
- To get information about JSP is getting displayed (which is not necessarily same as jsp name in URL) while using iStore site, use following steps
- Copy the hard coded texts from JSP page e.g. field label etc.
- Login to Oracle Applications as Application Developer and navigate to message maintenance screen
- All hard codes labels/texts in iStore are store as Messages in Database with message code starting from IBE%
- Get the appropriate message code by querying messages screen
- Login to UNIX and change directory to $COMMON_TOP/html
- Use grep command to file given message code in iStore JSPs which will will give list of all JSPs containing given message code e.g.
- grep -l "IBE_YOUR_PRICE_COL" ibe*.jsp
Important Tables/Views in iStore
Table/View Name | Purpose |
IBE_DSP_ATTACHMENTS_V | Stores JSP names attached to various templates |
IBE_CT_IMEDIA_SEARCH | Product Search |
IBE_SECTION_SEARCH | iStore Section information |
IBE_DSP_SECTION_ITEMS | Sections and Associated Items |
IBE_MSITE_INFORMATION | iStore Site Information |
ASO_QUOTE_HEADERS_ALL | iStore Order Header |
ASO_QUOTE_LINES_ALL | iStore Order Lines |
ASO_SHIPMENTS | iStore Order Shipment information |
FND_NEW_MESSAGES | All iStore hardcode messages |
References
- Oracle Apps E-Business Suite 11.5.10 Documentation Library
- Various Metalink Notes
Apps2Fusion Articles 
Comments
So this overview really helpful to for more understanding. thank you.
regards panks
Your article is excellent & Informative.Tha nks prasad for putting efforts and sharing it.
I came across your site while trawling the net for help on istore (other than on Oracle). I am not a techy but assisting a developer with business requirements to set up our istore. Can you perhaps shed some light on a problem that we are having. We have two business orgs, magazines and newspapers, and their catalogues are on 2 different pages. this results in 2 shopping carts. Do you know how we can overcome this or will this need customization to get one cart which will contain both newspapers and magazines.
Than k you
Anwar
I really thank you for providing such an informative document on iStore.
Request you to share a BR100 document on any of your implementations on iStore which would be really helpful.
Thank s & Regards
Karthik
Can you share iStore BR100 and steps to configure the jsp page for User edition of iStore?
Regard s,
Preeth
Do you know if iStore has multiple modules? I am looking for a very simple functionality to be bolted on Oracle ERP to
enable customer to see stock availability, order status etc. (partner portal?) No desire to complicate needs by
implementing iStore as a whole.
Docume nt is really excellent and can be reffered before starting istore implementation.
Thanks
Mandar
Excell ent work on the document. I think this is the only document on the web that gives an overview from the developer's point of view.
Thanks,
Meghana
its really good documentation which you provide for us..
I have some doubts on iStore which we are going to implement for same store for different country..
Can you give me your gmail/yahoo id, so that I can explain you in better way..
Thanks in Advance..
Best Regards,
Ali
Th a
this is Suresh , i have on doubt, in iStore when we in Shopping cart page , we need to change the Price List id , which is coming form either from Store Price list id or Custom account price list id .. how do we achieve it .. i find one way , like through RequestCx.setCo okieValue() calss we can change .. but i don't know this one is correct way .
pl advice me , which is best way to change the default price list id when we in inside of iStore pages .
Thanks
Suresh ..
We are looking for some help / suggestion over the integration between istore and payment gateways.
How convinent / difficult is the integration?
Please share your comments at aksgtz
Thanks
Arun
Thanks for the informative article.
I have a requirement to get message/prompt translation in Oracle Istore. For e.g , Depending upon the user's preference, the messages,prompt s etc in istore application should appear in his language for eg Japanese,Spanis h etc.
Can you please let me know if oracle provides out of the box solution for the same ie some patch/pluggin etc on the application of which this kind of internationalis ation feature is enabled.
Thank s in Advance
Ravi.
Tanks and regards
Vmilla n
Mexico
Were you able to do cross-sell/up-s ell functionality in iStore? In release 12i up? Can iStore process the 3-digit security code for Credit card payment? Please let me know.
By the way, great document you have... simple indeed.
Thanks .
Prasad , i want to know some table name which all are will get update while we are doing the place order.. as i know two table one is ASO_QUOTE_STATU SES_B and ASO_ORDER_FEEDB ACK_T . still some other tables are will get updated during this process , can you help me to find this .
Thanks
Sures h
Does iStore support "shopping as a guest"? Or always needs a login?
Thanks,
Munish
Is it download able application ? or just a web site I can use it ?
help me please
thanks
I was looking for a help in istore
We have recently moved from R12.1.1 to R12.1.3. After this upgrade, when I login to any of the istore sites, am unable to see the products. In istore admin resp, the products are attached to sections and sections to site
Any navigation on the istore site, is not displaying the products/items
Any profile option/concurre nt program that can help?
These were displayed properly when we upgraded from 11i to R12.1.1
- Thanks
Deepika
I was looking for help on istore that is when I found this page . I have never worked on istore module but from here I got information on the module . Thanks for shari.ng the info .
We have a requirement of developing a validation framework to validate the data coming into order management from istore for this I need some info on how th order from istore is flowing into order management . If you could share some info on the same it will be really helpful.
Thank s and regards
Mary
Thanks for sharing the info .
I am working with I-Store for the first time and the requirement is to do some custom validationon the orders getting created in I-Store . Can u share some info on how I-Store and Order managemnt is getting integrated ? Any suggestion on how we can achieve the extra validations without much customization on the JSP on I-Store side .. may be if we can do more in Oracel order management side ?
Hope to see ur thoughts on the same.
My email id is paulson25
Thanks and Regards
Mary
I have just created a new section , added items to it and created a site with this section. But I am not able to see any items when I preview it. Any ideas what I could have missed?
Regard s,
Robin
Oracle E-Business Suite Release 12.1.1 Media Pack for Microsoft Windows . i m using Windows 7.
the files i downloaded initialy are Oracle E-Business Suite Release 12.1.1 Rapid Install Start Here (Part 1 of 4)
any help will be great
Deep
Thanks for the very informative blog. I am very new to Istore and currently trying to understand the functionalities and the technical aspects of the same. Is it possible to have a discussion with you.
I wanted to discuss with you to understand if there are any standard estimation tools available for estimating work on configuration, functional as well as technical changes for Istore
even if we cannot have a call, please help me provide any information with regards to any available estimation tool
Regards
M aqsood
98868441 20
Could you Please explain how to Integrate istore with yahoo store in 11i and R12?
Many thanks in advancce.
Aksh aya
nksjdzcvcxbnpdl nmg
RSS feed for comments to this post