Search Results oe_pc_conditions_tl




Overview
Explore in AI Chat

Overview

The OE_PC_CONDITIONS_TL table is a core translation table within the Oracle E-Business Suite (EBS) Order Management (ONT) module, specifically for versions 12.1.1 and 12.2.2. It is owned by the ONT schema and holds the language-specific, translatable text for conditions associated with pricing constraints. This table enables the multi-language support (MLS) capability of Oracle EBS, allowing constraint conditions to be displayed in a user's preferred language. Its role is to store the human-readable descriptions or logical expressions that define a pricing constraint's condition, separate from the structural constraint definition itself, thereby supporting global deployments.

Key Information Stored

The table's primary purpose is to store translated condition text. Its structure is characteristic of an EBS translation table. The primary key is a composite of CONDITION_ID and LANGUAGE, ensuring a unique entry for each condition in each supported language. The CONDITION_ID column is a foreign key that links back to the base condition record in the OE_PC_CONDITIONS table. The LANGUAGE column stores the language code (e.g., 'US' for American English). The most critical data column is typically named CONDITION_TEXT or a similar variant (though not explicitly listed in the provided metadata, it is standard for TL tables), which contains the actual translated text of the condition. Other standard translation table columns like SOURCE_LANG, CREATED_BY, and CREATION_DATE are also typically present.

Common Use Cases and Queries

This table is primarily accessed for generating user interfaces and reports in the correct language. A common use case is retrieving the condition description for a specific pricing constraint to display on an order form or pricing report. Development and support activities often involve queries to verify or audit translations. A typical SQL pattern joins this table with its base table and filters by language.

  • Sample Query: To retrieve all English translations for conditions: SELECT c.constraint_id, tl.condition_text FROM oe_pc_conditions c, oe_pc_conditions_tl tl WHERE c.condition_id = tl.condition_id AND tl.language = 'US';
  • Reporting: Used in reports detailing pricing rules and their logic for international stakeholders.
  • Data Fix: Correcting or updating translated condition text for a specific language and condition_id.

Related Objects

OE_PC_CONDITIONS_TL has a direct and critical relationship with its base table, as defined by the documented foreign key. This relationship is fundamental to its operation.

  • OE_PC_CONDITIONS: This is the primary related table. The foreign key relationship is OE_PC_CONDITIONS_TL.CONDITION_ID references OE_PC_CONDITIONS.CONDITION_ID. All translatable condition records in the TL table must have a corresponding master record in this base table.
  • FND_LANGUAGES: While not explicitly listed in the metadata, the LANGUAGE column in OE_PC_CONDITIONS_TL typically corresponds to the language codes defined in the application's language lookup table, FND_LANGUAGES.
  • Pricing Engine Views/APIs: Higher-level application programming interfaces (APIs) and views within the Pricing and Order Management modules will internally join to this table to present localized data to calling programs and forms.