Results for “calculation_flag”

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

Overview

The JA_CN_CFS_ROW_CGS_GT table is a session-level Global Temporary Table (GTT) owned by the JA schema within the Oracle E-Business Suite Asia/Pacific Localizations module. Its specific purpose is to hold category and amount information for rows defined in an FSG (Financial Statement Generator) rowset that is configured for the China Cash Flow Statement (CFS). Because it is a session-scoped GTT, data is private to the session that populates it and is automatically purged at session termination or transaction commit, depending on the ON COMMIT clause applied.

The table acts as transient staging for the cash flow rowset rendering process, allowing the localization program to compute, categorize, and format amount values before they are projected into the final cash flow statement output. From a dimensional modeling perspective, the heuristic Data Vault classification for this object is standalone, meaning it does not participate in a traditional hub/link/satellite pattern; it functions purely as an operational staging structure rather than a persistent integration entity.

Key Information Stored

The table contains 13 documented columns. The most functionally significant columns are:

• AXIS_SET_ID — Identifies the report axis set associated with the cash flow rowset; this is the only documented foreign key, referencing RG_REPORT_AXIS_SETS.
• AXIS_SEQ — Sequence position of the axis within the axis set, used to order rows for display.
• TYPE — Categorizes the row entry (for example, line item vs. subtotal) as defined for the cash flow statement.
• CALCULATION_FLAG — Indicates whether the row participates in calculation logic.
• DISPLAY_FLAG — Controls whether the row appears in the rendered statement.
• DISPLAY_ZERO_AMOUNT_FLAG — Determines whether rows with a zero amount are still displayed.
• CHANGE_SIGN_FLAG — Controls whether the amount sign should be inverted for presentation.
• DISPLAY_FORMAT — Holds the formatting mask applied to the amount column.
• AMOUNT — The primary computed cash flow amount for the current period.
• LAST_YEAR_AMOUNT — The corresponding comparative amount for the prior year.
• ROWCNT — Row counter used during processing to track progression through the rowset.
• LINCNT — Line counter, typically for hierarchical or nested display positioning.
• APPLICATION_ID — Identifies the EBS application context (typically the General Ledger application) that owns the session data.

The metadata does not document an explicit surrogate primary key or unique business key index for this GTT. The natural business-key candidate for associating a record is the combination of AXIS_SET_ID and AXIS_SEQ, which together identify a specific row within a cash flow axis set.

Common Use Cases and Queries

This table is consumed primarily by the China Cash Flow Statement FSG generation logic. Typical scenarios include retrieving the ordered list of rows for a given axis set, applying display and sign conventions, and comparing current versus prior-year amounts.

A representative query pattern is:

• SELECT axis_seq, type, amount, last_year_amount FROM ja.ja_cn_cfs_row_cgs_gt WHERE axis_set_id = :p_axis_set_id ORDER BY axis_seq;

Reporting use cases include reconciliation of cash flow line items, verification of calculation and change-sign behavior, and diagnostic debugging of FSG rowset rendering. Because the table is session-scoped, queries must run within the same session that populated it; they cannot be used for cross-session auditing.

Related Objects

The most significant related object is the axis set definition table referenced by the single documented foreign key:

• RG_REPORT_AXIS_SETS — joined via JA_CN_CFS_ROW_CGS_GT.AXIS_SET_ID = RG_REPORT_AXIS_SETS.AXIS_SET_ID; this join identifies the axis set whose rows are being rendered.

Because the object is standalone and transient, it has no dependent persistent child tables. Its broader context involves the Asia/Pacific Localizations CFS programs and the FSG engine that populates and reads it during cash flow statement generation for China.