Search Results ja_cn_cash_valuesets_all




Overview
Explore in AI Chat

Overview

The JA.JA_CN_CASH_VALUESETS_ALL table is a localization data object within the Oracle E-Business Suite JA — Asia/Pacific Localizations product family. It stores configuration metadata that identifies which key flexfield value sets in the Oracle General Ledger Chart of Accounts are designated as "cash related" for the purposes of the China (CN) localization. Cash flow statement generation, the Chinese cash flow reporting requirements, and certain statutory disclosures depend on the system knowing precisely which value sets in the accounting flexfield represent cash and cash-equivalent accounts. This table supplies that mapping by linking a specific Chart of Accounts to the value set(s) that should be treated as cash.

From a modeling perspective, the heuristic Data Vault classification for this object is standalone. It does not function as a classic hub, link, or satellite in the mined FK structure, but conceptually it behaves as a small reference or configuration satellite: it holds descriptive assignments (a Chart of Accounts and its cash-indicating value set) rather than transactional events. The table is owned by the JA schema and is documented as VALID with a physical schema of seven columns in ETRM 12.2.2.

Key Information Stored

The table contains seven documented columns. The most significant are:

  • CHART_OF_ACCOUNTS_ID — Identifies the Oracle General Ledger Chart of Accounts to which the cash designation applies. In the mined relationship data this column is documented as a foreign key referencing GL_MGT_SEG_UPGRADE_H, positioning the row within the GL chart-of-accounts upgrade/management context.
  • FLEX_VALUE_SET_ID — Identifies the key flexfield value set that is flagged as cash related. This is the business-meaningful payload of the row; it points to a value set defined in the Application Object Library (FND) value set infrastructure.
  • CREATED_BY, CREATION_DATE — Standard Oracle EBS WHO audit columns recording the user and timestamp of row creation.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording the most recent modification user, timestamp, and login session.

The documented metadata does not expose a surrogate primary key column beyond the identifier columns above; the effective business key is the combination of CHART_OF_ACCOUNTS_ID and FLEX_VALUE_SET_ID, which together assert "for this Chart of Accounts, this value set is cash related." No unique index is separately documented in the supplied metadata.

Common Use Cases and Queries

Typical use cases involve validating cash-flow configuration, auditing localization setup, and driving cash flow statement reports. A representative diagnostic query enumerates configured cash value sets per Chart of Accounts:

  • Configuration audit: SELECT chart_of_accounts_id, flex_value_set_id, last_updated_by, last_update_date FROM ja.ja_cn_cash_valuesets_all; — verify which value sets are marked cash related and when they were last changed.
  • Join to value sets: join FLEX_VALUE_SET_ID to FND_FLEX_VALUE_SETS to retrieve the value set name and confirm the segment assignment for reporting.
  • Join to Chart of Accounts: join CHART_OF_ACCOUNTS_ID to the GL chart-of-accounts structures to reconcile the localization flag against the active accounting flexfield.
  • Migration/reconciliation: compare rows across environments during a China localization upgrade to ensure cash designations were carried forward consistently.

Because the table is configuration data, queries are typically read-only and used in validation scripts, setup reports, and pre-close checklists rather than in high-volume transaction processing.

Related Objects

The most significant related objects, based on the documented FK relationship and the surrounding EBS infrastructure, include:

  • GL_MGT_SEG_UPGRADE_H — referenced by JA_CN_CASH_VALUESETS_ALL.CHART_OF_ACCOUNTS_ID; the parent context for the Chart of Accounts assignment.
  • FND_FLEX_VALUE_SETS — the Application Object Library value set definition table, joined via FLEX_VALUE_SET_ID.
  • FND_FLEX_VALUES — the individual values belonging to the identified value set.
  • GL_CODE_COMBINATIONS — the accounting flexfield combinations that consume the value set identified as cash related.
  • GL_LEDGERS / GL_LEDGER_CONFIGURATIONS — the ledgers associated with the Chart of Accounts flagged here.
  • FND_ID_FLEX_STRUCTURES — the key flexfield structure underlying the Chart of Accounts.

These relationships support both setup validation and downstream cash flow reporting within the China localization.