Search Results ja_cn_dff_title_type

Overview

APPS.JA_CN_DFF_ASSIGNMENTS_V is an Oracle E-Business Suite view that reconciles the set of Descriptive Flexfield (DFF) title codes available for the China localizations of the Payables/Receivables DFF framework against the DFF titles actually assigned to each General Ledger chart of accounts. The view is owned by the APPS schema and is available in E-Business Suite 12.1.1 and 12.2.2. Its purpose is to present a unified list, per chart of accounts, of every valid DFF title code — whether or not an assignment record exists — so that setup and reporting users can observe, at a glance, which titles have been allocated to a given chart of accounts and which remain unassigned.

Because the view is a UNION ALL of two complementary result sets, it functions as both a completeness report and an assignment register. The first branch synthesizes one row for every DFF title lookup code that is not yet present in the JA_CN_DFF_ASSIGNMENTS table for a given chart of accounts, supplying NULLs for the assignment-related columns. The second branch returns the actual assignment rows joined to their lookup definitions. The result is a single ordered result set keyed by chart of accounts and lookup code.

Underlying Base Objects

The view is defined over three referenced objects, all of which the ETRM metadata lists as synonyms: JA_CN_DFF_ASSIGNMENTS, FND_LOOKUP_VALUES, and FND_ID_FLEX_STRUCTURES_TL. JA_CN_DFF_ASSIGNMENTS is the core assignment table, holding the chart of accounts identifier, application identifier, descriptive flexfield name, DFF title code, context code, attribute column, and standard WHO audit columns. FND_LOOKUP_VALUES supplies the lookup definitions for lookup type JA_CN_DFF_TITLE_TYPE, providing the lookup code, meaning, and description, and applying enablement flags, language, and effective date filtering. FND_ID_FLEX_STRUCTURES_TL supplies the distinct set of chart of accounts identifiers where ID_FLEX_CODE equals 'GL#', together with their translated names.

The view's first branch cross-joins FND_LOOKUP_VALUES with the distinct chart of accounts list from FND_ID_FLEX_STRUCTURES_TL and excludes any combination already recorded in JA_CN_DFF_ASSIGNMENTS via a NOT EXISTS clause. The second branch joins FND_LOOKUP_VALUES directly to JA_CN_DFF_ASSIGNMENTS on DFF_TITLE_CODE. Both branches emit the identical column list, allowing the UNION ALL to produce a homogeneous result set.

Key Columns

• ROW_ID — NULL in the synthesized branch; the ROWID of the underlying assignment row in the assignment branch. It is the practical discriminator between assigned and unassigned titles.
• CHART_OF_ACCOUNTS_ID — The chart of accounts (ID_FLEX_NUM) to which the DFF title applies.
• APPLICATION_ID — Application owning the descriptive flexfield; NULL for unassigned titles.
• DESCRIPTIVE_FLEXFIELD_NAME — Name of the target DFF; NULL for unassigned titles.
• DFF_TITLE_CODE — The assigned title code; NULL in the synthesized branch.
• CONTEXT_CODE and ATTRIBUTE_COLUMN — Context and attribute segment targeted by the assignment.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns, populated only for existing assignment rows.
• LOOKUP_CODE, MEANING, DESCRIPTION — The DFF title definition drawn from FND_LOOKUP_VALUES, populated in both branches.

Common Use Cases and Queries

The view is typically queried to review DFF title coverage across charts of accounts, to identify unassigned titles before configuration, and to drive validation or reconciliation reports. A representative query lists assignments for a specific chart of accounts:

• SELECT chart_of_accounts_id, dff_title_code, context_code, attribute_column, meaning FROM apps.ja_cn_dff_assignments_v WHERE chart_of_accounts_id = :coa_id ORDER BY lookup_code;
• Identifying unassigned titles: filter on WHERE row_id IS NULL to return only synthesized rows representing titles not yet mapped.
• Coverage reporting: group by chart_of_accounts_id and count distinct lookup codes to gauge completeness of DFF title configuration per chart of accounts.

Because the view relies on USERENV('LANG') and effective dating of lookup values, query results reflect the session language and the active period of each lookup, which must be considered when comparing results across environments.