Results for “gr_property_values_tl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GR_PROPERTY_VALUES_TL is a translation (TL) table in the Oracle E-Business Suite Process Manufacturing Regulatory Management (GR) module. It stores the language-specific descriptive text, displayed value, and meaning for the individual values that a regulatory property may assume. Where GR_PROPERTIES_B defines a property itself — for instance, Marine Pollutants — GR_PROPERTY_VALUES_TL enumerates the permissible outcomes for that property and supplies the user-facing labels and validation semantics for each. In the documented example, Marine Pollutants carry values of N (Not a Pollutant), P (Marine Pollutant), PP (Severe Pollutant), and U (Unknown), each of which is represented as a translatable row.

The table follows the standard EBS multilingual pattern: a base table holds language-independent identifiers, while the _TL table holds translated MEANING and DESCRIPTION text keyed by LANGUAGE. Its role is therefore both reference-data-defining and presentation-oriented, driving list-of-values validation and multilingual display in regulatory compliance screens. Under a heuristic Data Vault classification, this object most naturally maps to a satellite, since it carries descriptive, language-dependent attributes (MEANING, DESCRIPTION, DISPLAY_ORDER) attached to the GR_PROPERTIES_B business key rather than acting as an independent hub. A modeling exercise should confirm this before committing to a formal Data Vault build.

Key Information Stored

The documented physical schema for 12.2.2 contains twelve columns. The most significant are:

• PROPERTY_ID — foreign key to GR_PROPERTIES_B, identifying the parent regulatory property whose values are being defined.
• LANGUAGE — the language of the translated row, referencing FND_LANGUAGES.
• VALUE — the stored code or value that passes validation and is referenced by transactions (for example, N, P, PP, U).
• MEANING — the translated display label shown to the user, such as "Marine Pollutant."
• DISPLAY_ORDER — controls the sequence in which values appear in lists of values.
• SOURCE_LANG — the source language from which the translation was derived, also referencing FND_LANGUAGES.
• ZD_EDITION_NAME — the editioning column used by EBS online patching, part of the documented unique index.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS WHO columns recording audit and concurrency information.

The documented primary key is GR_PROPERTY_VALUES_TL_PK over (PROPERTY_ID, LANGUAGE, VALUE). The unique index of the same name is documented to include ZD_EDITION_NAME, making (PROPERTY_ID, LANGUAGE, VALUE, ZD_EDITION_NAME) the effective business-key candidate. There is no single surrogate column distinct from these business attributes; the composite key itself serves that purpose.

Common Use Cases and Queries

Typical scenarios include building lists of values for regulatory property entry screens, retrieving the correct translated label for a stored value, and validating inbound compliance data against permitted outcomes. A common pattern joins the translation table to its base property table and filters on language:

• Query all values and labels for Marine Pollutants in US English.
• Validate that a submitted VALUE exists for a given PROPERTY_ID and LANGUAGE before loading composition data.
• Report the permitted values and meanings across properties for regulatory documentation.

A representative query would select v.PROPERTY_ID, v.VALUE, v.MEANING, v.DISPLAY_ORDER from GR_PROPERTY_VALUES_TL v join GR_PROPERTIES_B p on v.PROPERTY_ID = p.PROPERTY_ID where v.LANGUAGE = 'US' order by v.PROPERTY_ID, v.DISPLAY_ORDER. Reporting extracts should filter on the active language and, in 12.2.x, remain consistent with the ZD_EDITION_NAME in force.

Related Objects

• GR_PROPERTIES_B — the base property table; GR_PROPERTY_VALUES_TL.PROPERTY_ID references it.
• FND_LANGUAGES — referenced twice, via LANGUAGE and SOURCE_LANG.
• GR_PROPERTY_VALUES_B — the untranslated counterpart holding the base value definitions.
• GR_PROPERTIES_TL — the translated property table supplying the parent property's label.
• GR_PROPERTY_VALUES_TL_PK — the documented primary-key index enforcing uniqueness across PROPERTY_ID, LANGUAGE, VALUE, and ZD_EDITION_NAME.

These relationships confirm that the object sits within the GR regulatory reference-data model, anchored to GR_PROPERTIES_B and localized through FND_LANGUAGES.