Search Results ja_cn_cfs_activities_all




Overview
Explore in AI Chat

Overview

The JA_CN_CFS_ACTIVITIES_ALL table is a localization-specific data object that resides in the JA schema, which supports Oracle E-Business Suite's Asia/Pacific Localizations product family. Specifically, this table addresses the cash flow statement (CFS) reporting requirements applicable to Chinese legal entities. It stores transaction-level information related to detailed cash flow items, capturing data derived from individual transactions or transaction lines and associating each record with a specific legal entity. This granular structure enables organizations to produce statutory cash flow statements that reconcile operational activity to reported cash movements.

From a data modeling perspective, the heuristic Data Vault classification mined from the foreign key structure identifies this table as standalone. This suggests that, although the table references parent entities, it does not function as a pure hub, link, or satellite within a canonical Data Vault model, but rather operates as an independent transaction-fact style table within the localization schema. Its status is VALID, and it is owned by the JA schema.

Key Information Stored

The table contains 47 documented columns, with the surrogate primary key being CFS_ACTIVITY_ID, which is enforced by the unique index JA_CN_CFS_ACTIVITIES_U1. The most significant columns include:

Common Use Cases and Queries

This table is typically queried when building detailed cash flow statement reports, reconciling cash movements to transaction sources, and supporting statutory audits. A representative query aggregates functional amounts by cash flow item and period for a given legal entity:

  • Retrieve all activities for a legal entity within a period: SELECT CFS_ACTIVITY_ID, DETAILED_CFS_ITEM, FUNC_AMOUNT, PERIOD_NAME FROM JA_CN_CFS_ACTIVITIES_ALL WHERE LEGAL_ENTITY_ID = :p_entity AND PERIOD_NAME = :p_period;
  • Reconcile to source transactions: join on TRX_LINE_ID to CN_TRX_LINES_ALL.
  • Summary reporting by cash item: SELECT DETAILED_CFS_ITEM, SUM(FUNC_AMOUNT) GROUP BY DETAILED_CFS_ITEM;
  • Intercompany analysis: filter on INTERCOMPANY_FLAG = 'Y'.

Related Objects

  • FV_LEGAL_ENTITIES — joined via LEGAL_ENTITY_ID.
  • CN_TRX_LINES_ALL — joined via TRX_LINE_ID, providing source transaction line detail.
  • General Ledger tables referenced by JE_HEADER_ID and JE_LINE_NUM (e.g., GL_JE_HEADERS, GL_JE_LINES) for journal linkage.
  • Cash management tables referenced by CASH_TRX_ID and CASH_TRX_LINE_ID.
  • Other JA localization tables supporting Chinese cash flow statement configuration and reporting.