Search Results ja_cn_cfs_item_mapping_lines




Overview
Explore in AI Chat

Overview

The JA_CN_CFS_ITEM_MAPPING_LINES table is a localizations data object owned by the JA schema within Oracle E-Business Suite, delivered as part of the Asia/Pacific Localizations product family. Its purpose is to store the mapping relationship between a cash flow statement (CFS) item and the value of the source from which that item is derived. This mapping underpins the generation of cash flow statements for Chinese statutory reporting requirements, where transactional and account-level source values must be translated into the specific line items prescribed by the reporting framework.

The table sits at the detail level of a header-to-line construct. The documentation explicitly states that a one-to-many relationship exists between the cash flow item mapping information stored in the header and the mapping lines stored here — that is, a single mapping definition account or range may resolve to multiple source values, each recorded as a separate row. The heuristic Data Vault classification mined from the foreign key structure is standalone, which in practice suggests modeling this object as an independent satellite rather than a dependent link, since its only documented foreign key points to a mapping header rather than to a core business entity hub. Analysts building a vault-style warehouse around EBS localizations should treat it as a descriptor of mapping configuration effective over time.

Key Information Stored

Eleven columns are documented for this table in the 12.2.2 physical schema. The most significant are described below.

The documentation does not identify a surrogate primary key column or named unique index; the combination of MAPPING_HEADER_ID, ORG_ID, AC_VALUE, and the effective dates functions as the practical business key for identifying a unique mapping line. Note that MAPPING_HEADER_ID is the only documented foreign key, and Data Vault classification is standalone.

Common Use Cases and Queries

The primary use case is verifying or troubleshooting cash flow statement generation: identifying why a particular source value resolved to a given report line, or why an expected line is missing. A second common scenario is reviewing effective-dated configuration to determine which mapping was active for a given period.

A typical query joins lines to their header and filters by operating unit and date:

  • SELECT l.mapping_header_id, l.org_id, l.ac_value, l.detailed_cfs_item, l.effective_start_date, l.effective_end_date FROM ja.ja_cn_cfs_item_mapping_lines l WHERE l.org_id = :org_id AND :report_date BETWEEN l.effective_start_date AND NVL(l.effective_end_date, :report_date) ORDER BY l.ac_value;
  • To trace a single item: add WHERE l.detailed_cfs_item = :cfs_item to return every source value feeding that line.
  • To audit configuration changes, filter on last_update_date and created_by to isolate recently modified or newly added mapping lines.

Reporting extracts commonly feed reconciliation between subledger balances and the cash flow statement, and data-migration validation exercises comparing legacy mapping tables against the mapping definitions here.

Related Objects

The following objects are the most significant in relation to this table, based on the documented foreign key and the surrounding mapping construct:

  • JA_CN_CFS_ITEM_MAPPING_HEADERS — The documented parent, joined on MAPPING_HEADER_ID.
  • PER_PTU_DFF_MAPPING_HEADERS — The object referenced by the foreign key chain, forming the header-side mapping framework.
  • JA_CN_CFS_ITEMS / cash flow statement item definitions — Reference data resolving DETAILED_CFS_ITEM into display labels.
  • GL_CODE_COMBINATIONS — The chart of accounts source against which AC_VALUE is evaluated.
  • GL_BALANCES and GL_JE_LINES — The transactional and balance sources reconciled to the mapped CFS items.
  • HR_OPERATING_UNITS — Resolves ORG_ID into a meaningful operating unit name.

Together these objects support the configuration, execution, and audit of cash flow statement mapping within the JA localization for Oracle EBS 12.1.1 and 12.2.2.