Search Results ja_cn_system_parameters_all




Overview
Explore in AI Chat

Overview

The JA.JA_CN_SYSTEM_PARAMETERS_ALL table is a configuration master within the Oracle E-Business Suite Asia/Pacific Localizations module (product code JA), specifically supporting the China localizations (JA_CN) required for statutory electronic accounting book reporting. It stores the values captured through the System Options form and serves as the primary configuration source consumed by the Electronic Accounting Book Export concurrent program. The program retrieves most of its runtime parameters from this table rather than from user entry, which ensures that exported accounting books conform consistently to the legal entity's declared reporting attributes.

The table enforces a strict cardinality rule: one legal entity may hold only one record. This is guaranteed by the unique index JA_CN_SYSTEM_PARAMETERS_U1 defined on LEGAL_ENTITY_ID. Under the heuristic Data Vault classification mined from the foreign key structure, this table is modeled as a standalone satellite. It carries descriptive, entity-level attributes keyed to a single parent (FV_LEGAL_ENTITIES) rather than acting as a hub or a link, which is consistent with its role as a one-row-per-entity configuration store. Physically the object is owned by the JA schema and exposes 22 documented columns in release 12.2.2.

Key Information Stored

The table blends identity, accounting, and statutory reporting attributes. The most significant columns are:

Common Use Cases and Queries

Typical usage centres on verifying configuration completeness before running the Electronic Accounting Book Export, and on retrieving statutory identifiers for reporting. A query to inspect a single entity's setup:

  • SELECT book_name, book_num, company_name, rounding_rule, cnao_stand_ver FROM ja.ja_cn_system_parameters_all WHERE legal_entity_id = :p_legal_entity_id;

A completeness check across entities, useful for pre-run validation:

  • SELECT p.legal_entity_id, p.book_name FROM ja.ja_cn_system_parameters_all p WHERE p.set_of_books_id IS NULL OR p.account_structure_id IS NULL;

Joining to the legal entity for a reporting extract:

  • SELECT le.name, p.book_num, p.company_name FROM ja.ja_cn_system_parameters_all p, fv_legal_entities le WHERE p.legal_entity_id = le.legal_entity_id;

Related Objects

  • FV_LEGAL_ENTITIES — referenced by JA_CN_SYSTEM_PARAMETERS_ALL.LEGAL_ENTITY_ID; the parent entity definition.
  • GL_SETS_OF_BOOKS / GL_LEDGERS — joined via SET_OF_BOOKS_ID to resolve ledger details.
  • FND_ID_FLEX_STRUCTURES — referenced through ACCOUNT_STRUCTURE_ID for the accounting structure.
  • HR_ALL_ORGANIZATION_UNITS / ORG_ORGANIZATION_DEFINITIONS — context for ORGANIZATION_ID.
  • JA_CN_CFS_ITEMS — supplies the DEFAULT_CFS_ITEM reference.
  • The Electronic Accounting Book Export concurrent program and its associated System Options form — the primary functional consumers of this table.