Search Results icx_text

Overview

The ICX_TEXT table is a core technical table within the Oracle iProcurement (ICX) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. As documented in the ETRM, its primary function is to serve as a parameter encryption table. It operates as a secure, transient repository for sensitive data, such as login credentials, session parameters, and other confidential information that must be passed between different components of the iProcurement application or between EBS and external systems. Its role is critical for maintaining the security and integrity of session data by preventing sensitive values from being exposed in URLs or other unsecured channels.

Key Information Stored

The table's structure is designed to store encrypted text data linked to user sessions. Based on the provided metadata, the key columns include:

• TEXT_ID: The primary key column for the table, uniquely identifying each stored piece of encrypted text.
• SESSION_ID: A foreign key column that links the encrypted data to a specific user session in the ICX_SESSIONS table. This relationship ensures that encrypted parameters are scoped to and managed within a valid application session.

While the specific content of the encrypted text is not detailed in the excerpt, it typically consists of parameter strings that require secure handling. The table's name and description imply that the data stored within is not plain text but is held in an encrypted format.

Common Use Cases and Queries

This table is primarily used by the application's internal logic for secure data handling and is not typically queried directly for business reporting. Common operational scenarios include the secure passing of parameters during the Single Sign-On (SSO) process or when invoking external content or services from within iProcurement. Administrators or support personnel might query it to diagnose session-related issues. A sample diagnostic query would join to the session table to investigate data persistence:

• Session Data Investigation: SELECT it.text_id, it.session_id, ises.creation_date FROM icx.icx_text it, icx.icx_sessions ises WHERE it.session_id = ises.session_id AND ises.user_id = :user_id;

Direct manipulation of data in this table is strongly discouraged, as it is managed by the application's encryption and session management APIs.

Related Objects

The ICX_TEXT table has defined relationships with other core iProcurement session management objects, as per the ETRM metadata:

• ICX_SESSIONS: This is the primary related table. The foreign key constraint (ICX_TEXT.SESSION_ID references ICX_SESSIONS) enforces that all encrypted text is associated with a valid, managed application session. The ICX_SESSIONS table tracks active user sessions within the iProcurement module.
• ICX_TEXT_PK: The primary key constraint on the TEXT_ID column, ensuring the uniqueness of each stored encrypted parameter entry.

Functionally, this table is accessed via internal Oracle iProcurement APIs and the underlying session management infrastructure, rather than through direct public interfaces.