Search Results eab_export_wrapper

Overview

JA_CN_ETC_CONC_PROG is an APPS-owned PL/SQL package in Oracle E-Business Suite that supports the China localization (JA_CN) for statutory financial reporting and external data submission. The package name references "ETC" (External Tax/Compliance reporting or External Transfer Consolidation) and "CONC_PROG" (Concurrent Program), indicating it serves as a programmatic engine for concurrent-request-driven extraction, generation, and export of accounting data. Its primary business function is to move journal and balance information from Oracle General Ledger and Subledger Accounting into the formats and structures required by Chinese regulatory and government reporting authorities, particularly the CNAO (China National Audit Office) and related GSSM (Government Statistical / Supervisory Management) export formats.

In EBS 12.1.1 and 12.2.2, the package retains a VALID status and depends only on the SYS.STANDARD package, confirming it is a self-contained application package with no external package dependencies. It is referenced by itself, meaning internal procedures call one another, but no other application package depends on it.

Key Procedures and Functions

The package documents 17 procedures and functions. Core transfer and posting routines include TRANSFER_GL_SLA_TO_CNAO, which moves Subledger Accounting data into CNAO-compatible structures; TRANSFER_GL_JOURNALS, which extracts General Ledger journals for downstream processing; and POST_JOURNAL_ITEMIZED, which itemizes and posts journal entries. GET_DESCRIPTION_FROM_GIS retrieves descriptive metadata, likely from a Government Information System interface.

Export procedures form the largest category: EAB_EXPORT and EAB_EXPORT_WRAPPER handle External Audit Bureau export; EXPORT_COA and EXPORT_COA_ENTRY export the Chart of Accounts and its individual entries; ENT_GSSM_EXPORT and ENT_GSSM_EXPORT_ENTRY provide entity-level GSSM output; PUB_GSSM_EXPORT and PUB_GSSM_EXPORT_ENTRY provide public-sector GSSM output; ACCOUNT_BALANCE_EXPORT and JOURNAL_ENTRY_EXPORT produce account balance and journal entry extracts respectively. The generation counterparts — ACCOUNT_BALANCE_GENERATION and JOURNAL_ENTRY_GENERATION — build the source data sets before export. MULTIORG_MAINTAIN manages multi-organization context. These routines are typically driven by concurrent program submissions.

Tables Accessed

The package accesses FND_LOOKUP_VALUES through its APPS synonym, reading localization lookup codes and meanings that drive conditional logic, format selection, and parameter validation. It also reads JA_CN_SYSTEM_PARAMETERS_ALL, the China localization system parameters table, to obtain organization-specific configuration such as reporting entity identifiers, period settings, and export path or format preferences. These two tables supply the configuration context required by the generation, transfer, and export routines.

Usage Notes

JA_CN_ETC_CONC_PROG is invoked through Oracle EBS concurrent programs registered against its procedures, most commonly from the China localization responsibility. The EXPORT and GENERATION routines are parameter-driven and are scheduled to produce periodic statutory files. Because the package is classified as OTHER rather than a public API and is referenced by no other packages, it should be treated as internal localization logic. Customizations should avoid direct calls and instead use the delivered concurrent program definitions. In 12.1.1 and 12.2.2 the package remains VALID with no dependency changes, so behavior is consistent across both releases.