Search Results token_id




Overview
Explore in AI Chat

Overview

The PRP_TOKENS_TL table is a core translation table within the Oracle E-Business Suite Proposals (PRP) module. It operates as a child table to the base table PRP_TOKENS_B, storing all language-specific, translatable attributes for tokens. In Oracle EBS, tokens are dynamic placeholders used within proposal templates and documents to insert variable data, such as customer names, dates, or calculated amounts. The TL (Translation) suffix indicates this table's role in the application's multi-language architecture, enabling the Proposals module to support a global user base by storing a separate record for each supported language per token. Its existence is critical for generating localized proposal documents in release 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to manage multilingual content. Its primary key is a composite of TOKEN_ID and LANGUAGE, ensuring a unique entry for each token in each language. The TOKEN_ID column is a foreign key that links directly to the PRP_TOKENS_B table, which holds the non-translatable, base definition of the token. The LANGUAGE column stores the language code (e.g., 'US' for American English, 'KO' for Korean) for the translation. While the specific translatable column names are not detailed in the provided metadata, typical columns in EBS translation tables include TOKEN_NAME, DESCRIPTION, and potentially HELP_TEXT or PROMPT_TEXT. These columns hold the actual translated strings that appear in the user interface or within generated documents.

Common Use Cases and Queries

This table is primarily accessed for rendering proposal documents in a user's session language and for administrative translation tasks. A common reporting use case is to audit token translations for completeness across installed languages. A typical query would join PRP_TOKENS_TL with PRP_TOKENS_B to list all tokens and their translations. For example:

  • SELECT b.TOKEN_CODE, tl.LANGUAGE, tl.TOKEN_NAME, tl.DESCRIPTION FROM PRP.PRP_TOKENS_B b, PRP.PRP_TOKENS_TL tl WHERE b.TOKEN_ID = tl.TOKEN_ID AND tl.LANGUAGE = 'DE'; – Retrieves all German translations.
  • SELECT TOKEN_ID, COUNT(*) FROM PRP.PRP_TOKENS_TL GROUP BY TOKEN_ID HAVING COUNT(*) < (SELECT COUNT(*) FROM FND_LANGUAGES WHERE INSTALLED_FLAG = 'B'); – Identifies tokens missing translations for some installed base languages.

Application logic will automatically query this table, filtered by the user's session language (NLS_LANGUAGE), when displaying token references within the Proposals forms or generating output documents.

Related Objects

