Search Results ja_cn_dff_assignments_u1

Overview

JA.JA_CN_DFF_ASSIGNMENTS is a registration and mapping table in the Oracle E-Business Suite JA (Oracle Financials for China) schema. It stores the context codes and attribute column names for every Descriptive Flexfield (DFF) consumed by the programs that implement the Solution for China Accounting Software Data Interface Standard. In practical terms, the table acts as a catalog that tells the Chinese accounting interface which flexfield contexts and segments must be read, translated, and exported when financial data is transferred between Oracle EBS and the Chinese statutory accounting format.

Each row is anchored by an application identifier and a descriptive flexfield name, which together identify a single DFF. A companion column, DFF_TITLE_CODE, stores a lookup code used to render a translatable, user-facing description of the flexfield. The metadata documents a one-to-one relationship between DFF_TITLE_CODE and the combination of APPLICATION_ID and DESCRIPTIVE_FLEXFIELD_NAME. The table resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10, and its unique index resides in APPS_TS_TX_IDX. The heuristic Data Vault classification is standalone, which suggests modeling this as an independent reference or lookup structure rather than as a hub, link, or satellite in a formal Data Vault design.

Key Information Stored

The most significant columns are:

• APPLICATION_ID (NUMBER, 10) — identifies the Oracle application that owns the flexfield; part of the business key.
• DESCRIPTIVE_FLEXFIELD_NAME (VARCHAR2, 40) — the internal name of the DFF being registered; the second component of the DFF identity.
• DFF_TITLE_CODE (VARCHAR2, 30) — lookup code resolving to a translatable title for the flexfield; part of the unique index.
• CONTEXT_CODE (VARCHAR2, 30) — the DFF context code whose attributes are exposed through this assignment.
• ATTRIBUTE_COLUMN (VARCHAR2, 30) — one of the attribute columns defined for the context, providing the physical segment reference.
• CHART_OF_ACCOUNTS_ID (NUMBER, 15) — chart of accounts identifier scoping the assignment; part of the unique index.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns tracking row provenance and change history.

There is no single-column surrogate primary key in the documented schema. The unique index JA_CN_DFF_ASSIGNMENTS_U1 on (CHART_OF_ACCOUNTS_ID, DFF_TITLE_CODE) is the documented business-key candidate. Note that the unique index does not include APPLICATION_ID or DESCRIPTIVE_FLEXFIELD_NAME, even though those columns carry the DFF identity described in the header text — this is a characteristic of the table's design worth verifying against the live data dictionary.

Common Use Cases and Queries

Typical usage centers on flexfield discovery and data extraction for the China accounting interface. A reporting query to list all registered DFF assignments for a given chart of accounts follows this pattern:

• SELECT application_id, descriptive_flexfield_name, dff_title_code, context_code, attribute_column FROM ja.ja_cn_dff_assignments WHERE chart_of_accounts_id = :coa_id ORDER BY descriptive_flexfield_name, context_code;
• Joining to FND_DESCRIPTIVE_FLEXS or FND_FLEX_VALUES to resolve context and attribute meanings for display.
• Joining to FND_LOOKUPS on DFF_TITLE_CODE to render the translatable flexfield title in the user's language.
• Driving dynamic extraction of flexfield segment values for outbound Chinese statutory reporting files.
• Auditing configuration completeness when a new chart of accounts or legislative context is introduced.

Because the table is effectively a configuration catalog, updates should be performed through the China accounting setup flows rather than by direct DML.

Related Objects

The documented foreign key references GL_MGT_SEG_UPGRADE_H via CHART_OF_ACCOUNTS_ID, linking each assignment to the chart of accounts management history. Other significant related objects include FND_DESCRIPTIVE_FLEXS (flexfield definition), FND_FLEX_VALUES and FND_FLEX_VALUE_SETS (context and segment values), FND_LOOKUPS (title code translation), and the JA China interface program tables that consume these assignments. Broadly, the FK relationship with GL_MGT_SEG_UPGRADE_H is the primary documented dependency; the flexfield and lookup relations are functional rather than enforced.