ICX — Oracle iProcurement
146 documented tables · 393 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
ICX_POR_BATCH_JOBS |
Holds information about submitted catalog batch processes. | hub-leaning |
ICX_POR_ITEMS |
Stores information and root descriptors for non translatable data for each item in the catalog. Root descript | hub |
ICX_POR_CATEGORIES_TL |
Stores information about the categories that exist within a catalog. Categories are used to classify items in | hub-leaning |
ICX_SHOPPING_CARTS |
Web Requisitions headers table | hub-leaning |
ICX_SESSIONS |
Session context table | satellite-leaning |
ICX_POR_PRICE_LISTS |
Stores price lists information. There is 1 price list per buyer/supplier combination. | hub-leaning |
ICX_POR_THIRD_PARTY_LOGS |
Table that stores historical data of Third Party Content Provider activity on Suppliers' catalogs. | satellite-leaning |
ICX_POR_ITEM_SOURCES |
Stores information about Catalog content sources. Associated with the Item Source form. | satellite-leaning |
ICX_POR_ITEMS_TL |
Stores information and root descriptors for translatable data for each item in the catalog. Root descriptor | satellite-leaning |
ICX_SHOPPING_CART_LINES |
Web Requisitions lines table | satellite-leaning |
ICX_CART_LINE_DISTRIBUTIONS |
Web Requisitions lines distribution table | satellite-leaning |
ICX_POR_DESCRIPTORS_TL |
Stores information about descriptors associated with a given category. Root descriptors are associated with th | satellite-leaning |
ICX_REGIONS |
Defines region information of a Self-Service Web Applications page. | standalone |
ICX_QUESTION_FUNCTIONS |
- Retrofitted | standalone |
ICX_PAGES |
Defines all pages information of each PHP user | satellite-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
ICX_CAT_POPULATE_ITEM_GRP |
GRP | 3 | 2 packages |
ICX_RELATED_TEMPLATES_PUB |
PUB | 2 | 1 packages |
ICX_RELATED_CATEGORIES_PUB |
PUB | 2 | 1 packages |
ICX_CAT_POPULATE_QUOTE_GRP |
GRP | 1 | 1 packages |
ICX_CAT_POPULATE_CATG_GRP |
GRP | 4 | 1 packages |
ICX_CAT_R12_UPGRADE_GRP |
GRP | 4 | 1 packages |
ICX_USER_SEC_ATTR_PUB |
PUB | 2 | 1 packages |
ICX_ITEM_DIAG_GRP |
GRP | 1 | 1 packages |
ICX_CAT_POPULATE_REQTMPL_GRP |
GRP | 1 | 1 packages |
ICX_CAT_POPULATE_BPA_GRP |
GRP | 2 | 1 packages |