Search Results icx_web_store_options




Overview
Explore in AI Chat

Overview

The ICX_WEB_STORE_OPTIONS table is a core configuration table within the Oracle iProcurement (ICX) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as the primary repository for default system-level settings that govern the behavior of the Web Store (also known as the Punchout or iProcurement Catalog) for each operating unit. This table is essential for establishing the foundational procurement rules and catalog experience, enabling organizations to define critical defaults such as pricing, order sourcing, and item categorization that apply to all requisitions created via the Web Store interface.

Key Information Stored

The table stores configuration values keyed by the operating unit identifier (ORG_ID). Based on its documented foreign key relationships, the most significant columns include ORG_ID (the primary key), PRICE_LIST_ID, GUEST_PRICE_LIST_ID, ORDER_SOURCE_ID, ORDER_TYPE_ID, NON_SHIPITEM_ID, and CATEGORY_SET_ID. These columns hold foreign key references to other EBS entities, linking the Web Store configuration to standard price lists from Order Management (SO_PRICE_LISTS_B), order types and sources, a specific non-shippable item from Inventory (MTL_SYSTEM_ITEMS_B), and a category set for item classification (MTL_CATEGORY_SETS_B). This structure centralizes the mapping between iProcurement's Web Store and the broader financial and logistics setup of the EBS instance.

Common Use Cases and Queries

A primary use case is troubleshooting catalog or pricing issues by verifying the configured defaults for a given operating unit. Database administrators and functional consultants often query this table to audit or validate setup. A typical diagnostic query would join to referenced tables to display meaningful names:

  • SELECT iwso.org_id, hou.name operating_unit, pl.name price_list, ot.name order_type FROM icx_web_store_options iwso JOIN hr_operating_units hou ON iwso.org_id = hou.organization_id JOIN so_price_lists_b pl ON iwso.price_list_id = pl.price_list_id JOIN so_order_types_tl ot ON iwso.order_type_id = ot.order_type_id AND ot.language = USERENV('LANG') WHERE iwso.org_id = :org_id;

Another common scenario involves data fixes or migrations, where values in this table may need updating if referenced objects like price lists are changed. Reporting use cases focus on ensuring configuration consistency across multiple operating units.

Related Objects

The ICX_WEB_STORE_OPTIONS table has defined foreign key relationships with several critical EBS tables, making it a central hub for Web Store configuration. As per the metadata, key related objects include SO_PRICE_LISTS_B (for standard and guest user price lists), SO_ORDER_TYPES_115_ALL (for the default order type), SO_ORDER_SOURCES_115 (for the order source), MTL_SYSTEM_ITEMS_B (for the non-shippable item identifier), and MTL_CATEGORY_SETS_B (for the catalog category set). These relationships enforce data integrity and ensure that the Web Store operates with valid, existing master data from the Order Management and Inventory modules. The table is primarily managed and accessed through the iProcurement application's own administrative forms and underlying PL/SQL APIs.