Search Results analytical_criterion

Overview

The view APPS.JA_CN_CFS_ITEM_MAPPING_HDRS_V is a reporting and integration construct within the Oracle E-Business Suite (EBS) localization layer for China, documented in ETRM for release 12.1.1 and 12.2.2. Its name derives from the country-specific (JA_CN) functional area, where "CFS" refers to the China Financial Statements feature, and "ITEM_MAPPING_HDRS" indicates header-level mappings that associate financial statement line items with their underlying transactional or analytical criteria. The view is owned by the APPS schema, carries a corresponding FND design data entry (FND.JA_CN_CFS_ITEM_MAPPING_HDRS_V), and is registered with a status of VALID.

In practical terms, the view exposes a denormalized, human-readable representation of item mapping headers. Where the underlying storage relies on coded identifiers and untranslated columns, this view joins language-based tables so that application names, event class descriptions, and analytical criterion descriptions are surfaced as descriptive text. This makes it suitable for concurrent program reports, diagnostic queries, and integration extracts that must present meaningful labels rather than numeric foreign keys.

Underlying Base Objects

According to the documented dependency metadata, JA_CN_CFS_ITEM_MAPPING_HDRS_V is defined over the following base objects:

• JA_CN_CFS_ITEM_MAPPING_HDRS — the primary China localization table holding mapping header records and the foundation of the view.
• XLA_ANALYTICAL_HDRS_TL — the translated header definitions for analytical criteria, supplying descriptive criterion names.
• XLA_ANALYTICAL_DTLS_B — the base detail definitions for analytical criteria.
• XLA_ANALYTICAL_DTLS_TL — the translated detail text for analytical criteria, providing code and description attributes.
• XLA_ANALYTICAL_SOURCES — the analytical source definitions that link criteria to their originating data sources.
• FND_APPLICATION_TL — the translated application names used to resolve APPLICATION_ID into APPLICATION_NAME.

The view therefore acts as a read-only join surface across the Subledger Accounting (XLA) analytical tables and the China localization mapping table. The metadata confirms that JA_CN_CFS_ITEM_MAPPING_HDRS_V is not referenced by any other database object, indicating it is a terminal consumer object rather than a dependency for further views or packages.

Key Columns

The view exposes the following significant columns:

• MAPPING_HEADER_ID — the unique identifier of the mapping header record.
• CHART_OF_ACCOUNTS_ID — the chart of accounts to which the mapping applies, enabling multi-organization and multi-COA deployments.
• APPLICATION_ID / APPLICATION_NAME — the owning application identifier and its translated display name.
• EVENT_CLASS / EVENT_CLASS_CODE — the accounting event class in descriptive and coded forms.
• ANALYTICAL_CRITERION — the descriptive analytical criterion text, which is the attribute most commonly searched by users.
• ANALYTICAL_CRITERION_CODE — the coded representation of the criterion (length 100).
• AMB_CONTEXT_CODE — the AMB (Application Message Board / accounting context) context code.
• ANALYTICAL_CRITERION_TYPE_CODE — the type classification of the analytical criterion.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date range during which the mapping is active, supporting date-effective querying.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATE_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The primary use case is verifying and reporting the analytical criterion mapped to each China Financial Statements item mapping. A typical query filters by chart of accounts and effective date:

• List active mappings by COA:

  SELECT mapping_header_id,
         analytical_criterion,
         analytical_criterion_code,
         event_class,
         application_name
  FROM   apps.ja_cn_cfs_item_mapping_hdrs_v
  WHERE  chart_of_accounts_id = :p_coa_id
  AND    TRUNC(SYSDATE) BETWEEN effective_start_date AND NVL(effective_end_date, TRUNC(SYSDATE)+1);

• Search for a specific criterion: filter on ANALYTICAL_CRITERION or ANALYTICAL_CRITERION_CODE using a LIKE predicate to locate mappings referencing a known criterion.
• Diagnostic reporting: join the view to XLA analytical details to confirm that each mapping header resolves to a valid analytical source and detail definition.
• Integration extract: the descriptive columns make the view suitable for feeding downstream reconciliation or disclosure reporting without additional translation joins.

Because the view is read-only and not referenced by other objects, it can be queried safely without side effects, and it is the recommended entry point for inspecting China CFS item mapping headers in both 12.1.1 and 12.2.2 environments.