The PRP_TOKENS_TL table has a direct and essential relationship with the PRP_TOKENS_B table, as defined by its foreign key constraint. PRP_TOKENS_B contains the invariant technical definition of the token, such as its code, data type, and source logic, while PRP_TOKENS_TL contains the user-facing textual attributes. This table is also intrinsically linked to the broader Oracle Applications translation architecture, relying on the FND_LANGUAGES table for valid language codes. In application code, data from this table is typically accessed via views that automatically filter for the current session language, which may have names following the pattern PRP_TOKENS_VL (where 'V' denotes view and 'L' denotes language).

  • Table: PRP_TOKENS_TL 12.2.2

    owner:PRP,  object_type:TABLE,  fnd_design_data:PRP.PRP_TOKENS_TL,  object_name:PRP_TOKENS_TL,  status:VALID,  product: PRP - Proposals ,  description: This table contains the translated information about the tokens. ,  implementation_dba_data: PRP.PRP_TOKENS_TL , 

  • View: PRP_TOKEN_VALUES_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PRP.PRP_TOKEN_VALUES_VL,  object_name:PRP_TOKEN_VALUES_VL,  status:VALID,  product: PRP - Proposals ,  implementation_dba_data: APPS.PRP_TOKEN_VALUES_VL , 

  • Table: PRP_GROUP_TOKENS 12.1.1

    owner:PRP,  object_type:TABLE,  fnd_design_data:PRP.PRP_GROUP_TOKENS,  object_name:PRP_GROUP_TOKENS,  status:VALID,  product: PRP - Proposals ,  description: This table contains the associations between tokens and groups. ,  implementation_dba_data: PRP.PRP_GROUP_TOKENS , 

  • Table: PRP_TOKEN_VALUES_TL 12.1.1

    owner:PRP,  object_type:TABLE,  fnd_design_data:PRP.PRP_TOKEN_VALUES_TL,  object_name:PRP_TOKEN_VALUES_TL,  status:VALID,  product: PRP - Proposals ,  description: This table contains the values for the "User Defined" tokens of type "List of Values". This table stores the list of values for each token in each installed language. ,  implementation_dba_data: PRP.PRP_TOKEN_VALUES_TL , 

  • Table: PRP_TOKENS_B 12.1.1

    owner:PRP,  object_type:TABLE,  fnd_design_data:PRP.PRP_TOKENS_B,  object_name:PRP_TOKENS_B,  status:VALID,  product: PRP - Proposals ,  description: This table contains the base information about the tokens. ,  implementation_dba_data: PRP.PRP_TOKENS_B , 

  • Table: PRP_TOKENS_B 12.2.2

    owner:PRP,  object_type:TABLE,  fnd_design_data:PRP.PRP_TOKENS_B,  object_name:PRP_TOKENS_B,  status:VALID,  product: PRP - Proposals ,  description: This table contains the base information about the tokens. ,  implementation_dba_data: PRP.PRP_TOKENS_B , 

  • Table: PRP_GROUP_TOKENS 12.2.2

    owner:PRP,  object_type:TABLE,  fnd_design_data:PRP.PRP_GROUP_TOKENS,  object_name:PRP_GROUP_TOKENS,  status:VALID,  product: PRP - Proposals ,  description: This table contains the associations between tokens and groups. ,  implementation_dba_data: PRP.PRP_GROUP_TOKENS , 

  • View: PRP_TOKEN_VALUES_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PRP.PRP_TOKEN_VALUES_VL,  object_name:PRP_TOKEN_VALUES_VL,  status:VALID,  product: PRP - Proposals ,  implementation_dba_data: APPS.PRP_TOKEN_VALUES_VL , 

  • Table: PRP_TOKENS_TL 12.1.1

    owner:PRP,  object_type:TABLE,  fnd_design_data:PRP.PRP_TOKENS_TL,  object_name:PRP_TOKENS_TL,  status:VALID,  product: PRP - Proposals ,  description: This table contains the translated information about the tokens. ,  implementation_dba_data: PRP.PRP_TOKENS_TL , 

  • Table: PRP_STYLE_CTNTVER_TOKENS 12.1.1

    owner:PRP,  object_type:TABLE,  fnd_design_data:PRP.PRP_STYLE_CTNTVER_TOKENS,  object_name:PRP_STYLE_CTNTVER_TOKENS,  status:VALID,  product: PRP - Proposals ,  description: This table contains the tokens that are referenced by a component style document. This table is populated when the component document file is uploaded and parsed for tokens. ,  implementation_dba_data: PRP.PRP_STYLE_CTNTVER_TOKENS , 

  • Table: PRP_PROPOSAL_TOKENS 12.2.2

    owner:PRP,  object_type:TABLE,  fnd_design_data:PRP.PRP_PROPOSAL_TOKENS,  object_name:PRP_PROPOSAL_TOKENS,  status:VALID,  product: PRP - Proposals ,  description: This table contains the tokens that are used in proposal and their corresponding values. The tokens stored in this table are only "User Defined" tokens that are of type "Text" or "List of Values". ,  implementation_dba_data: PRP.PRP_PROPOSAL_TOKENS , 

  • Table: PRP_STYLE_CTNTVER_TOKENS 12.2.2

    owner:PRP,  object_type:TABLE,  fnd_design_data:PRP.PRP_STYLE_CTNTVER_TOKENS,  object_name:PRP_STYLE_CTNTVER_TOKENS,  status:VALID,  product: PRP - Proposals ,  description: This table contains the tokens that are referenced by a component style document. This table is populated when the component document file is uploaded and parsed for tokens. ,  implementation_dba_data: PRP.PRP_STYLE_CTNTVER_TOKENS , 

  • Table: PRP_TOKEN_VALUES_TL 12.2.2

    owner:PRP,  object_type:TABLE,  fnd_design_data:PRP.PRP_TOKEN_VALUES_TL,  object_name:PRP_TOKEN_VALUES_TL,  status:VALID,  product: PRP - Proposals ,  description: This table contains the values for the "User Defined" tokens of type "List of Values". This table stores the list of values for each token in each installed language. ,  implementation_dba_data: PRP.PRP_TOKEN_VALUES_TL , 

  • Table: PRP_PROPOSAL_TOKENS 12.1.1

    owner:PRP,  object_type:TABLE,  fnd_design_data:PRP.PRP_PROPOSAL_TOKENS,  object_name:PRP_PROPOSAL_TOKENS,  status:VALID,  product: PRP - Proposals ,  description: This table contains the tokens that are used in proposal and their corresponding values. The tokens stored in this table are only "User Defined" tokens that are of type "Text" or "List of Values". ,  implementation_dba_data: PRP.PRP_PROPOSAL_TOKENS , 

  • View: PRP_TOKENS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PRP.PRP_TOKENS_VL,  object_name:PRP_TOKENS_VL,  status:VALID,  product: PRP - Proposals ,  implementation_dba_data: APPS.PRP_TOKENS_VL , 

  • View: PRP_TOKENS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PRP.PRP_TOKENS_VL,  object_name:PRP_TOKENS_VL,  status:VALID,  product: PRP - Proposals ,  implementation_dba_data: APPS.PRP_TOKENS_VL ,