Results for “ja_cn_system_bank_params_all_v”

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

Overview

The JA_CN_SYSTEM_BANK_PARAMS_ALL_V view resides in the APPS schema and belongs to the JA – Asia/Pacific Localizations product family, specifically supporting the Oracle E-Business Suite localization for the People's Republic of China. It is a reporting and integration view built over the China system bank parameters table, JA_CN_SYSTEM_BANK_PARAMS_ALL. The view consolidates banking parameter configuration with descriptive attributes drawn from the general ledger, legal entity, and flexfield value store, so that consumers do not need to resolve those foreign keys manually. Its status is documented as VALID in ETRM 12.2.2, and the same definition applies to the 12.1.1 code line, where the underlying objects were shipped under the JA localization patch stream.

In practice, the view exposes the China bank-account parameter setup at the intersection of ledger, legal entity, and flex segment value. It is typically consumed by bank-file generation, cash-management reporting, and localization extracts that must present meaningful names (ledger name, legal entity name, flex value description) rather than numeric identifiers.

Underlying Base Objects

The view is defined with an inner-join style WHERE clause that requires a match on every participating object; rows in the base parameter table without a corresponding ledger, legal entity, value set, or flex value are therefore not returned.

• JA_CN_SYSTEM_BANK_PARAMS_ALL (synonym) – driving table holding the bank parameter rows keyed by BANKING_ID.
• GL_LEDGERS (synonym) – joined on LEDGER_ID to supply LEDGER_NAME.
• XLE_ENTITY_PROFILES (synonym) – joined on LEGAL_ENTITY_ID to supply the legal entity name.
• FND_FLEX_VALUE_SETS (synonym) and FND_FLEX_VALUES_VL (view) – joined on FLEX_VALUE_SET_ID and, in the case of the values view, on FLEX_SEGMENT_VALUE = FFV.FLEX_VALUE, providing the segment description.

Key Columns

• BANKING_ID – primary identifier of the banking parameter record.
• LEDGER_ID / LEDGER_NAME – accounting ledger context and its display name.
• LEGAL_ENTITY_ID / LEGAL_ENTITY – owning legal entity identifier and name.
• ACCESS_SET_ID – security access set governing visibility of the row.
• COMPANY_NAME, ENT_QUALITY, ENT_INDUSTRY, ORGANIZATION_ID – enterprise profile attributes, including the industry classification referenced by the search term ent_industry.
• ROUNDING_RULE – rounding convention applied to bank amounts.
• CNAO_STAND_VER – China national accounting standard version indicator.
• FLEX_SEGMENT_VALUE, FLEX_VALUE_SET_ID, DESCRIPTION – bank account flex segment and its description.
• ACCOUNTING_STRUCTURE_FLEX_NUM, ACCOUNTING_STRUCTURE_CODE, ACCOUNTING_STRUCT_ID, CHART_OF_ACCOUNTS_ID – accounting structure and chart of accounts context.
• Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage is diagnostic or extract-driven: confirming that a bank account is fully configured for a ledger and legal entity, or extracting parameter data for bank interface files. A representative query selecting by industry is shown below.

• Retrieve all configured bank parameters for a ledger:

SELECT banking_id, ledger_name, legal_entity,
       company_name, ent_industry, rounding_rule
FROM   apps.ja_cn_system_bank_params_all_v
WHERE  ledger_id = :p_ledger_id;

• Filter by enterprise industry classification:

SELECT banking_id, company_name, ent_industry, cnao_stand_ver
FROM   apps.ja_cn_system_bank_params_all_v
WHERE  ent_industry = :p_industry;

• Locate the flex segment description for a given bank:

SELECT banking_id, flex_segment_value, description
FROM   apps.ja_cn_system_bank_params_all_v
WHERE  legal_entity_id = :p_legal_entity_id;

Because the view enforces inner joins across ledgers, entities, and flex values, missing descriptions in the output generally indicate incomplete setup in one of the underlying tables.