Search Results ja_cn_hisdata_mig_pkg




Overview
Explore in AI Chat

Overview

JA_CN_HISDATA_MIG_PKG is a PL/SQL package body owned by the APPS schema that supports the China localization (JA_CN) of Oracle E-Business Suite. Its purpose is to migrate historical (pre-conversion) general ledger and subledger data into the JA_CN localization structures used for Chinese statutory reporting, including the China Financial Statements (CFS) and the associated journal and voucher tracking tables. The package is classified as OTHER rather than as a public API, indicating that it is intended for internal, controlled use during migration and conversion activities rather than for general application integration.

The package operates at the intersection of standard Oracle General Ledger tables (GL_JE_HEADERS, GL_JE_LINES, GL_IMPORT_REFERENCES), the extended accounting architecture (XLA_AE_LINES), and the China-specific JA_CN tables that store voucher numbering, sub-account mapping, and CFS activities. It depends on several shared JA_CN utilities, including JA_CN_UTILITY, JA_CN_VOUCHER_NUM_PKG, and JA_CN_VOUCHER_NUM_MIG_PKG, as well as standard technology stack packages such as FND_CONCURRENT, FND_FILE, FND_LOG, and FND_MESSAGE for concurrent processing, file output, logging, and message resolution.

Key Procedures and Functions

The documented package exposes five procedures, all directed at the migration of historical balances and journal detail:

  • UPDATEGLCASHLINES — Processes historical cash-related general ledger lines, updating the corresponding China localization records so that cash flow and cash line reporting reflects the migrated activity.
  • UPDATEGLITEMIZATIONLINES — Handles itemization of historical GL lines, populating or refreshing the China localization structures that break down journal activity into the detail required for statutory itemization reporting.
  • UPDATEITEMIZATIONLINES — Performs the equivalent itemization update against the localization-side line records, complementing the GL-level procedure above.
  • MIGRATEHISDATACFS — Migrates historical data into the China Financial Statements (CFS) activities structures (JA_CN_CFS_ACTIVITIES_ALL) used for statutory financial statement preparation.
  • MIGRATEHISDATADE — Migrates historical journal and voucher detail, working with JA_CN_JOURNAL_LINES and the voucher numbering packages to create China localization journal and voucher records from the historical GL and XLA data.

Together these procedures form a migration pipeline: extracting historical GL and accounting entries, itemizing and classifying them, and writing the results into the JA_CN tables. No parameter lists are documented in the ETRM metadata, so signatures are not reproduced here.

Tables Accessed

The package reads and writes a combination of standard EBS and China localization tables. GL_JE_HEADERS and GL_JE_LINES supply the historical journal headers and lines, while GL_IMPORT_REFERENCES provides the import linkage that ties interface data to journal entries. XLA_AE_LINES supplies the subledger accounting entry lines that underlie migrated transactions.

The China localization tables written during migration include JA_CN_JOURNAL_LINES (migrated journal detail), JA_CN_CFS_ACTIVITIES_ALL (financial statement activities), JA_CN_SUB_ACC_MAPPING and JA_CN_SUB_ACC_SOURCES_ALL (sub-account mapping and source definitions used to translate GL accounts into statutory accounts), and JA_CN_LEDGER_LE_BSV_GT (ledger and legal entity balance segment values). Flexible segment support is provided through FND_SEGMENT_ATTRIBUTE_VALUES and FND_DESCR_FLEX_COLUMN_USAGES, and JA_CN_DFF_ASSIGNMENTS supplies descriptive flexfield assignments used in the localization configuration.

Usage Notes

Because the package is classified as OTHER and is not referenced by any other database object, it is not part of a standard runtime call chain. It is invoked during China localization implementations, typically in the historical conversion phase when existing GL balances and journals must be brought forward into the JA_CN structures. Invocation is normally performed through a China-localization concurrent program or a controlled conversion script executed by an implementation consultant or system administrator, with FND_CONCURRENT and FND_FILE handling concurrent request context and log output, and FND_LOG recording diagnostic information.

The package should be executed only during defined migration windows, after the China localization setup (sub-account mapping, ledger and legal entity configuration, and DFF assignments) has been fully established, since the migration logic depends on those mappings being in place. Careful backup and reconciliation of GL_JE_HEADERS, GL_JE_LINES, and the JA_CN target tables is recommended before execution. In Oracle EBS 12.1.1 and 12.2.2 the object resides in the APPS schema and is shipped with China localization patches; it should not be modified directly, and any customization should be confined to wrapping or extension rather than editing the seeded package.