Search Results psb_attributes_tl_u1

Overview

PSB.PSB_ATTRIBUTES_TL is the translation (TL) table for the base entity PSB_ATTRIBUTES within the Oracle E-Business Suite Product Information Management / attribute framework delivered under the PSB schema. It stores multiple-language support information: for each position attribute defined in PSB_ATTRIBUTES, one row exists per installed language, carrying the translated attribute name and display prompt. The table resides in the APPS_TS_TX_DATA tablespace with PCT Free 10, and its indexes are placed in APPS_TS_TX_IDX, consistent with standard EBS transactional data conventions.

The object is present and VALID in both Oracle EBS 12.1.1 and 12.2.2, with FND Design Data registration PSB.PSB_ATTRIBUTES_TL. It is classified as standalone under the heuristic Data Vault mining performed against the foreign key structure, meaning no outbound foreign keys were detected in the dependency graph. As a modelling suggestion, the table behaves principally as a satellite attached to the PSB_ATTRIBUTES hub, since it holds descriptive, language-dependent attributes keyed back to the parent attribute; however, because the mined classification is standalone, this should be treated as an interpretive observation rather than a confirmed relational constraint.

Key Information Stored

The table contains ten documented columns. The most significant are:

• ATTRIBUTE_ID (NUMBER(20)) — the position attribute unique identifier. This is the surrogate key linking each translation row back to the base PSB_ATTRIBUTES record.
• NAME (VARCHAR2(30)) — the position attribute name, translated for the row's language.
• DISPLAY_PROMPT (VARCHAR2(30)) — the prompt displayed for this position attribute in the user interface.
• LANGUAGE (VARCHAR2) — the language in which the attribute information is stored.
• SOURCE_LANG (VARCHAR2) — the main (base) language of the record, used by the EBS translation framework to track the origin language.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — the standard Who columns audited on all EBS transactional rows.

Two key definitions are documented. The physical primary key is PSB_ATTRIBUTES_TL_PK on (NAME, LANGUAGE, ATTRIBUTE_ID). A separate unique index, PSB_ATTRIBUTES_TL_U1 on (ATTRIBUTE_ID, LANGUAGE), functions as the business-key candidate and is the object the user searched for. U1 guarantees exactly one translation row per attribute per language, whereas the PK additionally constrains the NAME value.

Common Use Cases and Queries

Typical usage centres on multilingual reporting of attribute definitions and on retrieving localized prompts for UI or integration layers. A common pattern joins the translation table to its base table filtered by language:

• Retrieve prompts for a specific language: SELECT ATTRIBUTE_ID, NAME, DISPLAY_PROMPT FROM PSB.PSB_ATTRIBUTES_TL WHERE LANGUAGE = 'US';
• Detect missing or untranslated rows via SOURCE_LANG comparison: WHERE LANGUAGE = SOURCE_LANG to isolate records still holding the base language.
• Validate data quality using the unique index: count rows grouped by (ATTRIBUTE_ID, LANGUAGE) to confirm no duplicates against PSB_ATTRIBUTES_TL_U1.
• Join to PSB_ATTRIBUTES on ATTRIBUTE_ID to enrich base metadata with localized NAME and DISPLAY_PROMPT.

Related Objects

• PSB.PSB_ATTRIBUTES — the base table; joined on ATTRIBUTE_ID. The TL row supplies the language-specific NAME and DISPLAY_PROMPT for this parent record.
• APPS.PSB_ATTRIBUTES_TL — the APPS synonym/view reference that EBS application code and reports use to reach the PSB table; documented as a dependent object.
• PSB_ATTRIBUTES_TL_U1 — the unique index on (ATTRIBUTE_ID, LANGUAGE), the business-key candidate and target of the user's search.
• PSB_ATTRIBUTES_TL_PK — the primary key index on (NAME, LANGUAGE, ATTRIBUTE_ID).

The documented dependency data states that PSB_ATTRIBUTES_TL does not reference any database object and is referenced by APPS.PSB_ATTRIBUTES_TL, confirming its role as a dependent translation entity rather than an owning table.