Results for “accounting_structure_flex_num”

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

Overview

The JA_CN_SUB_ACC_SOURCES_ALL table is a localization-specific data object owned by the JA schema within the Oracle E-Business Suite Asia/Pacific Localizations product family. It supports the Chinese statutory accounting requirements by storing subsidiary source information relating to projects, third parties, and personnel, together with the mapping between those sources and the Key Flexfield Account Structure assigned to the ledger. The extracted subsidiary source data underpins downstream subsidiary ledger reporting, account derivation, and consolidation logic required by Chinese GAAP and related regulatory reporting within Oracle General Ledger.

In Data Vault modeling terms, the ETRM classification is standalone, meaning no foreign-key relationships to external hub or link tables were mined from the FK structure apart from the documented reference to GL_MGT_SEG_UPGRADE_H. This suggests the table functions best as a satellite carrying descriptive and attribute-level context rather than as a strict hub or link entity, though the presence of a chart-of-accounts reference introduces a light conformance role.

Key Information Stored

The table holds 15 documented columns. The most significant are:

• CHART_OF_ACCOUNTS_ID — identifies the chart of accounts associated with the subsidiary source record; also the documented foreign-key column referencing GL_MGT_SEG_UPGRADE_H.
• ACCOUNTING_STRUCT_FLEX_NUM — the flexfield number identifying the account structure (Key Flexfield) assigned to the ledger.
• ACCOUNTING_STRUCT_ID — the internal identifier of the accounting structure definition.
• PROJECT_SOURCE_FLAG — indicates whether the subsidiary source is project-related.
• PROJECT_AC_CODE / PROJECT_AC_DETAIL_CODE — project-level account codes and their detail-level counterparts used in source extraction and account derivation.
• AC_GROUPING_ORDER — governs the sequencing of account groupings during subsidiary extraction.
• COA_SEGMENT / HISTORY_COA_SEGMENT — the current and historical chart-of-accounts segment mappings, essential for tracking changes across periods.
• AMB_CONTEXT_CODE — the application-migration-bench context code, used for upgrade and migration context tracking.
• Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

The metadata does not document a dedicated surrogate primary key column or unique-index business key; the combination of CHART_OF_ACCOUNTS_ID with the accounting structure columns is the practical business-key candidate for row identity.

Common Use Cases and Queries

Typical usage centers on account structure resolution and subsidiary source extraction for Chinese subsidiary reporting.

• Determining which account structure is assigned to a given chart of accounts: SELECT ACCOUNTING_STRUCT_FLEX_NUM, ACCOUNTING_STRUCT_ID FROM JA_CN_SUB_ACC_SOURCES_ALL WHERE CHART_OF_ACCOUNTS_ID = :coa_id;
• Identifying project-based subsidiary sources: filter on PROJECT_SOURCE_FLAG = 'Y' and inspect PROJECT_AC_CODE/PROJECT_AC_DETAIL_CODE.
• Tracking historical chart-of-accounts segment changes by comparing COA_SEGMENT with HISTORY_COA_SEGMENT.
• Auditing migration context via AMB_CONTEXT_CODE during upgrade cycles.

Related Objects

The documented FK relationship ties this table to GL_MGT_SEG_UPGRADE_H through CHART_OF_ACCOUNTS_ID. Related objects in the same localization and GL area typically include GL_LEDGERS and GL_CODE_COMBINATIONS (via chart-of-accounts context), JA_CN_SUB_ACC_SOURCES_TL if translated attributes exist, and the Key Flexfield definition tables. These support joining subsidiary source configuration to ledger and account structure metadata.