Results for “purpose_name”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FND_BUSINESS_PURPOSES_TL is a translation (TL) table in the APPLSYS schema belonging to the FND — Application Object Library product within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the language-specific, translated attributes of business purposes defined in the base FND_BUSINESS_PURPOSES entity. Business purposes classify the intent or context in which a function, menu, or security construct is used, and they are leveraged heavily by the function security and menu security framework. This TL table holds the user-visible purpose name and description rendered in each installed language, allowing a single business purpose to surface with different labels depending on the session language of the connecting user.

Under the heuristic Data Vault classification provided in the ETRM metadata, FND_BUSINESS_PURPOSES_TL is modeled as a standalone object. Because it carries descriptive, language-dependent attributes keyed to a parent business entity and its translation language rather than pure cross-entity relationships, it is best treated as a satellite-style descriptive table subordinate to the base business purpose entity. The classification is a modeling suggestion rather than a documented constraint.

Key Information Stored

The table is documented with twelve columns. The most significant are summarized below.

• PURPOSE_CODE — The business key identifying the base business purpose. Together with LANGUAGE it forms the unique business-key index FND_BUSINESS_PURPOSES_TL_U1, so the combination is guaranteed unique.
• LANGUAGE — The language code for the translation row (for example US for American English). This is the second component of the unique business-key index and determines which translated row is returned.
• PURPOSE_NAME — The translated, user-visible name of the business purpose shown in forms and list of values.
• DESCRIPTION — The translated descriptive text explaining the purpose of the business purpose.
• DESCRIPTION_INT — An internal (developer-oriented) description field, typically not exposed to end users.
• SOURCE_LANG — The language from which the translated row was derived, used by the translation framework to track the origin language.
• SECURITY_GROUP_ID — A foreign key to FND_SECURITY_GROUPS, scoping the row to a security group as documented by the ETRM relationship data.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS WHO columns capturing audit and session information.

The table has no separate surrogate primary-key column documented; the unique index on PURPOSE_CODE and LANGUAGE functions as the effective business key.

Common Use Cases and Queries

The primary use case is resolving the display label for a business purpose in the user's language. A typical lookup selects the translated name for a given purpose and session language:

• A translation-coverage report identifies purposes missing translated rows by comparing the base table against the TL table for each installed LANGUAGE.
• Menu and function security definitions frequently embed PURPOSE_CODE references; reporting layers join back to this TL table to render readable names.
• A completeness query can list all PURPOSE_CODE values lacking a row for a target language to drive translation maintenance.

A representative query joining the base entity to its translations follows: select b.purpose_code, t.purpose_name, t.description from fnd_business_purposes b, fnd_business_purposes_tl t where b.purpose_code = t.purpose_code and t.language = userenv('LANG').

Related Objects

• FND_BUSINESS_PURPOSES — The base (untranslated) table linked on PURPOSE_CODE.
• FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID, per documented FK.
• FND_FUNCTIONS — Frequently carries business purpose related attributes exposed in function security.
• FND_MENUS — Menu definitions referencing business purposes for security accounting.
• FND_APPLICATION — Product context for purposes owned by specific applications.
• FND_LANGUAGES — Provides the LANGUAGE codes against which translated rows are validated.