Results for “adjustment_desc”

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

Overview

OZF_FUNDS_UTILIZED_ALL_TL is the translation (TL) table for fund utilization records within the Oracle Trade Management (OZF) module. It stores language-specific, translatable attribute values for each fund utilization row, allowing descriptive text such as adjustment descriptions to be presented in multiple installed languages defined in Oracle E-Business Suite. The table resides in the OZF schema and is classified as VALID in ETRM 12.1.1 and 12.2.2. Its defining characteristic is the composite primary key formed by UTILIZATION_ID and LANGUAGE, which pairs each utilization record with a language code and enables multilingual presentation of the underlying transactional data.

From a Data Vault modeling perspective, the mined foreign key structure suggests a satellite-leaning classification. The table is dependent on the base table OZF_FUNDS_UTILIZED_ALL_B through UTILIZATION_ID and extends it with descriptive, language-dependent context rather than carrying independent business events. This heuristic classification is a modeling suggestion; the object operates as a dependent translation child in the EBS schema.

Key Information Stored

The table contains 16 documented columns. The most significant are:

• UTILIZATION_ID — Surrogate identifier of the fund utilization record; the FK to OZF_FUNDS_UTILIZED_ALL_B and the first component of the primary key.
• LANGUAGE — Language code for the translated row; the second component of the primary key and the discriminator that makes the table a TL object.
• SOURCE_LANG — The language in which the source (base) value was originally entered.
• ADJUSTMENT_DESC — Translatable free-text description of the adjustment associated with the fund utilization.
• ORG_ID — Operating unit identifier supporting multi-org access control.
• SECURITY_GROUP_ID — FK to FND_SECURITY_GROUPS, controlling security group visibility of the row.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns capturing who last touched the row and when.
• CREATION_DATE, CREATED_BY, CREATED_FROM — Standard creation audit columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program context identifying the process that last created or updated the row.

The unique index OZF_FUNDS_UTILIZED_ALL_TL_U1 (UTILIZATION_ID, LANGUAGE) mirrors the primary key and serves as the business-key candidate, ensuring exactly one translated row per utilization per language.

Common Use Cases and Queries

This table is typically queried via joins to the base table to surface adjustment descriptions in a user's session language. A representative query retrieves the translated description for a given utilization:

• Lookup pattern: SELECT t.UTILIZATION_ID, t.LANGUAGE, t.ADJUSTMENT_DESC FROM OZF_FUNDS_UTILIZED_ALL_TL t WHERE t.UTILIZATION_ID = :utilization_id AND t.LANGUAGE = USERENV('LANG');
• Join pattern for combined base and translated data: join OZF_FUNDS_UTILIZED_ALL_B b to OZF_FUNDS_UTILIZED_ALL_TL t on b.UTILIZATION_ID = t.UTILIZATION_ID.
• Reporting: list all adjustment descriptions for a security group filtered by ORG_ID, honoring multi-org and security group constraints.

Because translations are maintained per language, reporting extracts should always filter on LANGUAGE or SOURCE_LANG to avoid duplicate rows.

Related Objects

• OZF_FUNDS_UTILIZED_ALL_B — Base table holding language-independent fund utilization data; joined on UTILIZATION_ID.
• OZF_FUNDS_UTILIZED_ALL_TL_PK / _U1 — Primary key and unique index enforcing uniqueness on (UTILIZATION_ID, LANGUAGE).
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID for security group access control.
• FND_LANGUAGES — Source of valid LANGUAGE and SOURCE_LANG code values.
• FND_ORG_ACCESS / HR_OPERATING_UNITS — Participant in ORG_ID-based multi-org access control.
• FND_CONCURRENT_PROGRAMS — Referenced via PROGRAM_APPLICATION_ID and PROGRAM_ID for the concurrent process context.