Results for “action_desc”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
GMD_ACTIONS_TL is the translation table for OPM Quality action codes within the Oracle E-Business Suite Process Manufacturing Product Development (GMD) module. In Oracle EBS Release 12.1.1 and 12.2.2, the "_TL" suffix denotes a translated table that stores language-specific descriptive text for a base entity — in this case, quality action definitions used in Process Manufacturing quality workflows. Each row supplies the translated description of an action code in a specific installed language.
Structurally, the object is a narrow, language-keyed reference table. The ETRM metadata classifies it heuristically as standalone, meaning it does not participate in a large web of enforced foreign-key links. Under a Data Vault modeling lens, this data object most naturally maps to a satellite — descriptive, descriptive-of-key attributes (the translated descriptions) attached to the business key formed by action code plus language. It could also be treated as a small reference/dimension table in a conventional star schema.
Key Information Stored
The table holds nine documented columns. The most significant are:
- ACTION_CODE — the business identifier for the quality action; part of the composite primary key.
- LANGUAGE — the language identifier for the translated row; the second component of the composite primary key.
- ACTION_DESC — the translated description of the action code, which is the primary payload of the translation table.
- SOURCE_LANG — the source language from which the translation was derived, supporting multilingual maintenance.
- CREATION_DATE, CREATED_BY — audit columns recording when and by whom the row was inserted.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — audit columns capturing the most recent modification and the login context of the updater.
The surrogate primary key is defined by GMD_ACTIONS_TL_PK, comprising ACTION_CODE and LANGUAGE. Because the same composite of columns also forms the unique index, the primary key is simultaneously the business-key candidate; there is no separate meaningless surrogate. The combination of action code and language uniquely identifies each translated description and guarantees one description per action per language.
Common Use Cases and Queries
Typical usage centers on presenting action descriptions in the user's session language. A common pattern joins the translation table to the base action table so that only rows matching the current language are returned:
- Resolving the display name for an action code in a specific language: SELECT action_desc FROM gmd_actions_tl WHERE action_code = :code AND language = USERENV('LANG').
- Auditing which action codes have translations for a given language, useful when deploying a new language and verifying coverage.
- Comparing ACTION_DESC against SOURCE_LANG to detect rows that fall back to the base language because no local translation exists.
- Integration and migration scripts that load translated text for quality actions during multi-language implementations.
- Reporting on the multilingual completeness of quality action definitions across the enterprise.
Because the object is standalone, queries generally drive from a base action or quality configuration table and pick up descriptions via a join on ACTION_CODE and LANGUAGE.
Related Objects
As a translation table, GMD_ACTIONS_TL is referenced primarily through the base action entity rather than through enforced foreign keys. The most significant related objects are:
- GMD_ACTIONS (base table) — the untranslated action definitions joined on ACTION_CODE.
- GMD_ACTIONS_B — the base-table variant holding the canonical action rows.
- FND_LANGUAGES — the language registry, joined on LANGUAGE to validate installed languages.
- OPM Quality setup and specification screens that display action descriptions to the user.
- Public APIs and concurrent programs in the GMD module that resolve action descriptions during processing.
- Translation-maintenance utilities and the standard "_TL" pattern objects within the same schema.
Because the metadata indicates a standalone classification, no strong foreign-key dependencies are documented; joins to base and language tables are performed logically on the shared business keys.
-
OPM Quality Translation table
-
ISIR Reject Codes Table
-
View: JTF_R_RULES_VL 12.2.2
Provide Rule langauge specific information
APPS.JTF_R_RULES_VL·↳ JTF_R_RULES_B·↳ JTF_R_RULES_TL·Explore JTF module →
-
rule definition translation table
-
View: CS_SR_ACTIVITIES_V 12.1.1
This view is to list all the activities associated to a service requst.
APPS.CS_SR_ACTIVITIES_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ JTF_IH_ACTIONS_TL·Explore CS module →
-
OPM Quality Translation table
-
View: JTF_R_RULES_VL 12.1.1
Provide Rule langauge specific information
APPS.JTF_R_RULES_VL·↳ JTF_R_RULES_B·↳ JTF_R_RULES_TL·Explore JTF module →
-
View: JTF_R_RULES_V 12.2.2
view for rules
APPS.JTF_R_RULES_V·↳ JTF_R_RULES_B·↳ JTF_R_RULES_VL·Explore JTF module →
-
View: CS_SR_ACTIVITIES_V 12.2.2
This view is to list all the activities associated to a service requst.
APPS.CS_SR_ACTIVITIES_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ JTF_IH_ACTIONS_TL·Explore CS module →
-
View: GMD_ACTIONS_VL 12.2.2
OPM Quality Actions View
APPS.GMD_ACTIONS_VL·↳ GMD_ACTIONS_B·↳ GMD_ACTIONS_TL·Explore GMD module →
-
QC action codes.
-
View: GMD_ACTIONS_VL 12.1.1
OPM Quality Actions View
APPS.GMD_ACTIONS_VL·↳ GMD_ACTIONS_B·↳ GMD_ACTIONS_TL·Explore GMD module →
-
Translated view of the related Action (JTF_IH_ACTIONS_VL) and Action Item (JTF_IH_ACTION_ITEMS_VL) pairs. Used to default Interaction Activity wrap-up values.
APPS.JTF_IH_ACTION_ACTION_ITEMS_VL·↳ JTF_IH_ACTIONS_VL·↳ JTF_IH_ACTION_ACTION_ITEMS·↳ JTF_IH_ACTION_ITEMS_VL·Explore JTF module →
-
rule definition translation table
-
View: IGS_PE_DEPD_ACTIVE_V 12.1.1
Person Dependent Relationship Active Information
APPS.IGS_PE_DEPD_ACTIVE_V·↳ IGS_LOOKUP_VALUES·↳ IGS_PE_DEPD_ACTIVE·Explore IGS module →
-
View: JTF_R_RULES_V 12.1.1
view for rules
APPS.JTF_R_RULES_V·↳ JTF_R_RULES_B·↳ JTF_R_RULES_VL·Explore JTF module →
-
Translated view of the related Action (JTF_IH_ACTIONS_VL) and Action Item (JTF_IH_ACTION_ITEMS_VL) pairs. Used to default Interaction Activity wrap-up values.
APPS.JTF_IH_ACTION_ACTION_ITEMS_VL·↳ JTF_IH_ACTIONS_VL·↳ JTF_IH_ACTION_ACTION_ITEMS·↳ JTF_IH_ACTION_ITEMS_VL·Explore JTF module →
-
View: AST_ACTIVITIES_V 12.1.1
APPS.AST_ACTIVITIES_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ JTF_IH_ACTIONS_TL·Explore AST module →
-
View: OKL_CS_ACTIVITIES_UV 12.1.1
APPS.OKL_CS_ACTIVITIES_UV·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ JTF_IH_ACTIONS_TL·Explore OKL module →
-
QC action codes.
-
View: AST_ACTIVITIES_V 12.2.2
APPS.AST_ACTIVITIES_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ JTF_IH_ACTIONS_TL·Explore AST module →
-
View: CSC_ACTIVITIES_V 12.1.1
View of JTF_IH_ACTIVITIES. This view is used to get activities for an interaction
APPS.CSC_ACTIVITIES_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ JTF_IH_ACTIONS_TL·Explore CSC module →
-
View: CSC_ACTIVITIES_V 12.2.2
View of JTF_IH_ACTIVITIES. This view is used to get activities for an interaction
APPS.CSC_ACTIVITIES_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ JTF_IH_ACTIONS_TL·Explore CSC module →
-
View: OKL_CS_ACTIVITIES_UV 12.2.2
APPS.OKL_CS_ACTIVITIES_UV·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ JTF_IH_ACTIONS_TL·Explore OKL module →
-
VIEW: JTF.JTF_R_RULES_TL# 12.2.2
-
VIEW: GMD.GMD_ACTIONS_TL# 12.2.2
-
VIEW: GMD.GMD_ACTIONS_TL# 12.2.2
-
VIEW: GMD.QC_ACTN_MST_OLD# 12.2.2
-
VIEW: GMD.QC_ACTN_MST_BAK# 12.2.2
-
TABLE: GMD.GMD_ACTIONS_TL 12.2.2
-
View: IGS_PE_DEPD_ACTIVE_V 12.2.2
Person Dependent Relationship Active Information
Not implemented in this database·Explore IGS module →
-
TABLE: GMD.GMD_ACTIONS_TL 12.1.1
-
VIEW: GMD.QC_ACTN_MST# 12.2.2
-
VIEW: JTF.JTF_R_RULES_TL# 12.2.2
-
VIEW: APPS.JTF_R_RULES_VL 12.1.1
-
VIEW: APPS.JTF_R_RULES_V 12.2.2