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
Sim Siew Poon said on July 25, 2011
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