ICX Tables (146)

ICX - Oracle iProcurement — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
ICX_AUDIT 31 Web transactions audit table
ICX_CART_DISTRIBUTIONS 38 Web Requisitions headers distribution table
ICX_CART_LINE_DISTRIBUTIONS 64 Web Requisitions lines distribution table
ICX_CATG_DETLS_INFO 39 Category details display attributes
ICX_CATG_DETLS_INFO_TL 9 Translation table for category marketing text
ICX_CAT_ADV_SRCH_SETUP 8
ICX_CAT_BROWSE_TREES 11
ICX_CAT_CATEGORIES_TL 25 Categories Table
ICX_CAT_CATEGORY_ITEMS 11
ICX_CAT_DELETED_ATTRIBUTES 9
ICX_CAT_DESCRIPTORS_TL 37
ICX_CAT_EXT_ITEMS_TLP 164 Stores category attribute values.
ICX_CAT_ITEMS_B 20
ICX_CAT_ITEMS_CTX_TLP 14
ICX_CAT_ITEMS_TLP 339
ICX_CAT_ITEM_PRICES 46
ICX_CAT_ITEM_SRC_DETAILS 10
ICX_CAT_POPULATE_CTX_GT 26
ICX_CAT_PRICE_HISTORY 32
ICX_CAT_PRICE_LISTS 24
ICX_CAT_SCHEMA_VERSIONS 11
ICX_CAT_STORES_B 8
ICX_CAT_STORES_TL 12
ICX_CAT_STORE_CATALOGS 10
ICX_CAT_UPLOAD_IT_DUMP 500
ICX_CAT_UPLOAD_PRICE_DUMP 28
ICX_COLORS 3 Color standards table
ICX_CONTEXT_RESULTS_TEMP 5 ConText queries table
ICX_CUSTOM_MENU_ENTRIES 18 Contains menu entries which user can access
ICX_ENABLED_PLSQL 9
ICX_FAILURES 9 Web Store failures table
ICX_ITEM_DETLS_INFO 37 Item details display attributes
ICX_ITEM_DETLS_INFO_TL 9 Translation table for item marketing text
ICX_MARGIN_ANALYSIS 12 Margin analysis by different categories for different periods
ICX_MARGIN_ANALYSIS_ERR 6 Stores failing record while building ICX_MARGIN_ANALYSIS table
ICX_OE_CARTS 15 Obsolete
ICX_OE_CART_ERRORS 8 Obsolete
ICX_OE_CART_LINES 16 Obsolete
ICX_PAGES 15 Defines all pages information of each PHP user
ICX_PAGES_TL 10 Translation tabe of ICX_PAGES
ICX_PAGE_COLORS 7 - Retrofitted
ICX_PAGE_COLORS_TL 8 - Retrofitted
ICX_PAGE_COLOR_SCHEME 11 - Retrofitted
ICX_PAGE_PLUGS 15 Defines plugs of a page
ICX_PANEL_SUMMARY 55 Customer summary including orders, returns, cancellations, and service requests
ICX_PARAMETERS 13 Setup information table
ICX_PORTLET_CUSTOMIZATIONS 13
ICX_POR_BATCH_JOBS 31 Holds information about submitted catalog batch processes.
ICX_POR_BUGSEYE_CONFIG 4 Controls the look and feel of Bugseye.
ICX_POR_BUGSEYE_FLAGS 2 Table stores flags for BugsEye system.
ICX_POR_BUYER_APPROVAL_JOBS 5 Holds detail information on Buyer Pricing Approval/Rejection batch processes.
ICX_POR_CATALOG_ATTACHMENTS 11 Table for storing Catalog Attachments
ICX_POR_CATEGORIES_TL 23 Stores information about the categories that exist within a catalog. Categories are used to classify items into groups of related items.
ICX_POR_CATEGORY_DATA_SOURCES 13 This table stores a list of external category data sources.
ICX_POR_CATEGORY_DEFAULTS 3 Stores category default values
ICX_POR_CATEGORY_ITEMS 2 Intersection table creating a relationship between categories and all the items they contain.
ICX_POR_CATEGORY_ORDER_MAP 8 Mapping of internal categories to external categories.
ICX_POR_CONFIG_PARAMETERS 7 Stores configuration parameters.
ICX_POR_CONTEXT_POLICY 5 Store context policies.
ICX_POR_CONTRACT_REFERENCES 13 Stores contract information for loader job
ICX_POR_CTX_TL 40 ICX_POR_CTX_TL is created for Advanced Search capabilities. The table implements the 'detail-datastore' for intermedia index. This table
ICX_POR_DAILY_NOTIFICATIONS 4 Table to store the Daily Notifications generated due to Publishing or Discarding of Item Loader Jobs and due to Approval or Rejection of pri
ICX_POR_DESCRIPTORS_CACHE 23 Table to implement Caching in the Base Attributes creation and management. This table has been designed to give the operator a facility to d
ICX_POR_DESCRIPTORS_TL 35 Stores information about descriptors associated with a given category. Root descriptors are associated with the category ID of zero.
ICX_POR_EXT_QUERY 14
ICX_POR_EXT_QUERY_TL 16 Stores named extended queries or a URL for an item.
ICX_POR_FAILED_ATTACHMENTS 5 Stores information relative to rejections that may occur during loading of attachments.
ICX_POR_FAILED_LINES 10 Maintains information about items/prices/schema elements that the loader rejected during a load job.
ICX_POR_FAILED_LINE_MESSAGES 9 Maintains information about items/prices/schema elements that the loader rejected during a load job.
ICX_POR_ITEMS 52 Stores information and root descriptors for non translatable data for each item in the catalog. Root descriptor columns are in the format A
ICX_POR_ITEMS_TL 57 Stores information and root descriptors for translatable data for each item in the catalog. Root descriptor columns are in the format Axxx
ICX_POR_ITEM_CONSTRAINT 3 Stores the information about Item Constraint.
ICX_POR_ITEM_CTX_INDEX 8 This table tracks which of the 2 indexes is currently available
ICX_POR_ITEM_SITE 2 Stores information about item Site.
ICX_POR_ITEM_SOURCES 36 Stores information about Catalog content sources. Associated with the Item Source form.
ICX_POR_ITEM_SOURCES_TL 11 Translation table for ICX_POR_ITEM_SOURCES.
ICX_POR_LOADER_VALUES 25 Stores a single record with the setup data for the Extraction process.
ICX_POR_LOAD_ITEM_MATCH 3 Table defines criteria for determining item uniqueness.
ICX_POR_LOG 6 Internal audit table for editing tools.
ICX_POR_ORACLE_ITEM_SUBTABLE 27 Stores Oracle-specific reference information about a Catalog item.
ICX_POR_PRICE_LISTS 25 Stores price lists information. There is 1 price list per buyer/supplier combination.
ICX_POR_PRICE_LIST_LINES 42 Stores price list lines information.
ICX_POR_PRICE_LIST_LINES_CACHE 18 Cache table for price list lines information.
ICX_POR_REALMS 7 Stores information about realms.
ICX_POR_REALMS_TL 10 Translation table for ICX_POR_REALMS.
ICX_POR_REALM_COMPONENTS 8 Stores information about realm components.
ICX_POR_SEARCH_CONFIG 3 Stores search configuration information.
ICX_POR_SEARCH_CONFIG_POLICY 4 Stores search configuration policy information.
ICX_POR_SITE 3 Stores site information.
ICX_POR_TABLE_OF_CONTENTS_TL 14 Stores the user-defined hierarchical relationship between navigational categories to create a more traditional hierarchical view of the cata
ICX_POR_TEMPLATE_FILES 4 Stores information for template files.
ICX_POR_THIRD_PARTY_LOGS 19 Table that stores historical data of Third Party Content Provider activity on Suppliers' catalogs.
ICX_POR_THIRD_PARTY_LOG_VALUES 9 Table to store detail log information of the Third Party Authoring changes performed on behalf of Suppliers for Items and Prices.
ICX_POR_TITLE_ADMIN 11 Stores information about the titles (supplier catalogs).
ICX_POR_TITLE_ADMIN_TL 17 Stores information about the titles (supplier catalogs).
ICX_POR_TITLE_REGISTRY 11 Stores title registry information.
ICX_POR_UNIT 5 This table enables you to associate units with a descriptor (like a UOM).
ICX_POR_UNSPSC_CODES 8 Contains a complete listing of the UNSPSC commodity codes.
ICX_POR_UPLOADER_SUBTABLE 6 Temp Information for uploader
ICX_POR_UPLOAD_IT_DUMP 345 Internal table used to store temporary data during an item/price bulk load job
ICX_POR_VERSION_INFO 4 Version tracking table for internal use.
ICX_PO_REVISIONS_TEMP 19 Comparison results of two revisions of a PO
ICX_PROCUREMENT_SERVER_SETUP 9 Connection information for an external Catalog source
ICX_PROMPTS 1 Dummy prompt object
ICX_QUESTIONS 8 Defines question information for Asking Oracle plug
ICX_QUESTIONS_TL 9 Translation table of ICX_QUESTIONS
ICX_QUESTION_FUNCTIONS 9 - Retrofitted
ICX_REGIONS 15 Defines region information of a Self-Service Web Applications page.
ICX_RELATED_CATEGORIES 9 Table used to define category hierarchies
ICX_REQUISITIONER_INFO 12 TPN Requisitioner Parameters Table
ICX_REQ_CART_ERRORS 10 Web Requisitions errors table
ICX_SESSIONS 41 Session context table
ICX_SESSION_ATTRIBUTES 3 Session context table
ICX_SHOPPING_CARTS 40 Web Requisitions headers table
ICX_SHOPPING_CART_LINES 55 Web Requisitions lines table
ICX_STORE_INDEX 7 Web Store Index table
ICX_TEMPLATE_TAGS 10 Template tags table
ICX_TEXT 4 Parameter encryption table
ICX_TRANSACTIONS 17 Not used in Exchange Catalog.
ICX_UNSPSC_CODES 2 Contains information of the UNSPSC commodity codes.
ICX_USER_PROFILES 10 Obsolete
ICX_VERSIONS 2 Current version table for Oracle Self Service Web Applications
ICX_WEB_STORE_OPTIONS 34 Default values for Web Store system configurable options per operating unit
POR_CONFIGURABLE_USER_DATA 9 User Configurable Data
POR_CONTAINER_IMAGES 4 Container images
POR_EMPLOYEE_LOADER_VALUES 23 Employee information populated by loader
POR_FAVORITE_LIST_HEADERS 27 Headers Table for implementing favorite lists
POR_FAVORITE_LIST_LINES 66 Table for storing items added to favorite lists.
POR_FAV_CHARGE_ACCOUNTS 12 This table stores the information about the account preferences
POR_FEED_FIELD_FORMATS 15 Field formatting definitions per procurement card issuer
POR_FEED_HISTORY 13 Run-time parameter values for the PO History Feed program
POR_FEED_RECORDS 34 PO distribution records
POR_IMAGES 4 Images
POR_IMAGE_LANG_SETTINGS 8 Image language setting
POR_ITEM_ATTRIBUTE_VALUES 24 Item attribute values
POR_LOCATION_LOADER_VALUES 29 Location information populated by loader
POR_LOV_DISPLAY_RESULTS 108 LOV display results
POR_LOV_RESULT_VALUES 108 LOV result values
POR_TEMPLATE_ASSOC 24 Self-Service Purchasing Information Template
POR_TEMPLATE_INFO 24 Self-Service Purchasing Information Template Data
POR_USER_DATA_CONF_LIST 7 User data configuration list
POR_USER_DATA_CONF_LIST_ITEMS 8 User data configuration list items
POS_ACK_SELECT 31
POS_ASN_SEARCH_RESULT 27
POS_ASN_SHOP_CART_DETAILS 68
POS_ASN_SHOP_CART_HEADERS 60