Oracle iProcurement Tables

Oracle iProcurement module – List of database tables:

  • ICX_AUDIT
  • ICX_CART_DISTRIBUTIONS
  • ICX_CART_LINE_DISTRIBUTIONS
  • ICX_CATG_DETLS_INFO
  • ICX_CATG_DETLS_INFO_TL
  • ICX_CAT_ADV_SRCH_SETUP
  • ICX_CAT_BROWSE_TREES
  • ICX_CAT_CATEGORIES_TL
  • ICX_CAT_CATEGORY_ITEMS
  • ICX_CAT_DELETED_ATTRIBUTES
  • ICX_CAT_DESCRIPTORS_TL
  • ICX_CAT_EXT_ITEMS_TLP
  • ICX_CAT_ITEMS_B
  • ICX_CAT_ITEMS_CTX_TLP
  • ICX_CAT_ITEMS_TLP
  • ICX_CAT_ITEM_PRICES
  • ICX_CAT_ITEM_SRC_DETAILS
  • ICX_CAT_POPULATE_CTX_GT
  • ICX_CAT_PRICE_HISTORY
  • ICX_CAT_PRICE_LISTS
  • ICX_CAT_SCHEMA_VERSIONS
  • ICX_CAT_STORES_B
  • ICX_CAT_STORES_TL
  • ICX_CAT_STORE_CATALOGS
  • ICX_CAT_UPLOAD_IT_DUMP
  • ICX_CAT_UPLOAD_PRICE_DUMP
  • ICX_COLORS
  • ICX_CONTEXT_RESULTS_TEMP
  • ICX_CUSTOM_MENU_ENTRIES
  • ICX_ENABLED_PLSQL
  • ICX_FAILURES
  • ICX_ITEM_DETLS_INFO
  • ICX_ITEM_DETLS_INFO_TL
  • ICX_MARGIN_ANALYSIS
  • ICX_MARGIN_ANALYSIS_ERR
  • ICX_OE_CARTS
  • ICX_OE_CART_ERRORS
  • ICX_OE_CART_LINES
  • ICX_PAGES
  • ICX_PAGES_TL
  • ICX_PAGE_COLORS
  • ICX_PAGE_COLORS_TL
  • ICX_PAGE_COLOR_SCHEME
  • ICX_PAGE_PLUGS
  • ICX_PANEL_SUMMARY
  • ICX_PARAMETERS
  • ICX_PORTLET_CUSTOMIZATIONS
  • ICX_POR_BATCH_JOBS
  • ICX_POR_BATCH_JOB_DETAILS
  • ICX_POR_BROWSE_CATEGORIES
  • ICX_POR_BUGSEYE_CONFIG
  • ICX_POR_BUGSEYE_FLAGS
  • ICX_POR_BUYER_APPROVAL_JOBS
  • ICX_POR_CATALOG_ATTACHMENTS
  • ICX_POR_CATALOG_PREFERENCES
  • ICX_POR_CATEGORIES_TL
  • ICX_POR_CATEGORY_DATA_SOURCES
  • ICX_POR_CATEGORY_DEFAULTS
  • ICX_POR_CATEGORY_ITEMS
  • ICX_POR_CATEGORY_ORDER_MAP
  • ICX_POR_CONFIG_PARAMETERS
  • ICX_POR_CONTEXT_POLICY
  • ICX_POR_CONTRACT_REFERENCES
  • ICX_POR_CTX_TL
  • ICX_POR_DAILY_NOTIFICATIONS
  • ICX_POR_DESCRIPTORS_CACHE
  • ICX_POR_DESCRIPTORS_TL
  • ICX_POR_DOWNLOAD_JOB_DETAILS
  • ICX_POR_EXT_QUERY
  • ICX_POR_EXT_QUERY_TL
  • ICX_POR_FAILED_ATTACHMENTS
  • ICX_POR_FAILED_LINES
  • ICX_POR_FAILED_LINE_MESSAGES
  • ICX_POR_ITEMS
  • ICX_POR_ITEMS_TL
  • ICX_POR_ITEM_CONSTRAINT
  • ICX_POR_ITEM_CTX_INDEX
  • ICX_POR_ITEM_SITE
  • ICX_POR_ITEM_SOURCES
  • ICX_POR_ITEM_SOURCES_TL
  • ICX_POR_LOADER_VALUES
  • ICX_POR_LOAD_ITEM_MATCH
  • ICX_POR_LOG
  • ICX_POR_MANAGE_GROUPS_CACHE
  • ICX_POR_ORACLE_ITEM_SUB
  • ICX_POR_PRICE_BREAKS
  • ICX_POR_PRICE_HISTORY
  • ICX_POR_PRICE_LISTS
  • ICX_POR_PRICE_LIST_LINES
  • ICX_POR_PRICE_LIST_LINES_CACHE
  • ICX_POR_REALMS
  • ICX_POR_REALMS_TL
  • ICX_POR_REALM_COMPONENTS
  • ICX_POR_SEARCH_CONFIG
  • ICX_POR_SEARCH_CONFIG_POLICY
  • ICX_POR_SITE
  • ICX_POR__OF_CONTENTS_TL
  • ICX_POR_TEMPLATE_FILES
  • ICX_POR_THIRD_PARTY_LOGS
  • ICX_POR_THIRD_PARTY_LOG_VALUES
  • ICX_POR_TITLE_ADMIN
  • ICX_POR_TITLE_ADMIN_TL
  • ICX_POR_TITLE_REGISTRY
  • ICX_POR_UNIT
  • ICX_POR_UNSPSC_CODES
  • ICX_POR_UPLOADER_SUB
  • ICX_POR_UPLOAD_ITEMS_IT
  • ICX_POR_UPLOAD_IT_DUMP
  • ICX_POR_UPLOAD_PRICES_IT
  • ICX_POR_UPLOAD_PRICE_BREAKS_DP
  • ICX_POR_UPLOAD_PRICE_BREAKS_IT
  • ICX_POR_VERSION_INFO
  • ICX_PO_REVISIONS_TEMP
  • ICX_PROCUREMENT_SERVER_SETUP
  • ICX_PROMPTS
  • ICX_QUESTIONS
  • ICX_QUESTIONS_TL
  • ICX_QUESTION_FUNCTIONS
  • ICX_REGIONS
  • ICX_RELATED_CATEGORIES
  • ICX_REQUISITIONER_INFO
  • ICX_REQ_CART_ERRORS
  • ICX_SESSIONS
  • ICX_SESSION_ATTRIBUTES
  • ICX_SHOPPING_CARTS
  • ICX_SHOPPING_CART_LINES
  • ICX_STORE_INDEX
  • ICX_TEMPLATE_TAGS
  • ICX_TEXT
  • ICX_TRANSACTIONS
  • ICX_UNSPSC_CODES
  • ICX_USER_PROFILES
  • ICX_VERSIONS
  • ICX_WEB_STORE_OPTIONS
  • POR_CONFIGURABLE_USER_DATA
  • POR_CONTAINER_IMAGES
  • POR_EMPLOYEE_LOADER_VALUES
  • POR_FAVORITE_LIST_HEADERS
  • POR_FAVORITE_LIST_LINES
  • POR_FAV_CHARGE_ACCOUNTS
  • POR_FEED_FIELD_FORMATS
  • POR_FEED_HISTORY
  • POR_FEED_RECORDS
  • POR_IMAGES
  • POR_IMAGE_LANG_SETTINGS
  • POR_ITEM_ATTRIBUTE_VALUES
  • POR_LOCATION_LOADER_VALUES
  • POR_LOV_DISPLAY_RESULTS
  • POR_LOV_RESULT_VALUES
  • POR_TEMPLATE_ASSOC
  • POR_TEMPLATE_INFO
  • POR_USER_DATA_CONF_LIST
  • POR_USER_DATA_CONF_LIST_ITEMS
  • POS_ACK_SELECT
  • POS_ASN_SEARCH_RESULT
  • POS_ASN_SHOP_CART_DETAILS
  • POS_ASN_SHOP_CART_HEADERS

1 response to Oracle iProcurement Tables

  1. Hi Gurus,

    I have updated mtl_system_items_b.list_price_per_unit but in iProcurement what other columns or tables do I have to update.

    Will appreciate your advse.

    Best Regards,
    Siew Poon

Leave a reply

Your email address will not be published. Required fields are marked *