Oracle iStore - Frequently Asked Questions (FAQ)

1. Cart Vs Quote
A cart / quote contains products that you have configured and/or the spare models that you have added to the shopping cart in the web store. The basic difference between a cart and a quote is that a quote has been through the Sales Assistance process.

2. Where is current active cart information stored ?
IBE_ACTIVE_QUOTES_ALL table will have details of active cart for each user

3. When an Item is added to the cart, what will happen in background ?
Cart will be created in ASO_QUOTE_HEADERS_ALL table with status_code as 'iStore Draft'

4. When a Cart is converted Quote ?
Incase if a cart is requested for sales assistance, new version of cart will be created in ASO_QUOTE_HEADERS_ALL with status_code 'Draft'

5. How to remove the checkout button
Remove the permission - IBE_CHECKOUT and IBE_CREATE_ORDER

6. Incase if an item is not visible after adding to the catalog, what would be the problem ?
Verify the Item web properties orderable on web and published flag enabled in the item master

7. What is the process to customize the jsp in iStore ?
i. Copy the jsp and rename it to the custom name
ii. Do the changes and copy back to $COMMON_TOP/html
iii. Map the Jsp source file in the display manager template

8. What are basic tables affected when we create a cart / quote ?

i. ASO_QUOTE_HEADERS holds Order Capture quotation information. it has the header data of a quote. For each quote header, there can zero or many quote lines attached to it

ii. ASO_QUOTE_LINES_ALL stores information for a typical quote or an order line. This includes the item, item organization, unit of measure, quantity ordered, price list etc. The ITEM_TYPE column specifies what kind of item is quoted for this line. Each quote line can have zero or many detail lines in ASO_QUOTE_LINE_DETAILS_ALL, which stores specific line information about certain item types (e.g. service, configuration details)

iii. ASO_QUOTE_LINE_DETAILS_ALL stores information specific to certain types of quote lines. This includes service related attributes, model/option related attributes and return related attributes

iv. ASO_LINE_RELATIONSHIPS links one quote line to another and records the type of relationship. The reciprocal flag indicates if the relationship is bidirectional

v. ASO_HEADER_RELATIONSHIPS links one quote to another and records the type of relationship. The reciprocal flag indicates if the relationship is bidirectional.

vi. ASO_QUOTE_LINE_ATTRIBS_EXT to extend the more attribute fields

vii. ASO_PRICE_ATTRIBUTES stores information on qualifiers and pricing attributes, which the corresponding price adjustment line qualified for.

viii. ASO_PRICE_ADJUSTMENTS stores price adjusment details

ix. ASO_TAX_DETAILS stores quotes tax details

x. ASO_PAYMENTS holds payment related information for the quote

xi. ASO_SHIPMENTS store shipping information for a quote at header level or line level. At header level means the shipping information is the same for all the quote lines, therefore the quote_line_id is null. At line level means each line has its own shipping information. At line level, it can further break down at line quantity level if the quantity in ASO_SHIPMENTS is different than in ASO_QUOTE_LINES_ALL.

xii. ASO_QUOTE_RELATED_OBJECTS stores the relationship between a quote or a quote line to any entity in the schema and records the type of relationship. The OBJECT_TYPE_CODE defines the type of entity the quote or quote line is related to, and the OBJECT_ID is the unique identifier of the related object.

xiii. ASO_QUOTE_STATUSES_B stores the pre-defined and user-definable statuses for a quote header or a quote line

xiv. IBE_QUOTE_ACCESS stores information about who can share the Shopping cart (Quote). The information stored also include Update Privileges to be given to the sharee.

9. What are the required Inventory Flags for Oracle iStore Products ?
* Web Status Flag - Set this flag to Published in Inventory Master Form, Web Option tab - Published / Unpublished
* Orderable on the Web - Select the checkbox in Inventory Master Form, Web Option tab
* Customer Orders Enabled - Set the flag orderable by customer in Inventory Master Form, OM tab
* OE Transactable - Set this to Yes in order managment attributes group