Search Results statement_group_id




Overview
Explore in AI Chat

Overview

The table AMW.AMW_FIN_STMNT_ITEMS_TL is a translation (TL) table within the Oracle E-Business Suite Financial Statement Generator / AMW schema. It stores the language-dependent names of financial statement items that are imported into the AMW module. Because Oracle EBS implements multilingual support through paired base and translation tables, the base table holds the source-language records, while this TL table holds one row per installed language, each carrying the translated NAME of a given financial item. The table resides in the APPS_TS_TX_DATA tablespace and is owned by the AMW schema, with a status of VALID in the 12.1.1 ETRM documentation (also applicable to 12.2.2).

From a Data Vault modeling perspective, the heuristic classification of this object is standalone. It does not reference any other database object through an enforced foreign-key relationship other than its optional link to FND_SECURITY_GROUPS via SECURITY_GROUP_ID. This means the table is largely self-contained, with its uniqueness governed entirely by its composite primary key rather than by a hub-and-satellite structure. The absence of parent dependencies and child dependencies within the catalog reinforces that AMW_FIN_STMNT_ITEMS_TL is a leaf-level descriptive object.

Key Information Stored

The most significant columns define both the identity of a translated financial item and the audit context surrounding it:

  • STATEMENT_GROUP_ID (NUMBER) — A Set ID that groups all financial statements imported during the same import run. This is a leading component of the primary key and of the unique index AMW_FIN_STMNT_ITEMS_TL_U1.
  • FINANCIAL_STATEMENT_ID (NUMBER) — Identifies the parent financial statement to which the item belongs.
  • FINANCIAL_ITEM_ID (NUMBER) — The surrogate identifier of the financial item itself.
  • LANGUAGE (VARCHAR2) — The language of the translated name stored on this row. Combined with the three IDs above, it forms the composite primary key.
  • NAME (VARCHAR2, 240) — The translated display name of the financial item; the primary payload of the TL table.
  • SOURCE_LANGUAGE / SOURCE_LANG (VARCHAR2) — The originating language from which the translation was derived.
  • SECURITY_GROUP_ID (NUMBER) — Used in hosted environments; the only documented foreign key, referencing FND_SECURITY_GROUPS.
  • OBJECT_VERSION_NUMBER (NUMBER) — Supports optimistic locking for concurrent updates.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking record creation and modification.

The composite primary key is AMW_FIN_STMNT_ITEMS_TL_PK (STATEMENT_GROUP_ID, FINANCIAL_STATEMENT_ID, FINANCIAL_ITEM_ID, LANGUAGE). The unique index AMW_FIN_STMNT_ITEMS_TL_U1 mirrors these same four columns, confirming they are the business-key candidates for this object.

Common Use Cases and Queries

Typical usage centers on resolving a financial item's display name for a specific language, or enumerating all translated items within an import group. A common pattern filters by the identifier columns indexed in the unique key:

  • Retrieve the translated name for a single item: SELECT NAME FROM AMW.AMW_FIN_STMNT_ITEMS_TL WHERE STATEMENT_GROUP_ID = :gid AND FINANCIAL_STATEMENT_ID = :sid AND FINANCIAL_ITEM_ID = :iid AND LANGUAGE = USERENV('LANG');
  • List all items (with English names) for a given statement group: SELECT FINANCIAL_STATEMENT_ID, FINANCIAL_ITEM_ID, NAME FROM AMW.AMW_FIN_STMNT_ITEMS_TL WHERE STATEMENT_GROUP_ID = :gid AND LANGUAGE = 'US';
  • Cross-reference the base table to detect missing translations: join AMW_FIN_STMNT_ITEMS_B to AMW_FIN_STMNT_ITEMS_TL on the four key columns and filter where the TL row is null.
  • Compare source and target language values for QA of an import run using SOURCE_LANGUAGE versus LANGUAGE.

Reporting use cases include multilingual financial statement listings, translation completeness audits, and tracking which items were loaded in a specific import batch. Because NAME is length-limited to 240 characters, truncation checks are also a valid QA query.

Related Objects

The documented metadata identifies a limited set of relationships. The most significant related objects are:

  • AMW.AMW_FIN_STMNT_ITEMS_TL (APPS synonym) — The APPS-schema synonym referencing this table, used by concurrency-enabled forms and reports.
  • FND_SECURITY_GROUPS — Referenced via the foreign key SECURITY_GROUP_ID, used in hosted (multi-tenant) environments to scope data.
  • AMW_FIN_STMNT_ITEMS_B — The base (non-translated) table assumed to hold source-language names; joins on STATEMENT_GROUP_ID, FINANCIAL_STATEMENT_ID, FINANCIAL_ITEM_ID, and LANGUAGE.
  • AMW.AMW_FIN_STMNT_ITEMS_TL_PK — The composite primary key constraint enforcing uniqueness on the four key columns.
  • AMW.AMW_FIN_STMNT_ITEMS_TL_U1 — The unique index replicating the business key on APPS_TS_TX_IDX.

Practical joins therefore occur primarily between this TL table and its base counterpart, with secondary filtering through the security group reference. No other dependencies are documented in the ETRM metadata for this object.