You are browsing the archive for Oracle iStore.

iStore Profile Options

Oracle iStore module profile options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
IBE_CATEGORY_SET IBE: Category Set
IBE_DEFAULT_SECTION_MEDIA IBE: Default Section Media
IBE_DEFAULT_ITEM_MEDIA IBE: Default Item Media
IBE_CACHE_PRELOAD IBE: Enable Preloading of Cache for Catalog
IBE_USE_SHOPPING_LISTS IBE: Use Shopping Lists
IBE_OM_PRICE_RECALCULATE IBE: Recalculate Price in Order Management
IBE_NUM_MENU_TABS IBE: Number of Menu Tabs
IBE_NUM_MENU_SUBTABS IBE: Number of Menu Subtabs
IBE_SC_MERGE_SHOPCART_LINES IBE: Merge Shopping Cart Lines
IBE_ORDTRK_CACHE_ENABLED IBE: Order Tracker Object Cache Enabled
IBE_USE_SECTION_BIN IBE:Use Section Bin
IBE_USE_SECTION_PATH IBE:Use Section Path
IBE_USE_FND_MENU IBE:Use AOL Menu for Customer UI
IBE_EMAIL_PROMOTIONS IBE:Email Promotions
IBE_USE_LINE_LEVEL_SHIP IBE:Use Line Level Shipping
IBE_USE_CONTRACTS IBE:Use Contracts
IBE_USE_DIRECT_ITEM_ENTRY IBE:Use Direct Item Entry
IBE_NUM_ORD_INV_ROWS IBE: Number of Invoice/Order Lines displayed
IBE_DEF_SALES_ASSIST_EMAIL IBE: Default Sales Assistant to Send Workflow Notification.
IBE_PREFERED_SHIP_METHOD IBE: Preferred Shipping Method
IBE_USE_CATALOG_EXCLUSIONS IBE: Use Catalog exclusions
IBE_USE_SUPPORT IBE: Use Item Level Service
IBE_CART_SUPPORT_DURATION IBE: Cart Level Support Duration
IBE_DEF_CONTRACT_TPL_NAME IBE: Default Contract Template Name
IBE_ITEMS_PER_SECTION IBE: Items Per Section for Display
IBE_USE_ONE_CLICK IBE:Use Express Checkout
IBE_USE_CD_PACKS IBE:Use CD Packs
IBE_USE_SUPPORT_CART_LEVEL IBE: Use Cart Level Service
IBE_USE_CATEGORY_SEARCH IBE:Use Category Search
IBE_DEF_ORDER_ADMIN_EMAIL IBE: Order Administrator for Booking Issues
IBE_PREFERED_SUPPORT_LEVEL IBE: Preferred Support Level for Shopping Cart.
IBE_USE_B2B_FEATURES IBE:Use B2B Features
IBE_USE_SHIPPING_INSTRUCTIONS IBE:Use Shipping Instructions
IBE_DEF_TERMS_CHG_EMAIL IBE: Default Request Terms Change User to Send Workflow Notification.
IBE_CDPACKS_SECTION_NAME IBE: Section Name for CD Packs Section
IBE_PRICE_REQUEST_TYPE IBE: Request Type to get a Price
IBE_PRECART_PRICING_EVENT IBE: Pricing Event — Before Shopping Cart
IBE_INCART_PRICING_EVENT IBE: Pricing Event for Shopping Cart
IBE_INCARTLINE_PRICING_EVENT IBE: Line Level Pricing Event for Shopping Cart
IBE_NOTIFICATION_USER_ROLE IBE: Notification User Role
IBE_DEFAULT_DISPLAY_CONTEXT IBE: Default Display Context
IBE_RESULTS_IN_SEARCH IBE: No of Results in Search
IBE_SEARCH_LINES_PER_PAGE IBE: Search Lines Per Page
IBE_TOP_NUMBER_OF_ITEMS IBE: Top Number of Items
IBE_OT_USE_CSI IBE: Use CSI Number in Order Tracker
IBE_SECURE_URL IBE: iStore Secure URL
IBE_PRELOAD_MINISITE_CACHE IBE: Preload Specialty Site Cache
IBE_FUZZY_SEARCH IBE: Enable Fuzzy Search
IBE_SEARCH_MIN_PREFIX_VALUE IBE: Search Mininum Prefix Value
IBE_USE_GLOBAL_BIN IBE: Use Global Bin
IBE_USE_LINE_TYPES IBE: Use Line Types
IBE_VIEW_CUSTOM_LINE_DETAILS IBE: View Custom Quote Line Details
IBE_USER_DEFAULT_AGREEMENT IBE: Default Pricing Agreement for the User
IBE_USE_WORKFLOW IBE: Use Workflow features in iStore
IBE_ENABLE_PARALLEL_PROCESSING IBE: Enable Parallel Data Extraction for Reporting
IBE_USE_NOTES IBE: Use Notes
IBE_USE_TASKS IBE: Use Tasks
IBE_DEBUG IBE: Enable Debug
IBE_USE_SHARECART IBE: Use Sharecart Functionality
IBE_MULTICAST_PORT IBE: Port Number to use for multicast messages
IBE_CREATE_STD_CONTRACT IBE: Create Standard Contract
IBE_USE_SHOP_LIST IBE:Use Shop List
IBE_NON_SECURE_URL IBE: iStore Non Secure URL
IBE_CURRENCY_CODE IBE: Currency Code
IBE_LINES_PER_SECTION IBE: Lines Per Section for Multiple Section Display
IBE_USE_WELCOME_BIN IBE: Use Welcome Bin
IBE_USE_SYNONYM_SEARCH IBE: Use Synonym Search
IBE_EOS_FILE_LOCATION IBE: EOS File Location
IBE_EOS_SHIP_CARRIER_CODE IBE: EOS Ship Carrier
IBE_ECR_BIN_USE_DEFAULT_PREFERENCE IBE: Use Default Bin Preference
IBE_EOS_ALLOW_APPROVE_CONTRACT IBE: EOS Allow Contract Approval
IBE_USE_B2B_AUTO_APPROVE IBE: Use Business User Auto Approval
IBE_ATTACHMENT_CATEGORY IBE: Attachment Document Category
IBE_DIAG_EMAIL_ADDRESS IBE: Email Address to send Diagnostic Messages
IBE_USE_WEB_CACHE IBE: Use Web Cache Feature
IBE_ORDER_LEAD_INTERVAL IBE: Order Lead Import Interval (In Days)
IBE_LEAD_EMAIL_ADDRESS IBE: Email Address For Lead Import Status
IBE_OT_WALKIN_SEARCH IBE: Enable Walkin Order Search in Order Tracker
IBE_USE_COMMITMENTS IBE: Use Commitments
IBE_EOS_DEFAULT_PRICE_LIST IBE: EOS Default Price List
IBE_ENABLE_FORCE_REFRESH IBE: Enable Force Refresh
IBE_EOS_DISPLAY_HOME_BINS IBE:EOS Display Home Bins
IBE_DEFAULT_LEAD_PROMO_CODE IBE: Default Sales Lead Promotion Code
IBE_ECR_PERIOD_SET_NAME IBE: GL Period Set Name
IBE_DEFAULT_PAYMENT_TERM_ID IBE: Default Payment Term
IBE_SC_PRICE_BASED_ON_OWNER IBE: Shopping Cart Price based on Owner
IBE_SC_EXP_DURATION IBE: Shopping Cart Expiration Duration
IBE_SC_PRICE_FROZEN_DURATION IBE: Shopping Cart Price Frozen Duration
IBE_SC_DAYS_FOR_EMAIL IBE: Days For Email
IBE_SECTION_TEMPLATE IBE: Default Section Template
IBE_ITEMS_PER_PAGE IBE: Items Per Page for Display
IBE_ITEM_VALIDATION_ORGANIZATION IBE: Item Validation Organization
IBE_CACHE_ON IBE: Cache On
IBE_ITEM_CACHE_SIZE IBE: Item Cache Size
IBE_ITEM_TEMPLATE IBE: Default Item Template
IBE_SECTIONS_PER_PAGE IBE: Sections Per Page for display
IBE_SC_MAX_SHOPPING_LISTS IBE: Maximum Number of Shopping Lists
IBE_SC_MAX_SAVED_CARTS IBE: Maximum Number of Saved Shopping Carts
IBE_SC_DE_ROWS_ADD IBE: Additional Table Rows
IBE_RESERVATION_PER_1CLICK IBE: Reserve Items On Every Express Checkout
IBE_1CLICK_ERROR_RETURN IBE: Express Checkout Error Behavior
IBE_1CLICK_CONSOLIDATION_TIME IBE: Express Checkout Consolidation Time Interval
IBE_ORDER_AUTH_PMT_OFFLINE IBE: Authorize Payment Offline during normal Checkout
IBE_ORDER_FINAL_ON_AUTH_ERROR IBE: Finalize Order On Error in Authorize Payment.
IBE_ORDER_CAPTURE_ON_DOWNLOAD IBE: Capture Payment for Downloadable products
IBE_SECTION_CACHE_SIZE IBE: Section Cache Size
IBE_PRICE_RETRIVAL_FLAG IBE: Retrieve Price When Displaying Items
IBE_DAYS_FOR_NEW_ITEM IBE: Number of Days for New Item Definition
IBE_GL_CONVERSION_TYPE IBE: GL Conversion Type
IBE_USE_LOGICAL_MEDIA_MENU IBE: Use Logical Media for Menu images
IBE_USE_QUOTE_PUBLISHING IBE: Use Quote Publishing
IBE_SHOW_CHANGE_STORE_LINK IBE: Show Change Speciality Store Link
IBE_EOS_MEDIA_LOCATION IBE: EOS Media Location
IBE_ECR_QUARTER_BEGIN_DATA IBE: Quarter Begin Data
IBE_USE_SPECIALTY_STORES_PAGE IBE: Use Specialty Sites Selection Page
IBE_USE_ADD_ITEM_BIN IBE: Use Add Item Bin
IBE_USE_OT_PAYMENTS IBE: Enable Payments in Order Tracker
IBE_USE_B2C_FEATURES IBE: Use Business to Customer Features
IBE_QUOTE_LEAD_INTERVAL IBE: Quote Lead Import Interval (In Days)
IBE_EOS_MINISITE_ID IBE: EOS Admin Specialty Store
IBE_USE_OT_INVOICES IBE: Enable Invoices in Order Tracker
IBE_CONTENT_BIN_URL IBE:URL to launch content bin
IBE_CONTENT_DYNAMIC_PARAM IBE:Dynamic content callback parameter
IBE_SEARCH_OPERATOR IBE: Search Operator
IBE_EOS_ALLOW_CLOSE_ORDER IBE: EOS Allow Close Order
IBE_THESAURUS_FILE_NAME IBE: Thesaurus File Name
IBE_ECR_USE_MV IBE: iStore Materialized views usage
IBE_FS_MEDIA_URL_PREFIX IBE: URL Prefix for Media in File System
IBE_TRUNC_RECORDS IBE: Truncate Records
IBE_USE_FAXCC_PMT_OPTION IBE: Use fax credit card as a Payment Option
IBE_ECR_YEARLY_DATA IBE: YTD data availability in Bins
IBE_SMTP_SERVER IBE: SMTP Server
IBE_ENTER_ORDER_ON_ERROR IBE: Create Order in Entered State, if it has errors while booking
IBE_RETRIEVE_ALL_ITEM_UOMS IBE: Retrieve All Units of Measure for an Item
IBE_USE_MINISITE_PRICELIST IBE: Use Price list associated with Specialty Site
IBE_USE_INVOICE_PMT_OPTION IBE: Use invoice as a Payment Option
IBE_USE_CALL_ME_BACK IBE: Use Call me Back
IBE_DEFAULT_MINISITE IBE: Default Specialty Site
IBE_USE_CABO_UI IBE: Use CABO UI
IBE_USE_SENSITIVE_PAGES IBE: Use Sensitive Pages
IBE_OT_USE_PERMISSIONS IBE: Use Auth Permissions in Order Tracker
IBE_USE_SALES_ASSISTANCE IBE: Use Sales Assistance Feature
IBE_USE_DB_FOR_MEDIA IBE: Use Database for Media Storage
IBE_DB_MEDIA_URL_PREFIX IBE: URL Prefix for DataBase Media
IBE_USE_POSTING IBE: Use Web Placements
IBE_REJECT_TERMS_FLOW IBE: Reject Terms and Conditions flow
IBE_USE_LINE_AGREEMENTS IBE: Use Line Agreements
IBE_LH_OTM_SERVER_GROUP IBE: Live Help OTM Server Group
IBE_EXP_ACTIVE_CART IBE: Active Cart Expiration Duration (# days)
IBE_USE_TERMS_REVIEW IBE: Enforce “Terms and Conditions” review by user
IBE_USE_JTA_USER_MANAGEMENT IBE: Use JTA User Management
IBE_LH_SITE_NAME IBE: Live Help Site Name
IBE_MANDATE_BILL_SHIP_CONTACT IBE: Mandate Contacts For Billing and Shipping
IBE_GSS_PAGE_COLUMNS IBE: Maximum Columns in Specialty Site Page
IBE_DISPLAY_ORDER_SORT_ALPHABETICALLY IBE: Display Specialty Store Selection in Alphabetical Order
IBE_USE_GSS_PICKER IBE: Use Specialty Site Picker
IBE_LH_QUEUE_REFRESH IBE: Live Help Queue Refresh Interval
IBE_CART_RETRIEVAL_BY_NO_FOR_B2B IBE: Cart Retrieval By Number For B2B
IBE_M_USE_CONTENT_INTEGRATION IBE: Use Content Management Integration
IBE_M_USE_ADV_PRD_SETUP IBE: Use Advanced Product Setup
IBE_M_NUM_DAY_EXPIRING IBE: Number of Days for Expiring Content
IBE_ENABLE_DISPLAY_ORDER_FEATURE IBE: Use Display Order Feature
IBE_USE_PROMOTION_CODE IBE: Use Promotion Code
IBE_LH_LIVE_HELP_URL IBE: Live Help URL
IBE_LH_OTM_SEVER_GROUP IBE: OTM Server Group
IBE_EXP_SAVE_CART IBE: Saved Cart Expiration Duration (# days)
IBE_DSP_LANG_LIST IBE: Display Language List in Specialty Store Page
IBE_OT_USE_CANCELORDER IBE: Enable Order Cancellation in Order Tracker
IBE_USE_ADDITIONAL_INFO IBE: Additional Shopping Cart Information
IBE_PROFILE_MENU_OPTION IBE: Profile Menu
IBE_QUICK_LINK_MENU_OPTION IBE: Quick Links Menu
IBE_USE_ORDER_TRACKER IBE: Enable Order Tracker Global Icon
IBE_USE_SHOPPING_CART IBE: Enable Shopping Cart Global Icon
IBE_USE_QUICK_SEARCH IBE: Enable Quick Search
IBE_USE_STORE_QUALIFIER IBE: Use Site As Pricing Qualifier
IBE_SEARCH_WEB_STATUS IBE: Web Status Filter for Product Search
IBE_SEARCH_CATEGORY_SET IBE: Category Set Filter for Product Search
IBE_ENABLE_RETURN_POLICY IBE: Enable Return Policy
IBE_ENABLE_RETURN_PREBOOK IBE: Enable Return Pre-booking Approval
IBE_ENCRYPTION_KEY IBE: Encryption Key
IBE_USE_ACCT_PRICE_LIST IBE: Use Customer Account Price List
IBE_M_ENABLE_DISPLAY_STYLE IBE: Enable Display Style
IBE_ENABLE_ERROR_LINKS IBE: Enable Links In Error Messages
IBE_RETAIN_CC_PREFS IBE: Retain Credit Card Preferences
IBE_UM_AUTO_GENERATE_PASSWORD IBE: Autogenerate Password
IBE_NUM_OF_PROD_COMPARE IBE: Maximum Number of Products to Compare
IBE_USE_OT_ADV_SEARCH IBE: Use Advanced Search in Order tracker
IBE_OT_VIEWBY_CUST_ORDERS IBE: View-By Customer Orders in Order Tracker
IBE_OT_ENABLE_B2C_UI IBE: Enable B2C User Interface in Order Tracker
IBE_DISPLAY_END_CUSTOMER_INFO IBE: Display End Customer Information
IBE_MANDATE_END_CUSTOMER IBE: Mandate End Customer
IBE_MANDATE_END_CUSTOMER_CONT IBE: Mandate End Customer Contact
IBE_MERCHANT_DUNS_NUMBER IBE: Merchant DUNS Number
IBE_ENABLE_PAY_NOW IBE: Enable Pay Now
IBE_ORDER_ADMIN IBE: Order Administrator
IBE_PERFORM_CC_AUTH IBE: Perform Payment authorization in iStore
IBE_SHOW_PRIVACY_STMT IBE:Display Privacy Statement
IBE_IB_VIEW_WEB_PUB_ITEMS IBE: View only web published items in Install Base
IBE_USE_INSTALL_BASE IBE: Use Install Base View
IBE_IB_AUTOQUERY_B2C_INSTANCES IBE: Autoquery Install Base for B2C Users
IBE_CART_RELATED_ITEMS_TYPE IBE: Relationship for Cart Related Items
IBE_MANDATE_BUSINESS_PHONE IBE: Mandate Contact Business Phone
IBE_CART_LEVEL_SUPPORT_LOOKUP IBE: Cart Level Service Lookup
IBE_SKIP_CHECKOUT_STEPS IBE: Skip checkout steps for order placement
IBE_ENABLE_RECURRING_CHARGES IBE: Enable Recurring Charges
IBE_DISPLAY_OPTION_CLASSES IBE: Display Option Classes in Shopping Cart & Order Tracker
IBE_ENABLE_URL_REWRITE IBE: Enable URL Rewrite
IBE_USE_SHOPPINGCART_UPLOAD OBSOLETE – IBE: Enable Shopping Cart Upload through Web ADI
IBE_WA_SC_LAYOUT_B2B OBSOLETE – IBE: ShoppingCart Upload WebADI Layout for B2B users
IBE_BNE_SC_LAYOUT_PARTNER OBSOLETE – IBE: ShoppingCart Upload WebADI Layout for Partner users
IBE_BNE_NUM_LOV_ROWS OBSOLETE – IBE: Maximum Number of rows in webADI excel LOV
IBE_USE_PROCUREMENT_PUNCHOUT IBE: Enable Procurement Punchout – OBSOLETED
IBE_BI_TOP_ACT_NO_ROWS IBE: DBI Top Activity Number of Rows
IBE_USE_DBI IBE: Use DBI
IBE_USE_CUST_SVC_EXCL IBE: Use Customer Service Exclusion
IBE_USE_RETURNS IBE: Use Returns
IBE_RETURN_TRANSACTION_TYPE IBE: Return Orders Transaction Type
IBE_ENABLE_MULT_SVC IBE: Enable Multiple Services
IBE_UPDATE_DRAFT_QUOTES IBE: Allow update for ‘Draft’ quotes
IBE_SC_MAX_DE_ROWS IBE: Maximum Direct Entry Rows

iStore Concurrent Programs

Oracle iStore Concurrent Programs

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
IBESERINS Concurrent Program to insert into Search table
IBEONECLK To scan thru quotes table and submit eligible Express Checkout orders.
IBEVMPAP iStore Product Autoplacement Program
IBESERSCT Concurrent program to refresh IBE_SECTION_SEARCH table.
IBEPURLOG Delete inactive records from IBE_ECR_MVLOG
IBEXUPPL Concurrent program to  Upload Price lists
IBEXDPPL Concurrent Program to Downloadt Price lists
IBEXUORD Concurrent program to  Upload Orders
IBEFACTREF iStore Reports Fact Tables Refresh
FNDRSSUB765 iStore Reports Data Refresh Set
IBEXDORD Current Program to Download Orders
IBEREFMV iStore Reports Materialized Views Refresh
IBEXDCAT Concurrent Program  Downdload catalog
IBEECRALERT iStore Reports Alerts
IBEXUCAT Concurrent Program Upload catalog
IBEORDLI Concurrent Program for Lead Import of iStore Orders
IBEXDCUS Concurrent Progarm Download Customer
IBEQTELI Concurrent Program for Lead Import of iStore Quotes
IBEVMOCM iStore Content Manager Integration Migration Program
IBE_BI_CART_ORD_REFRESH iStore DBI Cart and Order MV Refresh Program
IBE_BI_CART_REFRESH iStore DBI Carts MV Refresh Program
IBE_BI_CAT_REFRESH iStore DBI Categories MV’s Refresh Program
IBE_BI_CUST_MV_REFRESH iStore DBI New Customers MVs’ Refresh Program
IBE_BI_MSITE_MIG_PROG iStore Minisite Migration Program
IBE_BI_MSITE_REFRESH iStore DBI Minisite-Org MV Refresh Program
IBE_BI_ORDERBOM_REFRESH iStore DBI Orders Rolled up MV Refresh Program
IBE_BI_ORDERS_REFRESH iStore DBI Orders MV Refresh Program
IBE_BI_PRD_MV_REFRESH iStore DBI Products MV Refresh Program
IBE_BI_TOP_CARTS_REFRESH iStore DBI Top Carts MV Refresh Program
IBE_BI_TOP_CUST_REFRESH iStore DBI Topm Customers MV Refresh Program
IBE_BI_TOP_ORD_REFRESH iStore DBI Top Orders MV Refresh Program
IBEVMTEX iStore Template Mapping Export Program
IBEVMTIM iStore Template Mapping Import Program
IBEIBYFC To migrate Credit Card foreign key references for Primary Credit Cards and Express Checkout Preferences
IBEVSLAY Concurrent Program to Cascade Section Layout Mapping  to all children sections
IBEVSDUP Concurrent Program to Duplicate one Section

Oracle iStore Tables

Oracle iStore module – list of database tables:

  • IBE_ACTIVE_QUOTES_ALL
  • IBE_CT_IMEDIA_SEARCH
  • IBE_CT_RELATED_ITEMS
  • IBE_CT_RELATION_RULES
  • IBE_CT_REL_EXCLUSIONS
  • IBE_DSP_CONTEXT_B
  • IBE_DSP_CONTEXT_TL
  • IBE_DSP_LGL_PHYS_MAP
  • IBE_DSP_MSITE_SCT_ITEMS
  • IBE_DSP_MSITE_SCT_SECTS
  • IBE_DSP_OBJ_LGL_CTNT
  • IBE_DSP_SECTIONS_B
  • IBE_DSP_SECTIONS_TL
  • IBE_DSP_SECTION_ITEMS
  • IBE_DSP_TPL_CTG
  • IBE_ECR_BIN_FACT
  • IBE_ECR_MVLOG
  • IBE_ECR_ORDERS_FACT
  • IBE_ECR_ORDER_HEADERS_FACT
  • IBE_ECR_QUOTES_FACT
  • IBE_EOS_CP_LOG_LINES
  • IBE_EOS_THEMES_B
  • IBE_EOS_THEMES_TL
  • IBE_LEAD_IMPORT_DETAILS
  • IBE_LEAD_IMPORT_LOG
  • IBE_MIGRATION_HISTORY
  • IBE_MIGRATION_LOG
  • IBE_MSITES_B
  • IBE_MSITES_TL
  • IBE_MSITE_CURRENCIES
  • IBE_MSITE_INFORMATION
  • IBE_MSITE_LANGUAGES
  • IBE_MSITE_ORGS
  • IBE_MSITE_PRTY_ACCSS
  • IBE_MSITE_RESPS_B
  • IBE_MSITE_RESPS_TL
  • IBE_ORD_ONECLICK
  • IBE_ORD_ONECLICK_ALL
  • IBE_SECTION_SEARCH
  • IBE_SECTION_SEARCH_PART
  • IBE_SHP_LIST_ITEMS_ALL
  • IBE_SH_QUOTE_ACCESS
  • IBE_SH_SHLITEM_RELS
  • IBE_SH_SHP_LISTS_ALL
  • IBE_STORES_B
  • IBE_STORES_TL
  • IBE_WF_NOTIF_MSG_MAPS
  • IBE_WF_NOTIF_SETUP