Search Results qp_price_formulas_tl




Overview
Explore in AI Chat

Overview

The QP_PRICE_FORMULAS_TL table is a core data object within the Oracle E-Business Suite (EBS) Advanced Pricing (QP) module. It functions as a translation table, storing the multilingual text for pricing formulas. In Oracle EBS, a pricing formula is a configurable rule used to calculate complex prices, discounts, surcharges, or other adjustments on transactions. While the core, non-translatable attributes of a formula are stored in the base table QP_PRICE_FORMULAS_B, this TL (Translation) table holds the user-facing name and description for each formula in every installed language. This design enables global enterprises to deploy a single pricing formula while presenting its name and description in the appropriate language (e.g., English, French, Japanese) to users across different locales, ensuring clarity and consistency in international operations.

Key Information Stored

The table's primary purpose is to manage multilingual descriptions. Its structure is defined by a composite primary key and language-specific columns. The critical columns include:

  • PRICE_FORMULA_ID: The unique identifier for the pricing formula. This column forms a foreign key relationship to the QP_PRICE_FORMULAS_B table, linking the translation to its core definition.
  • LANGUAGE: The standard Oracle language code (e.g., 'US' for American English, 'F' for French). Together with PRICE_FORMULA_ID, this column constitutes the table's primary key (QP_PRICE_FORMULAS_TL_PK), ensuring a unique translation per formula per language.
  • NAME: The translated, user-friendly name of the pricing formula as it appears in the application's user interface.
  • DESCRIPTION: The detailed explanation of the formula's purpose or calculation logic in the specified language.
  • SOURCE_LANG: A standard column in Oracle translation tables that indicates the original language in which the record was created.

Common Use Cases and Queries

This table is primarily accessed by the Oracle application itself to display localized content. Common technical and reporting use cases include:

  • Generating Multilingual Price List Documentation: Extracting formula names and descriptions for specific languages to create customer-facing or internal pricing guides.
  • Data Validation and Cleanup: Identifying formulas missing translations in key languages or verifying translation completeness before a global rollout.
  • Ad-hoc Reporting on Formula Usage: Joining with the base table and other pricing entities to report on which formulas are active and their descriptions.

A typical query to retrieve all English translations for active formulas would be:

SELECT b.FORMULA_ID, tl.NAME, tl.DESCRIPTION
FROM QP_PRICE_FORMULAS_B b, QP_PRICE_FORMULAS_TL tl
WHERE b.PRICE_FORMULA_ID = tl.PRICE_FORMULA_ID
AND tl.LANGUAGE = 'US'
AND b.END_DATE_ACTIVE IS NULL;

Related Objects

QP_PRICE_FORMULAS_TL is integral to the Advanced Pricing data model and has direct relationships with several key objects:

  • QP_PRICE_FORMULAS_B: This is the primary base table. Every record in the TL table must have a corresponding parent record in the _B table, as enforced by the foreign key constraint on PRICE_FORMULA_ID. The _B table stores the formula's calculation logic, effective dates, and other functional attributes.
  • QP_FORMULA_PRICE_DTLS and other pricing detail tables: These tables reference the PRICE_FORMULA_ID from the base table, indirectly linking transactions and price list lines to the multilingual descriptions stored in the TL table.
  • Oracle Translation Architecture: The table follows the standard Oracle EBS pattern for translatable objects, utilizing the LANGUAGE and SOURCE_LANG columns. It is typically accessed via views that automatically filter translations based on the user's session language.
  • Table: QP_PRICE_FORMULAS_TL 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_PRICE_FORMULAS_TL,  object_name:QP_PRICE_FORMULAS_TL,  status:VALID,  product: QP - Advanced Pricing ,  description: This table stores the translatable columns, name & description of the pricing formulas, in each of the available languages in the database. ,  implementation_dba_data: QP.QP_PRICE_FORMULAS_TL , 

  • Table: QP_PRICE_FORMULAS_TL 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_PRICE_FORMULAS_TL,  object_name:QP_PRICE_FORMULAS_TL,  status:VALID,  product: QP - Advanced Pricing ,  description: This table stores the translatable columns, name & description of the pricing formulas, in each of the available languages in the database. ,  implementation_dba_data: QP.QP_PRICE_FORMULAS_TL , 

  • View: QP_PRICE_FORMULAS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PRICE_FORMULAS_VL,  object_name:QP_PRICE_FORMULAS_VL,  status:VALID,  product: QP - Advanced Pricing ,  description: View of QP_PRICE_FORMULAS_B and QP_PRICE_FORMULAS_TL. Displays the translated columns on pricing formulas in the local language. ,  implementation_dba_data: APPS.QP_PRICE_FORMULAS_VL , 

  • View: QP_PRICE_FORMULAS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PRICE_FORMULAS_VL,  object_name:QP_PRICE_FORMULAS_VL,  status:VALID,  product: QP - Advanced Pricing ,  description: View of QP_PRICE_FORMULAS_B and QP_PRICE_FORMULAS_TL. Displays the translated columns on pricing formulas in the local language. ,  implementation_dba_data: APPS.QP_PRICE_FORMULAS_VL , 

  • View: QPBV_FORMULA_HEADERS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_FORMULA_HEADERS,  object_name:QPBV_FORMULA_HEADERS,  status:VALID,  product: QP - Advanced Pricing ,  description: This gives information about formula headers ,  implementation_dba_data: APPS.QPBV_FORMULA_HEADERS , 

  • View: QPBV_FORMULA_HEADERS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_FORMULA_HEADERS,  object_name:QPBV_FORMULA_HEADERS,  status:VALID,  product: QP - Advanced Pricing ,  description: This gives information about formula headers ,  implementation_dba_data: APPS.QPBV_FORMULA_HEADERS , 

  • Table: QP_PRICE_FORMULAS_B 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_PRICE_FORMULAS_B,  object_name:QP_PRICE_FORMULAS_B,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_PRICE_FORMULAS_B stores the pricing formula header information. ,  implementation_dba_data: QP.QP_PRICE_FORMULAS_B , 

  • Table: QP_PRICE_FORMULAS_B 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_PRICE_FORMULAS_B,  object_name:QP_PRICE_FORMULAS_B,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_PRICE_FORMULAS_B stores the pricing formula header information. ,  implementation_dba_data: QP.QP_PRICE_FORMULAS_B , 

  • View: QP_PRICE_FACTORS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PRICE_FACTORS_V,  object_name:QP_PRICE_FACTORS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View to get a list of those formula lines which are of type Price Modifier List along with the List of Adjustment Factors & Ranges making up the formula line and the discount modifier list to which the formula is attached. ,  implementation_dba_data: APPS.QP_PRICE_FACTORS_V , 

  • View: QP_PRICE_FACTORS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PRICE_FACTORS_V,  object_name:QP_PRICE_FACTORS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View to get a list of those formula lines which are of type Price Modifier List along with the List of Adjustment Factors & Ranges making up the formula line and the discount modifier list to which the formula is attached. ,  implementation_dba_data: APPS.QP_PRICE_FACTORS_V ,