Search Results execute_export

Overview

The PL/SQL package APPS.JA_CN_EAB_EXPORT_PKG is a China localization component delivered within Oracle E-Business Suite. Its purpose is to export the Electronic Accounting Book (EAB), a statutory reporting artifact required by Chinese regulatory (CNAO) mandates. The package header declares AUTHID CURRENT_USER, meaning that runtime privileges are resolved against the invoking schema, and it is classified as a custom/localization API (API classification: OTHER) rather than a standard public interface. The header's design reference is the CNAO Electronic Accounting Book Export design document, and the package was originally created by Jackey Li on 13 March 2006, with a subsequent update by Yucheng Sun on 30 April 2007. The package is owned by the APPS schema and is referenced by one other package in the shipped environment, indicating that it is invoked indirectly through a controlling process rather than only being called ad hoc.

Key Procedures and Functions

The ETRM metadata documents a single public program unit within this package:

• EXECUTE_EXPORT — The main procedure that implements the export functionality for the electronic accounting book. It serves as the entry point for generating the EAB output for a given accounting configuration and period. Per the package header comments, the procedure is intended to be the central driver of the export process. No parameter list is reproduced here because the documentation excerpt should be consulted directly for the exact IN parameter names and data types; the header comments describe inputs covering the chart of accounts, legal entity, ledger, and fiscal year context required to scope the export.

No other public procedures or functions are documented for this package.

Tables Accessed

The package references the following tables through APPS synonyms, each supporting a distinct aspect of export processing:

• GL_LEDGERS — Supplies ledger definition and accounting configuration details used to resolve the ledger selected for export.
• AD_RELEASES — Provides application patch/release information, typically used to determine feature availability or version-dependent behavior.
• FND_CURRENCIES_TL — Provides translated currency names required when formatting monetary amounts in the exported book.
• JA_CN_SUB_ACC_SOURCES_ALL — The China localization source table for subsidiary account (sub-account) definitions, which drives the account mapping used in the electronic book.
• JA_CN_SYSTEM_PARAMETERS_ALL — Stores China localization system parameters that control formatting, behavior, and regulatory defaults for the export.

Usage Notes

JA_CN_EAB_EXPORT_PKG is a China-specific localization utility and is not part of the core General Ledger API set. It is normally invoked from an Oracle Forms-based China localization setup or submission screen, or from a concurrent program that packages the EAB export into a scheduled batch job. Because the package is AUTHID CURRENT_USER and owned by APPS, custom code that calls it should do so from within the APPS schema or via a synonym with appropriate grants. The presence of the single referenced-by package suggests it is consumed by a higher-level localization driver rather than called directly by end users. Implementers extending or troubleshooting the export should confirm that the JA_CN localization tables and system parameters are properly configured, since EXECUTE_EXPORT depends on them for account sourcing and formatting. Given the package's age and its tight coupling to China statutory requirements, changes should be validated against the current CNAO reporting rules applicable to the EBS release in use.