You are browsing the archive for Oracle iProcurement.

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

iProcurement Concurrent Programs

Oracle iProcurement Concurrent Programs

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
ICX_CUSTOMER_SUMMARY Program to launch Web Customer Summary executable for Customer Synopsis – Web Apps
ICXPOPUR Delete temporary data of PO revisions in Self-Service Applications
HRWFDFCT Complete Defunct HR Workflow Processes
POXCATRN Update Items For Category Rename
POXPARII Populate And Rebuild Intermedia Index
POXDIAPC Delete Items and Prices in a Category
POXMPCAT Map Oracle Purchasing Categories
POXDLDES Delete Descriptors
ICXCICRI Catalog Index Create – Intermedia
ICXELLDR Express Setup Tool
ICXRCIIP Rebuild Catalog interMedia Index
ICXPCIIP Purge Catalog interMedia Index
POXCATHRCH Update Local Zones For Category Hierarchy Change
POXSRCH Populate And Rebuild Intermedia Index For Searchable Change
ICXCUCDER Catalog Child Data Exceptions Report

iProcurement Profile Options

Oracle iProcurement module profile options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
POR_URGENT_FLAG_SHIPMENT_PRIORITY_CODE POR: Urgent flag maps to shipping Priority
POR_SYNC_NEEDBYDATE_OM POR: Sync up Need by date on IR with OM
POR_CONVERT_ONE_TIME_TO_STD_DOC POR: Convert One Time Document To Standard Document
POR_AUTO_LOAD_ROOT_DESC POR: Auto Load Root Descriptors
POR_DISPLAY_ITEM_ASL POR: Display Item ASL Entries in Search Results
POR_OVERRIDE_LOCATION POR: Override Location Flag
POR_SEARCH_RESULTS_SKIN POR : Search Results Skin
POR_DISPLAY_APPROVAL_GRAPH POR: Display Graphical Approval List
POR_OVERRIDE_REQUESTER POR: Override Requester
PROXY_USER_ID ICX: PROXY USER ID
POR_PURCHASING_NEWS POR: Purchasing News Location
POR_DISPLAY_SHOPPING_CAT_COUNT POR: Display Shopping Category Count
POR_DISPLAY_ADVANCED_SEARCH POR: Enable Advanced Search
POR_DAYS_NEEDED_BY POR: Days Needed By
POR_DEFAULT_SHOPPING_SORT_ORDER POR: Default Shopping Sort Order
POR_AUTO_CREATE_SHOPPING_CAT POR: Autocreate Shopping Category and Mapping
POR_LOAD_ONETIME_ITEM_ALL_LANG POR: Load One-Time Items in All Languages
POR_DEFAULT_SHOPPING_SORT POR: Default Shopping Sort
POR_AUTO_LOAD_SHOPPING_CAT POR: Auto Load Shopping Categories
POR_AUTO_LOAD_CATEGORY_DESC POR: Auto Load Category Descriptors
POR_REQ_ENFORCE_EXP_ACC_RULE POR: Apply Expense Account Rules to Favorite Charge Accounts
POR_CACHE_TTL POR: Cache Time To Live Minutes
POR_DEFAULT_EXP_ITEM_DATE_OFFSET POR: Preferences – Expenditure Item Date Offset
POR_CHECKOUT_DISPLAY_ACCOUNT POR: Generate and Display Account at Checkout
POR_APPRV_CONTRACTOR_ASSIGN POR:  Reapproval after Contractor Assignment
POR_REQ_HEADER_DFF_CONTEXT POR: Context value for Requisition header descriptive flexfield
POR_REQ_LINE_DFF_CONTEXT POR: Context value for Requisition line descriptive flexfield
POR_REQ_DIST_DFF_CONTEXT POR: Context value for Requisition distribution descriptive flexfield
POR_CONTRACTOR_EXPENSE_LINE_TYPE POR: Contractor Expense Line Type
POR_ENABLE_REQ_HEADER_CUST POR: Enable Req Header Customization
POR_DISPLAY_LEGACY_ACCOUNT_FLEX POR: Display Legacy Accounting Flex UI
ICX_EBS_EUL ICX: Discoverer EBS End User Layer Schema Prefix
ICX_EDW_EUL ICX: Discoverer EDW End User Layer Schema Prefix
POR_BULKLOAD_ALL_BUSINESS_GROUPS POR: Bulk Load for All Business Groups
POR_ECMGR_SERVLET_PATH POR: Ecmanager Servlet path
POR_LOADER_DEBUG POR: Set Debug Catalog Loader ON
POR_ENABLE_DEBIT_MEMO POR:  Enable Automatic Debit Memo Creation for Returns
ICX_EBI_EUL Obsolete
ICX_DISCOVERER_EUL_LANGUAGE ICX: Discoverer End User Layer Language Override
ICX_DISCOVERER_DBCFILENAME Discoverer DBC filename override
POR_CAT_RESULT_SET_SIZE POR: Catalog Result Set Size
POR_HIDE_SHOW_IMAGE POR: Show Thumbnail Images
POR_ENABLE_REQ_DIST_CUST POR: Enable Req Distribution Customization
POR_ENABLE_CHECKFUNDS POR: Enable Check Funds
POR_ENABLE_REVIEW_EXPRESS_RCV POR: Support review for Express Receive
POR_REQUIRE_BLIND_RECEIVING POR: Require Blind Receiving
POR_CHANGE_CATALOG_LANGUAGE POR: Change Catalog Language
POR_APPLY_CATEGORY_MAPPING POR: Apply Category Mapping
POR_THUMBNAIL_WIDTH POR: Thumbnail Width
ICX_OLTP_EUL ICX: Discoverer OLTP End User Layer Schema Prefix
POR_ALLOW_PCARD_WITH_ENCUMBRANCE POR: Allow pcard use with encumbrance
POR_FAVORITE_STORE POR: My Favorite Store
POR_THUMBNAIL_HEIGHT POR: Thumbnail Height
ICX_PREFERRED_CURRENCY ICX: Preferred Currency
POR_DISTRIBUTED_SEARCH_TIMEOUT POR: Transparent Punchout Timeout Limit
POR_LOAD_TARGET_IP_ADDRESS POR: Catalog Bulk Loader Host
POR_LOAD_PURGE_BEYOND_DAYS POR: Purge Jobs Older Than (days)
POR_LOAD_PURGE_COMMIT_SIZE POR: Bulk Loader Commit Size
POR_SORT_BY_RELEVANCE POR : Sort By Relevance
POR_SEARCH_GOVERNOR POR: Search Governor Value
POR_DISPLAY_SEARCH_AND_BROWSE POR: Enable Advanced Search and Category Browse
POR_ALLOW_MANUAL_SELECT_SOURCE POR:Allow Manual Selection of Source
POR_INTERNAL_CONFIRM_RECEIPT POR: Select Internal Requisition for Confirm Receipt
POR_EXTRACT_A13_AND_A14 POR: Extract BPA/Quote Images
POR_OVERRIDE_SUPP_PCARD POR : Override Supplier P-Card
ICX_DISCOVERER_PARAMETERS ICX: Discoverer Parameters
ICX_PREFIX ICX: Prefix
POR_DTD_FILE_DIRECTORY POR : Dtd Files Directory
POR_DEFAULT_DISP_TRANS_CURRENCY POR : Preference – Display Transaction Currency
POR_APPROVAL_AME POR : Use Oracle Approvals Manager
POR_DEFAULT_AWARD_ID POR : Preferences – Award
ICX_ACCESSIBILITY_FEATURES Self Service Accessibility Features
ICX_DISCOVERER_RELEASE ICX: Discoverer Release
POR_LOAD_AUTO_ATTRIB POR:Load Auto Attrib
POR_LOAD_AUTO_CAT POR: Load Auto Category
POR_LOAD_AUTO_ROOT POR:Load Auto Root
ICX_MATCHCASE_VIEW ICX: Match case View
ICX_MATCHCASE_LOV ICX: Match case LOV
POR_CACERT_FILE_NAME POR : CA Certificate File Name
ICX_DISCOVERER_VIEWER_LAUNCHER ICX: Discoverer Viewer Launcher
ICX_DISCOVERER_USE_VIEWER ICX: Discoverer use Viewer
POR_PROXY_SERVER_NAME POR : Proxy Server Name
POR_PROXY_SERVER_PORT POR : Proxy Server Port
ICX_SESSION_ID ICX: SESSION_ID
ICX_SESSION_TIMEOUT ICX:Session Timeout
POR_CHARGE_ACCT_SEG7 POR: My Profile-Charge Acct Seg 7
POR_CHARGE_ACCT_SEG6 POR: My Profile-Charge Acct Seg 6
POR_CHARGE_ACCT_SEG5 POR: My Profile-Charge Acct Seg 5
POR_CHARGE_ACCT_SEG4 POR: My Profile-Charge Acct Seg 4
POR_CHARGE_ACCT_SEG30 POR: My Profile-Charge Acct Seg 30
POR_CHARGE_ACCT_SEG3 POR: My Profile-Charge Acct Seg 3
POR_CHARGE_ACCT_SEG29 POR: My Profile-Charge Acct Seg 29
POR_CHARGE_ACCT_SEG28 POR: My Profile-Charge Acct Seg 28
POR_CHARGE_ACCT_SEG27 POR: My Profile-Charge Acct Seg 27
POR_CHARGE_ACCT_SEG26 POR: My Profile-Charge Acct Seg 26
POR_CHARGE_ACCT_SEG25 POR: My Profile-Charge Acct Seg 25
POR_CHARGE_ACCT_SEG24 POR: My Profile-Charge Acct Seg 24
POR_CHARGE_ACCT_SEG23 POR: My Profile-Charge Acct Seg 23
ICX_OA_MEDIA ICX: Media directory
ICX_OA_HTML ICX: HTML directory
ICX_STYLE_SHEET ICX: Style Sheet
ICX_FLOW_OPERANDS ICX: Default Flow Operand
POR_DEFAULT_RATE_TYPE POR: Default Currency Conversion Rate Type
POR_CHARGE_ACCT_SEG9 POR: My Profile-Charge Acct Seg 9
POR_CHARGE_ACCT_SEG8 POR: My Profile-Charge Acct Seg 8
POR_DEBUG POR : Debugging
POR_DIST_LINES_REGION POR : Distribution Lines Region
POR_RESTRICT_EMERGENCY_RQS_TEMPLATES POR : Emergency Requisitions – Restrict to Requisition Templates
POR_GOODS_LINE_TYPE_ID POR : Goods Line Type
POR_PARALLEL_ROUTING_ALLOWED POR : Parallel Routing Allowed
POR_DEFAULT_EXPENDITURE_TYPE POR : Preferences – Expenditure Type
POR_DEFAULT_DELIVER_TO_LOCATION_ID POR : Preferences – Deliver to Location
POR_DEFAULT_PROJECT_ID POR : Preferences – Project
POR_DEFAULT_REQUESTER_ID POR : Preferences – Requester
POR_DEFAULT_INVENTORY_REPLENISHMENT POR : Preferences – Selected Items Default to Inventory
POR_DEFAULT_SUBINVENTORY POR : Preferences – SubInventory
POR_DEFAULT_TASK_ID POR : Preferences – Task
POR_RATE_BASED_LINE_TYPE_ID POR : Rate Based Services Line Type
POR_SYS_GENERATED_APPROVERS_MANDATORY POR : System Approvers are Mandatory
POR_ENABLE_REQ_LINE_CUST POR: Enable Requisition Line Customization
POR_JAVA_VIRTUAL_PATH POR: Java Virtual Path
POR_DEFAULT_EXPENDITURE_ITEM_DATE POR: Preferences – Expenditure Item Date
POR_DEFAULT_EXPENDITURE_ORG_ID POR: Preferences – Expenditure Org
POR_RESULT_SET_SIZE POR: Result Set Size
POR_SSP4_INSTALLED POR: SSP4 Installed
POR_ALLOW_INV_DEST_RECEIPTS POR: Select Inventory Replenishment Lines For Confirm Receipts
ICX_CLIENT_IANA_ENCODING ICX: Client IANA Encoding
POR_ONE_TIME_LOCATION POR: One Time Location
POR_CHARGE_ACCT_SEG22 POR: My Profile-Charge Acct Seg 22
POR_CHARGE_ACCT_SEG21 POR: My Profile-Charge Acct Seg 21
POR_CHARGE_ACCT_SEG20 POR: My Profile-Charge Acct Seg 20
POR_HELP_PATH POR: Help Path
POR_CHARGE_ACCT_SEG2 POR: My Profile-Charge Acct Seg 2
POR_CHARGE_ACCT_SEG19 POR: My Profile-Charge Acct Seg 19
POR_CHARGE_ACCT_SEG18 POR: My Profile-Charge Acct Seg 18
POR_CHARGE_ACCT_SEG17 POR: My Profile-Charge Acct Seg 17
POR_CHARGE_ACCT_SEG16 POR: My Profile-Charge Acct Seg 16
POR_CHARGE_ACCT_SEG15 POR: My Profile-Charge Acct Seg 15
POR_CHARGE_ACCT_SEG14 POR: My Profile-Charge Acct Seg 14
POR_CHARGE_ACCT_SEG13 POR: My Profile-Charge Acct Seg 13
POR_CHARGE_ACCT_SEG12 POR: My Profile-Charge Acct Seg 12
POR_CHARGE_ACCT_SEG11 POR: My Profile-Charge Acct Seg 11
POR_CHARGE_ACCT_SEG10 POR: My Profile-Charge Acct Seg 10
POR_CHARGE_ACCT_SEG1 POR: My Profile-Charge Acct Seg 1
POR_SERVLET_VIRTUAL_PATH POR: Servlet Virtual Path
POR_TEMP_CATALOG_FILES POR: Catalog Bulk Load Directory
POR_SSP_VERSION POR: SSP Version
POR_SEQ_FOR_REQ_NUMBERING POR : Use Sequence for Requisition Numbering
POR_ROWS_DISPLAY_NUM POR: Rows Display Num
POR_MULTIPLE_ACCOUNTS_REGION POR: Multiple Accounts region
POR_ITEMS_DISPLAY_NUM POR: Items Display Num
POR_ITEM_PIC_FILE_PATH POR: Hosted Images Directory
POR_EDIT_ACCOUNTS_REGION POR: Edit Accounts Region
ICX_ALLOW_OVERRIDE_FUNDS ICX:Allow Funds Override
ICX_DATE_FORMAT_MASK ICX: Date format mask
ICX_DATE_LANGUAGE ICX: Date language
ICX_DAYS_NEEDED_BY ICX: Days Needed By
ICX_DEFAULT_DISCO_WORKBOOK_OWN ICX: Default Discoverer Workbook Owner
ICX_DEFAULT_EUL ICX: Discoverer Default End User Layer Schema Prefix
ICX_DISCOVERER_LAUNCHER ICX: Discoverer Launcher
ICX_EMPLOYEE_ID ICX: Default Employee
ICX_FORMS_LAUNCHER ICX: Forms Launcher
ICX_LANGUAGE ICX: Language
ICX_LIMIT_CONNECT ICX: Limit connect
ICX_LIMIT_TIME ICX: Limit time
ICX_NLS_SORT ICX: NLS Sort
ICX_NUMERIC_CHARACTERS ICX: Numeric characters
ICX_PAY_SERVER ICX: Oracle Payment Server URL
ICX_REQ_DEFAULT_TEMPLATE ICX: Default Requisition Template
ICX_REQ_OVERRIDE_LOCATION_FLAG ICX: Override Location Flag
ICX_REQ_OVERRIDE_REQUESTOR_CODE ICX: Override Requestor
ICX_REQ_SERVER ICX: Requisition Sever
ICX_STORE_ORDER_REP ICX: Web Store Order Representative
ICX_TERRITORY ICX: Territory
POR_AMOUNT_BASED_LINE_TYPE_ID POR : Amount Based Services Line Type
POR_APPROVED_PRICING_ONLY POR : Approved Pricing Only
POR_CLEANUPTHR_INTERVAL POR : Cleanup Thread Interval