Results for “ja_cn_cfs_item_mapping_hdrs”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The JA.JA_CN_CFS_ITEM_MAPPING_HDRS table is a localization data object within the JA — Asia/Pacific Localizations product, delivered to support the Chinese Cash Flow Statement (CFS) reporting requirements imposed on Oracle E-Business Suite implementations. It stores the header-level definition of cash flow item mappings, which associate a Chart of Accounts context, an application, an event class, and a supporting reference code so that transactional activity can be categorized into the statutory cash flow line items required by Chinese accounting regulations. Each row represents one mapping header, and the table participates in a one-to-many relationship with a corresponding mapping detail or line entity, meaning a single header governs one or more mapped items.

The object is classified as VALID in the ETRM repository for both 12.1.1 and 12.2.2, with a documented physical schema of fourteen columns owned by the JA schema. From a heuristic Data Vault modeling perspective, the mined relationship data classifies this table as standalone, suggesting it behaves as a self-contained reference entity rather than a dependent satellite. The presence of EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns, however, indicates a slowly changing dimension pattern, so a data modeler could reasonably treat it as a Type 2 satellite keyed by the mapping header, with the effective date range capturing historical versions of the mapping definition.

Key Information Stored

The surrogate primary key of the table is MAPPING_HEADER_ID, which is also the sole documented unique index (JA_CN_CFS_ITEM_MAPPING_HDRS_U1) and therefore the strongest business-key candidate. This identifier links the header to its child mapping rows and is the anchor for foreign key references.

• MAPPING_HEADER_ID — surrogate primary key and unique identifier for each mapping header.
• CHART_OF_ACCOUNTS_ID — identifies the Chart of Accounts to which the mapping applies, scoping the definition to a specific accounting structure.
• APPLICATION_ID — the Oracle application that owns the source transactions being mapped (for example, Payables, Receivables, or General Ledger).
• EVENT_CLASS_CODE — the subledger event class whose accounting entries feed the cash flow analysis.
• ANALYTICAL_CRITERION_CODE and ANALYTICAL_CRITERION_TYPE_CODE — define the analytical criterion used to filter or categorize activity for the mapping.
• AMB_CONTEXT_CODE — the Application Message Board context code associated with the mapping definition.
• EFFECTIVE_START_DATE and EFFECTIVE_END_DATE — define the date range during which this mapping header is active, supporting versioned definitions.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns tracking who created and last modified the record and when.

Common Use Cases and Queries

The primary use case is resolving how a given combination of application, event class, and Chart of Accounts maps to Chinese cash flow statement line items. Reporting queries typically join the header to its child mapping lines and to the underlying supporting reference definitions. A representative pattern filters active headers for a specific Chart of Accounts on a given date:

• SELECT mapping_header_id, application_id, event_class_code FROM ja.ja_cn_cfs_item_mapping_hdrs WHERE chart_of_accounts_id = :coa_id AND TRUNC(SYSDATE) BETWEEN effective_start_date AND NVL(effective_end_date, TRUNC(SYSDATE)+1);
• Diagnostic queries to determine whether a mapping header already exists for a combination of CHART_OF_ACCOUNTS_ID, APPLICATION_ID, and EVENT_CLASS_CODE prior to creating a new configuration.
• Audit and change-tracking reports using LAST_UPDATE_DATE and LAST_UPDATE_BY to identify recently modified mapping definitions.
• Extract queries feeding the CFS reporting engine, selecting active headers and their detail rows to build the cash flow statement hierarchy.

Related Objects

The documented foreign key relationships and the one-to-many design of this table identify the following significant related objects:

• PER_PTU_DFF_MAPPING_HEADERS — referenced by JA_CN_CFS_ITEM_MAPPING_HDRS.MAPPING_HEADER_ID, this header-level mapping table underpins the mapping identifier used here.
• GL_MGT_SEG_UPGRADE_H — referenced via CHART_OF_ACCOUNTS_ID, providing the Chart of Accounts context for each mapping header.
• The associated mapping detail/line table (one-to-many with this header) — the child entity that holds the individual cash flow item mappings governed by each header row.
• GL_CODE_COMBINATIONS and the GL_LEDGERS / GL_LEDGER_CONFIGURATIONS family — commonly joined through CHART_OF_ACCOUNTS_ID to resolve accounting flexfield context for reporting.
• Subledger event and accounting entry sources such as XLA_EVENTS and XLA_AE_HEADERS/XLA_AE_LINES — joined indirectly through APPLICATION_ID and EVENT_CLASS_CODE to reconcile mapped cash flow items against actual posted activity.

Together these objects form the localization configuration layer that translates standard Oracle subledger and general ledger activity into the statutory cash flow presentation required for Chinese financial reporting.