Search Results ja_cn_system_parameters_u1

Overview

The JA.JA_CN_SYSTEM_PARAMETERS_ALL table is a China localization (JA schema) configuration object within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the parameters captured through the "System Options" form and serves as the primary source of data consumed by the "Electronic Accounting Book Export" program. Each legal entity is permitted exactly one record in this table, making it the authoritative configuration store for electronic accounting book generation in the Chinese statutory reporting process.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its unique index JA_CN_SYSTEM_PARAMETERS_U1 is stored in APPS_TS_TX_IDX. From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone. In practice, because it carries descriptive, mutable configuration attributes keyed to a business entity rather than consolidating shared entity identifiers, it behaves functionally like a satellite attached to a legal entity hub; the standalone classification reflects that no downstream foreign keys were mined from it. This is a modeling suggestion only, not a physical constraint designation.

Key Information Stored

The table defines 22 documented columns. The most operationally significant include:

• LEGAL_ENTITY_ID (NUMBER 15) — the identifier of the legal entity and the single business-key candidate, enforced by the unique index JA_CN_SYSTEM_PARAMETERS_U1. There is no separate surrogate key; this column serves as the effective primary key.
• BOOK_NAME (VARCHAR2 50) — name of the Electronic Accounting Book.
• BOOK_NUM (VARCHAR2 50) — number of the Electronic Accounting Book.
• COMPANY_NAME (VARCHAR2 100) — the reporting company name.
• ENT_QUALITY (VARCHAR2 30) — quality (legal classification) of the current company.
• ORGANIZATION_ID (VARCHAR2 20) — company organization identifier.
• ENT_INDUSTRY (VARCHAR2 100) — industry to which the company belongs.
• ROUNDING_RULE (VARCHAR2 30) — rounding behavior for amount calculation (up, down, or nearest) as defined in the System Options window.
• SET_OF_BOOKS_ID (NUMBER 15) — associated set of books.
• DEFAULT_CFS_ITEM (VARCHAR2 150) — default cash flow statement item.
• PARENT_LEGAL_ENTITY_ID (NUMBER 15) — parent legal entity reference.
• ACCOUNT_STRUCTURE_ID (NUMBER 15) and ACCOUNT_STRUCTURE (VARCHAR2 2000) — the account structure definition and its query text.
• CNAO_STAND_VER, ADMIN_DIVISION_CODE, BUDGET_MGMT_LEVEL, FUND_SOURCE — statutory standard version, administrative division, budget management level, and funding source attributes.
• Standard WHO audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include retrieving the accounting book configuration for a given legal entity, driving the Electronic Accounting Book Export, and validating rounding behavior and account structure setup before statutory submission.

• Fetch a single entity's configuration:
  SELECT * FROM JA.JA_CN_SYSTEM_PARAMETERS_ALL WHERE LEGAL_ENTITY_ID = :p_legal_entity_id;
• Reporting on rounding and book metadata across entities:
  SELECT LEGAL_ENTITY_ID, BOOK_NAME, BOOK_NUM, ROUNDING_RULE FROM JA.JA_CN_SYSTEM_PARAMETERS_ALL ORDER BY LEGAL_ENTITY_ID;
• Auditing recent configuration changes via WHO columns:
  SELECT LEGAL_ENTITY_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM JA.JA_CN_SYSTEM_PARAMETERS_ALL WHERE LAST_UPDATE_DATE > :p_since;
• Joining to the legal entity master to resolve names (see Related Objects).

Related Objects

The documented foreign key relationship links LEGAL_ENTITY_ID to FV_LEGAL_ENTITIES, establishing the primary parent reference:

• FV_LEGAL_ENTITIES — join on JA_CN_SYSTEM_PARAMETERS_ALL.LEGAL_ENTITY_ID = FV_LEGAL_ENTITIES.LEGAL_ENTITY_ID.
• JA_CN_SYSTEM_PARAMETERS_U1 — unique index enforcing one record per legal entity.
• Electronic Accounting Book Export concurrent program — primary consumer of this table's data.
• System Options form — the maintenance UI that populates these columns.
• Set of Books / GL configuration — referenced through SET_OF_BOOKS_ID for ledger association.

Because the table is classified as standalone with a single documented outgoing foreign key, dependent objects are primarily configuration-driven consumers rather than relational children, reinforcing its role as a per-entity localization satellite.