Search Results statement_group_id

Overview

AMW_FIN_STMNT_ITEMS_TL is a translation (TL) table belonging to the Oracle Internal Controls Manager (AMW) product family. It stores the language-specific display names for financial statement items defined within the AMW financial reporting framework. Because financial line items are presented to auditors, compliance officers, and reporting users across multiple locales, the base definition table (AMW_FIN_STMNT_ITEMS_B) holds the canonical attributes while this companion table holds the translated NAME values consumed at runtime by the Oracle EBS multi-language architecture.

The metadata classifies this object as standalone under the heuristic Data Vault modeling suggestion. That is, it does not act as a hub (no single immutable business key), a link (no many-to-many resolution role), or a distinct satellite in the classic sense; it is a dependent translation table whose lifecycle is fully governed by its parent financial item definition.

Note the metadata flag "Not implemented in this database" and the product designation "(Obsolete)." In 12.1.1 and 12.2.2 environments where the AMW module was never licensed or was decommissioned, the object may not exist physically. Where present, it is owned by the AMW schema.

Key Information Stored

The table carries 14 documented columns. The most significant are the composite key members and the translated content:

• STATEMENT_GROUP_ID — Identifier of the statement group to which the financial item is scoped; the leading column of the primary key and the column most frequently used to filter reporting hierarchies.
• FINANCIAL_STATEMENT_ID — Identifier of the parent financial statement definition.
• FINANCIAL_ITEM_ID — Identifier of the individual financial line item being translated.
• LANGUAGE — The language code of the translated NAME; completes the primary key.
• NAME — The translated display name of the financial item, the payload of the table.
• SOURCE_LANGUAGE and SOURCE_LANG — Identify the language of the originating (base) record, supporting Oracle's MLS translation workflow.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing row-level access partitioning.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the OAF/BC4J framework to detect concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns maintained by the EBS framework.

The surrogate-uniqueness is expressed by AMW_FIN_STMNT_ITEMS_TL_PK over (STATEMENT_GROUP_ID, FINANCIAL_STATEMENT_ID, FINANCIAL_ITEM_ID, LANGUAGE). A second unique index, AMW_FIN_STMNT_ITEMS_TL_U1, covers the same four-column business-key candidate set. There is no single surrogate ID column; the composite is the identity.

Common Use Cases and Queries

The dominant access pattern is joining the translation back to the base definition to render a localized item name, filtered by the statement group the user selected. Because the user search term was "statement_group_id," the most common query filters directly on that leading key column:

• Localized statement rendering: SELECT t.FINANCIAL_ITEM_ID, t.NAME FROM AMW_FIN_STMNT_ITEMS_TL t WHERE t.STATEMENT_GROUP_ID = :p_group_id AND t.LANGUAGE = USERENV('LANG');
• Translation coverage audit: identify items lacking a translation in a target language by comparing the TL row count against the base table for a given STATEMENT_GROUP_ID.
• Statement group content listing: SELECT STATEMENT_GROUP_ID, FINANCIAL_STATEMENT_ID, FINANCIAL_ITEM_ID, LANGUAGE, NAME FROM AMW_FIN_STMNT_ITEMS_TL WHERE STATEMENT_GROUP_ID = :id ORDER BY FINANCIAL_STATEMENT_ID, FINANCIAL_ITEM_ID;
• Multi-language reporting: pivot on LANGUAGE to present English, French, and German labels side by side for a single statement group.

Because the table is translation-only, no transactional or numeric data resides here; reporting queries always join to sibling AMW tables for amounts or structure.

Related Objects

• FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID for access partitioning.
• AMW_FIN_STMNT_ITEMS_B — The base (untranslated) definition table; the canonical parent supplying the same three key columns plus non-translated attributes.
• AMW_FIN_STMNT_ITEMS — The runtime view that merges base and TL rows according to the session language.
• AMW_FINANCIAL_STATEMENTS — Parent statement definition referenced via FINANCIAL_STATEMENT_ID.
• AMW_STATEMENT_GROUPS — Defines the statement groups keyed by STATEMENT_GROUP_ID.
• FND_LANGUAGES — Validates the LANGUAGE and SOURCE_LANG codes.
• FND_APPLICATION / AMW setup APIs — Responsible for populating and maintaining translation rows during implementation and patching.