Search Results ja_cn_fa_bi_export_pkg




Overview
Explore in AI Chat

Overview

The APPS.JA_CN_FA_BI_EXPORT_PKG package is a China localization (JA_CN) component within Oracle E-Business Suite that supports the BI (Business Intelligence) export process for Fixed Assets data. It operates in the context of Chinese statutory reporting requirements, where asset information must be extracted, formatted, and exported to external BI or reporting platforms. The package is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2 environments and is owned by the APPS schema, the standard repository for Oracle EBS application database objects.

The package functions as a helper or utility layer beneath the China Fixed Assets export concurrent program (JA_CN_FA_EXPORT_PROG). Its primary responsibility is to assemble the basic information required for the BI export, drawing from Fixed Assets transactional and reference tables alongside General Ledger period status data. The API classification is recorded as OTHER, indicating it is not part of a formally published public API set but rather an internal support package used by the localization's export infrastructure.

Key Procedures and Functions

ETRM documents a single entry point for this package:

  • ADD_BASIC_INFORMATION — This procedure assembles and stages the foundational asset information consumed by the BI export process. It gathers source data from the FA and GL tables listed below and prepares it in the structure required by the downstream export routine. No parameter list is documented in the supplied metadata; callers should reference the package specification in the target instance for exact signatures, as they are not reproduced here.

The limited documented surface — one procedure — is consistent with the package's role as a focused data-gathering utility rather than a broad functional module.

Tables Accessed

The following tables are referenced through APPS synonyms:

  • FA_BOOK_CONTROLS_SEC — Security-enabled book controls, used to determine the asset books in scope for the export.
  • FA_CATEGORY_BOOKS — Category-to-book assignments, providing asset categorization for reporting.
  • FA_DEPRN_PERIODS — Depreciation period definitions, used to identify open and closed periods relevant to the export window.
  • FA_DISTRIBUTION_HISTORY — Asset distribution and cost center allocation history.
  • FA_TRANSACTION_HEADERS — Asset transaction headers representing additions, adjustments, transfers, and retirements.
  • GL_PERIOD_STATUSES — General Ledger period status, used to align FA period data with GL open/closed period state.
  • JA_CN_LEDGER_LE_BSV_GT — A China localization global temporary table storing ledger and legal entity balancing segment value mappings, used to resolve the accounting context for exported asset records.

Usage Notes

JA_CN_FA_BI_EXPORT_PKG is referenced by the concurrent program package JA_CN_FA_EXPORT_PROG, which is the standard invocation path. The China Fixed Assets BI export concurrent program is typically scheduled periodically by localization users to produce asset extracts for statutory and management reporting. Because the package is classified as OTHER, it is not intended for direct invocation by customer-written code; customizations that depend on it risk breakage during patching or upgrades. The package in turn references only SYS.STANDARD, confirming a self-contained implementation with no dependency on other application packages beyond its table references. In both 12.1.1 and 12.2.2 this object remains VALID, and the reported dependency chain is unchanged between releases.