Search Results operator_id

Overview

ICX_POR_ITEM_SOURCES_VL is a validation view owned by the APPS schema in Oracle E-Business Suite, defined in the Oracle iProcurement (ICX) product module. It exposes the master list of item sources that iProcurement uses to locate purchasable items and route requisition lines to the correct content source. Item sources include external supplier web sites, punch-out catalog providers, hub configurations, and other non-local sources used during the requisition and checkout flow. The "VL" suffix indicates a view that joins a base table with its translation table and filters rows by the session language via USERENV('LANG'), so that the item source name and description are returned in the user's currently selected language. The view also deliberately excludes records whose TYPE is 'LOCAL', restricting its scope to non-local sources. In reporting and integration terms, this view is the supported, translated read interface for item source configuration, allowing concurrent programs, personalizations, and external integrations to consume item source definitions without directly querying the underlying tables. It carries the standard EBS WHO columns and is marked VALID in the ETRM 12.2.2 repository.

Underlying Base Objects

The view is defined over two synonyms that resolve to the base tables in the APPS schema: ICX_POR_ITEM_SOURCES (alias IPIS) and ICX_POR_ITEM_SOURCES_TL (alias IPIST). The join key is ITEM_SOURCE_ID, which links each base row in ICX_POR_ITEM_SOURCES to its translated row in ICX_POR_ITEM_SOURCES_TL. Two additional filters apply within the view definition: IPIS.TYPE <> 'LOCAL' eliminates local sources from the result set, and IPIST.LANGUAGE = USERENV('LANG') restricts translation rows to the session language. This structure is the standard Oracle EBS pattern for a _VL view: language-independent attributes reside on ICX_POR_ITEM_SOURCES, while language-dependent text such as ITEM_SOURCE_NAME and DESCRIPTION resides on ICX_POR_ITEM_SOURCES_TL. Because the view is read-only and joins ROWID from the base table, it is not directly updatable through the view for the translated columns.

Key Columns

• ITEM_SOURCE_ID — Primary identifier for the item source, and the join key between the base and translation tables.
• ITEM_SOURCE_NAME / DESCRIPTION — Translated name and description sourced from ICX_POR_ITEM_SOURCES_TL for the session language.
• TYPE — Classification of the source; the view returns only rows where TYPE is not 'LOCAL'.
• URL, IMAGE_URL, PROTOCOL_SUPPORTED — Access and presentation attributes used when launching or displaying the source.
• IS_HUB — Indicates whether the source functions as a hub in a hub-and-spoke iProcurement configuration.
• OPERATOR_ID — The field the user searched for; it associates the item source with an operator identifier used in iProcurement configuration.
• USER_DATA_FLAG / USER_DATA_LIST_ID — Exposed as a derived flag via DECODE, indicating whether the source depends on a user data list.
• LOCK_ITEM_FLAG / DISPLAY_ALWAYS — NVL-normalized flags controlling item locking behavior and default display behavior.
• USER_NAME / PASSWORD — Credentials used when connecting to the external source.
• SEQUENCE_NUMBER — Ordering value for presenting sources to the user.
• ICX_SESSION_SERVLET_FLAG — Controls use of the iProcurement session servlet for the source.
• WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical uses include validating item source setup, troubleshooting punch-out connectivity, and building reports on configured non-local sources. Because the view already filters by language and TYPE, custom SQL should not re-implement those predicates. A representative query listing sources with their hubs and operator assignments is:

SELECT ITEM_SOURCE_ID, ITEM_SOURCE_NAME, TYPE, IS_HUB, OPERATOR_ID, SEQUENCE_NUMBER
FROM APPS.ICX_POR_ITEM_SOURCES_VL
ORDER BY SEQUENCE_NUMBER;

To inspect hub sources only:

SELECT ITEM_SOURCE_ID, ITEM_SOURCE_NAME, URL, OPERATOR_ID
FROM APPS.ICX_POR_ITEM_SOURCES_VL
WHERE IS_HUB = 'Y';

To retrieve the display flags and language-dependent text for a specific source:

SELECT ITEM_SOURCE_NAME, DESCRIPTION, LOCK_ITEM_FLAG, DISPLAY_ALWAYS
FROM APPS.ICX_POR_ITEM_SOURCES_VL
WHERE ITEM_SOURCE_ID = :p_item_source_id;

Note that PASSWORD should be masked or excluded in reporting extracts for security reasons.