Results for “calculation_seq”

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

Overview

The JA.JA_CN_CFS_CALCULATIONS_GT object is a global temporary table (GTT) defined within the JA (Asia/Pacific Localizations) product schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its specific functional scope is the China Cash Flow Statement localization, where it stores calculation lines for items that carry a calculation definition within an FSG (Financial Statement Generator) Row Set defined for the Cash Flow Statement.

Because the object is implemented as a session-level global temporary table, its rows are private to the database session that inserts them and are automatically purged at session termination (or at transaction commit, depending on the ON COMMIT clause in the deployed DDL). This design makes the table a transient working area: the Cash Flow Statement calculation engine populates it, consumes the rows during statement generation, and discards them without persistent storage or concurrency contention. From a heuristic Data Vault modeling perspective, the ETRM relationship data classifies this object as standalone, which suggests that it functions as a session-scoped staging or working record set rather than a persistent hub, link, or satellite. Where persistent audited tracking of cash flow calculations is required, a companion persistent table should be considered as the satellite target.

Key Information Stored

The documented physical schema in ETRM 12.2.2 contains eight columns. The most significant of these are:

• APPLICATION_ID — Identifies the owning Oracle Applications product (here, the JA localization), consistent with the standard multi-tenant partitioning pattern used across EBS tables.
• AXIS_SET_ID — The foreign key to RG_REPORT_AXIS_SETS; this ties each calculation line to the specific FSG report axis set that defines the row and column structure of the Cash Flow Statement output.
• AXIS_SEQ — The sequence position of the axis within the axis set, used to order calculation lines in the statement layout.
• CALCULATION_SEQ — The ordering sequence of the calculation definitions applied to a given row, ensuring deterministic evaluation of multi-step formulas.
• OPERATOR — The arithmetic operator (for example, addition or subtraction) applied in the calculation definition.
• OPERATOR_FLAG — A control flag that modifies how the operator is interpreted, typically distinguishing unary (sign) versus binary operator treatment.
• CAL_AXIS_SEQ — The axis sequence of the operand referenced by the calculation row, linking the calculation line back to the source row it consumes.
• CONSTANT — A literal numeric value used where the calculation definition includes a fixed constant rather than a row reference.

The ETRM metadata does not document an explicit surrogate primary key or unique index on this GTT; as a transient work table, uniqueness is enforced by the application logic through the combination of AXIS_SET_ID, AXIS_SEQ, and CALCULATION_SEQ rather than by a database constraint.

Common Use Cases and Queries

The primary use case is diagnostic verification of Cash Flow Statement calculations. A consultant validating China CFS output joins the GTT to RG_REPORT_AXIS_SETS within the same session that generated the statement:

• Session-scoped inspection: Query the GTT immediately after running the CFS concurrent program, before the session terminates, to confirm that all calculation lines populated correctly.
• Operator validation: Filter on OPERATOR and OPERATOR_FLAG to verify that sign handling matches the definition in the FSG Row Set.
• Constant audit: Select rows where CONSTANT is not null to confirm that literal values in the definition were materialized as expected.
• Sequence ordering: Order by CALCULATION_SEQ and AXIS_SEQ to reproduce the evaluation order used by the engine.

Because the table is session-private, external tools connecting on a different session cannot see the rows. Any diagnostic query must therefore execute on the same database session as the statement generation, typically via a custom concurrent program or a script that performs the insert and select in sequence.

Related Objects

• RG_REPORT_AXIS_SETS — The parent object referenced by the AXIS_SET_ID foreign key; it defines the rows, columns, and calculation identities used by FSG Cash Flow reporting.
• RG_REPORT_AXIS_CONTENT — Holds the detailed row and column content of each axis set, providing the row identities that calculation lines reference via CAL_AXIS_SEQ.
• FND_APPLICATION — Resolves the APPLICATION_ID value to the JA product registration.
• FND_CONCURRENT_PROGRAMS / FND_CONCURRENT_REQUESTS — Identify the China CFS concurrent program run that populated this GTT.
• RG_REPORT_SETS and RG_REPORT_DEFINITIONS — Upstream FSG definitions that designate the Cash Flow Statement report and its row set.
• GL_JE_HEADERS / GL_JE_LINES — The General Ledger journal sources whose balances feed the underlying rows that CFS calculations consume.