Results for “row_set_name”

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

Overview

JA_CN_CFS_ROW_SETS_V is an Oracle E-Business Suite Application Object Library (FND) view owned by the APPS schema. It exposes Chinese Localization reporting metadata that links row set definitions used in the China Cash Flow Statement (CFS) to their corresponding charts of accounts. The view is a lightweight compatibility layer over JA_CN_CFS_ASSIGNMENTS_ALL, the localization assignment table that stores which RG_REPORT_AXIS_SETS axis sets (row sets) are mapped to which chart of accounts for Chinese financial statement generation. By joining the assignment table against the report axis sets definition, the view restricts output to row-type axis sets and presents a denormalized, report-friendly set of columns.

In 12.1.1 and 12.2.2, the view serves as the read interface for CFS row set assignments. In 12.2.2 the object remains VALID in APPS, sourced from two synonyms, JA_CN_CFS_ASSIGNMENTS_ALL and RG_REPORT_AXIS_SETS. It abstracts ROWID access and axis-set filtering so that localization reports and extensions do not need to replicate the join logic.

Underlying Base Objects

The documented base objects are two APPS synonyms: JA_CN_CFS_ASSIGNMENTS_ALL and RG_REPORT_AXIS_SETS. The view's SQL selects from these with an inner join on AXIS_SET_ID and filters RG_REPORT_AXIS_SETS.AXIS_SET_TYPE = 'R', ensuring only row sets are returned. DISTINCT removes duplicate combinations.

• JA_CN_CFS_ASSIGNMENTS_ALL — the Chinese localization assignment table mapping axis sets to charts of accounts (JCCA alias), contributing AXIS_SET_ID and CHART_OF_ACCOUNTS_ID.
• RG_REPORT_AXIS_SETS — the report axis sets definition table (RRAS alias), contributing NAME (exposed as ROW_SET_NAME), AXIS_SET_ID, and AXIS_SET_TYPE.

The view is the only documented consumer path for retrieving these assignments by join; it does not itself store data.

Key Columns

• ROW_ID — derived from RRAS.ROWID; provides a unique identifier for the underlying axis set row.
• AXIS_SET_ID — the axis set identifier joining assignments to row set definitions.
• ROW_SET_NAME — the descriptive name of the row set, from RG_REPORT_AXIS_SETS.NAME.
• CHART_OF_ACCOUNTS_ID — the chart of accounts to which the row set is assigned in the Chinese CFS configuration.

Common Use Cases and Queries

The view is typically queried to validate or reconcile CFS row set assignments per chart of accounts, to drive LOVs or report parameters, and to support troubleshooting when assignments appear missing. A representative query:

• SELECT row_set_name, axis_set_id, chart_of_accounts_id FROM apps.ja_cn_cfs_row_sets_v WHERE chart_of_accounts_id = :coa_id ORDER BY row_set_name;
• SELECT DISTINCT row_set_name FROM apps.ja_cn_cfs_row_sets_v; — enumerate all assigned CFS row sets.
• SELECT a.row_set_name, a.chart_of_accounts_id FROM apps.ja_cn_cfs_row_sets_v a, apps.gl_charts_of_accounts_v b WHERE a.chart_of_accounts_id = b.chart_of_accounts_id; — join to chart names for reporting.

Because the view filters AXIS_SET_TYPE to 'R', results exclude column and other axis sets. Users searching for ja_cn_cfs_assignments_all should treat this view as the primary documented read path over that assignment table.