Search Results dff_title_code

Overview

JA_CN_DFF_ASSIGNMENTS_V is an APPS-owned view in the Oracle E-Business Suite FND (Application Object Library) product, documented in ETRM 12.2.2 and valid in 12.1.1 as well. It presents the assignment of Descriptive Flexfield (DFF) title codes to accounting flexfield structures for the China localization (JA_CN), exposing one row per combination of chart of accounts and DFF title code. The view is a reporting and integration artifact: it answers, for each chart of accounts, which DFF title codes are either already assigned or still available for assignment. Because the DFF_TITLE_CODE column is central to its definition, the view is frequently surfaced when users search for dff_title_code in the context of Chinese localization flexfield configuration.

The view does not store data itself; it is a UNION ALL of two complementary result sets. The first returns unassigned lookup codes with most descriptive columns nulled and a null ROW_ID, signalling "available for assignment." The second returns the actual configured assignments from JA_CN_DFF_ASSIGNMENTS with a live ROWID, enabling the view to be used in an updatable context.

Underlying Base Objects

ETRM records three referenced base objects, all accessed through APPS synonyms:

• FND_ID_FLEX_STRUCTURES_TL — filtered to ID_FLEX_CODE = 'GL#'. A DISTINCT list of ID_FLEX_NUM values supplies the charts of accounts that anchor each row.
• FND_LOOKUP_VALUES — supplies the DFF title codes via lookup type JA_CN_DFF_TITLE_TYPE, restricted to enabled lookups and the session language, with effective dating enforced through START_DATE_ACTIVE and END_DATE_ACTIVE.
• JA_CN_DFF_ASSIGNMENTS — the transactional table containing the actual chart-of-accounts-to-DFF-title-code assignments. The first branch excludes rows that exist here via NOT EXISTS; the second branch reads them directly.

Key Columns

• ROW_ID — ROWID of the JA_CN_DFF_ASSIGNMENTS row for assigned entries; NULL for unassigned lookup entries.
• CHART_OF_ACCOUNTS_ID — the ID_FLEX_NUM of the GL# accounting flexfield structure.
• APPLICATION_ID, DESCRIPTIVE_FLEXFIELD_NAME, CONTEXT_CODE, ATTRIBUTE_COLUMN — flexfield metadata propagated from the assignment table; NULL in the unassigned branch.
• DFF_TITLE_CODE — the lookup code identifying the DFF title; NULL in the unassigned branch and populated in the assigned branch.
• LOOKUP_CODE, MEANING, DESCRIPTION — lookup values from FND_LOOKUP_VALUES describing the DFF title code.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns, populated only for assigned rows.

Common Use Cases and Queries

A primary use case is enumerating all charts of accounts alongside the DFF title codes still available for assignment:

• SELECT CHART_OF_ACCOUNTS_ID, LOOKUP_CODE, MEANING FROM JA_CN_DFF_ASSIGNMENTS_V WHERE ROW_ID IS NULL ORDER BY 1,2;
• SELECT CHART_OF_ACCOUNTS_ID, DFF_TITLE_CODE, MEANING FROM JA_CN_DFF_ASSIGNMENTS_V WHERE ROW_ID IS NOT NULL;
• SELECT DISTINCT CHART_OF_ACCOUNTS_ID FROM JA_CN_DFF_ASSIGNMENTS_V ORDER BY 1;

The view supports localization configuration reports, migration validation scripts, and reconciliation between configured assignments and their lookup definitions. Queries targeting the unassigned branch must test ROW_ID IS NULL, since DFF_TITLE_CODE is null there. Because FND_LOOKUP_VALUES is filtered by USERENV('LANG') and effective dates, results depend on the session language and current date.