Results for “dff_title_code”

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

Overview

The JA_CN_DFF_ASSIGNMENTS table is a localization configuration object owned by the JA schema (Asia/Pacific Localizations). It stores the context codes and attribute column mappings for every Descriptive Flexfield (DFF) consumed by the CNAO (China National Accounting Office) reporting programs. Each row identifies a single Descriptive Flexfield by its application identifier and flexfield name, then maps a specific context and attribute segment to its underlying database column. In practice, this table functions as a metadata registry that allows CNAO processes to locate the appropriate flexfield segment values without hard-coding column names.

Under the heuristic Data Vault classification supplied in the ETRM metadata, this object is treated as standalone. In Data Vault modeling terms it is best understood as a reference satellite around the chart of accounts, since its only documented foreign key points to GL_MGT_SEG_UPGRADE_H. It carries descriptive mapping attributes rather than transaction facts, and it does not behave as a transaction hub or link.

Key Information Stored

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

• CHART_OF_ACCOUNTS_ID – Identifies the chart of accounts to which the DFF assignment applies; part of the business key and the FK relationship.
• DFF_TITLE_CODE – The flexfield title code that labels the assignment; the second component of the unique business key.
• APPLICATION_ID – The application owning the Descriptive Flexfield.
• DESCRIPTIVE_FLEXFIELD_NAME – The internal flexfield name used to locate the definition.
• CONTEXT_CODE – The context value under which the flexfield segment is registered.
• ATTRIBUTE_COLUMN – The physical column name in which the flexfield segment value is stored.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard audit columns that record who created and last modified each assignment row.

The unique index JA_CN_DFF_ASSIGNMENTS_U1 on (CHART_OF_ACCOUNTS_ID, DFF_TITLE_CODE) is the documented business-key candidate, allowing one assignment per chart of accounts and flexfield title. No separate surrogate primary-key column is documented in the metadata; the composite unique index effectively acts as the identifier.

Common Use Cases and Queries

The primary use case is dynamic flexfield resolution inside CNAO reporting routines. Reports and interfaces join this table to flexfield value tables using APPLICATION_ID, DESCRIPTIVE_FLEXFIELD_NAME, and CONTEXT_CODE to recover the correct ATTRIBUTE_COLUMN before reading the segment value.

A typical lookup query is:

• SELECT context_code, attribute_column FROM ja.ja_cn_dff_assignments WHERE chart_of_accounts_id = :coa_id AND dff_title_code = :title;

Reporting use cases include reconciling which flexfields are configured for a given chart of accounts, auditing changes to flexfield assignments over time using the audit columns, and troubleshooting CNAO extraction failures where an expected context or attribute column is missing.

Related Objects

The documented foreign key links this table to GL_MGT_SEG_UPGRADE_H through CHART_OF_ACCOUNTS_ID. Other objects that interact with it in practice include:

• GL_MGT_SEG_UPGRADE_H – Parent of the documented FK on CHART_OF_ACCOUNTS_ID.
• FND_DESCRIPTIVE_FLEXS – Resolves APPLICATION_ID and DESCRIPTIVE_FLEXFIELD_NAME to the flexfield definition.
• FND_FLEX_VALUES / FND_FLEX_VALUES_TL – Provide context and segment values for the referenced context code.
• GL_CODE_COMBINATIONS – Supplies the chart of accounts context used by CNAO reporting.
• FND_FLEX_VALIDATION_TABLES – Defines the table and column metadata that the ATTRIBUTE_COLUMN values point to.