Results for “per_cagr_api_parameters_tl”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PER_CAGR_API_PARAMETERS_TL is a translation ("_TL") table in the HR schema of Oracle E-Business Suite, holding language-specific display text for the parameters used by the Collective Agreement (CAGR) API infrastructure in Oracle Human Resources. In EBS 12.1.1 and 12.2.2, the base table PER_CAGR_API_PARAMETERS stores the translatable-entity definition for each API parameter row, while this "_TL" companion stores the actual translated values keyed by language. This design allows the same parameter to be presented in multiple installed languages within a multi-language deployment.
Because the table carries both a surrogate identifier and descriptive attributes but no foreign key references to other tables in the documented relationship metadata, the heuristic Data Vault classification suggested by the ETRM mining is standalone. From a modeling perspective, this object behaves most like a satellite attached to the parameter entity, since it supplies descriptive translation columns (DISPLAY_NAME, SOURCE_LANG) rather than acting as a hub or a link between entities.
Key Information Stored
The table contains 10 documented columns. The most significant are:
- CAGR_API_PARAM_ID — the surrogate identifier of the parameter definition. It forms part of the primary key and links each translated row back to its base parameter entity.
- LANGUAGE — the NLS language code identifying which installed language the translated text belongs to. Together with CAGR_API_PARAM_ID it forms the business-key candidate PER_CAGR_API_PARAMETERS_TL_PK.
- ZD_EDITION_NAME — the editioning column introduced in EBS 12.2.2 to support Online Patching (adop). It is part of the unique index PER_CAGR_API_PARAMETERS_TL_PK (CAGR_API_PARAM_ID, LANGUAGE, ZD_EDITION_NAME).
- DISPLAY_NAME — the translated, user-visible name of the API parameter shown on HR forms and reports.
- SOURCE_LANG — the language of the source text from which the translation was derived.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — the standard EBS WHO columns providing audit history (who created or last modified the row and when).
The surrogate primary key is defined by the combination (CAGR_API_PARAM_ID, LANGUAGE), extended to include ZD_EDITION_NAME in the 12.2.2 editioning model. Note that only CAGR_API_PARAM_ID and LANGUAGE are true business-key candidates; the WHO columns are audit attributes, not keys.
Common Use Cases and Queries
Typical usage centers on retrieving the correct display text for a parameter in the session's language. Two frequent query patterns are:
- Lookup by identifier and language:
SELECT display_name FROM per_cagr_api_parameters_tl WHERE cagr_api_param_id = :p_id AND language = USERENV('LANG'); - Report joining base to translation:
SELECT b.cagr_api_param_id, t.display_name FROM per_cagr_api_parameters b, per_cagr_api_parameters_tl t WHERE b.cagr_api_param_id = t.cagr_api_param_id AND t.language = USERENV('LANG') AND t.zd_edition_name = 'SET1';
Reporting scenarios include generating a language-specific catalogue of CAGR API parameters, auditing which parameters have translations missing for a given LANGUAGE, and validating display names before releasing a patch. Administrators also query the table when troubleshooting display issues in multi-language installations, since a missing translated row causes the base-language value to be shown instead.
Related Objects
Although the mined relationship data classifies this object as standalone, in practice it is tightly coupled with the following components of the CAGR/PER infrastructure:
- PER_CAGR_API_PARAMETERS (base table) — the parent translatable entity, joined on CAGR_API_PARAM_ID.
- PER_CAGR_API_PARAMETERS_TL_PK — the unique index enforcing uniqueness of (CAGR_API_PARAM_ID, LANGUAGE, ZD_EDITION_NAME).
- PER_CAGR_API_PARAMETERS depends on the CAGR API setup forms and concurrent programs that display parameter prompts.
- PER_CAGR_API_PARAMETERS_TL is referenced by the Oracle HRMS collective agreement API configuration and by the FND language/NLS framework that supplies the LANGUAGE values.
- Standard EBS translation utilities and the FND_LANGUAGES table supply the installed language codes used in the LANGUAGE and SOURCE_LANG columns.
Developers working with the CAGR API should treat this table as read-only reference data and always filter on the current session language and edition name to obtain correct, patch-safe results in an EBS 12.2.2 environment.
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
eTRM - PER Tables and Views 12.2.2
Table to store NQF Training info for a person
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
eTRM - PER Tables and Views 12.2.2
Table to store NQF Training info for a person