Search Results ja_cn_acc_je_itemization_pkg




Overview
Explore in AI Chat

Overview

JA_CN_ACC_JE_ITEMIZATION_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. It belongs to the China localizations layer (product prefix JA, module CN) and is responsible for account and journal itemization processing, specifically the generation of itemized journal data for Chinese statutory accounting and reporting requirements. The package is compiled with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the package owner.

The package header carries the RCS identifier JACNAJIS.pls 120.0.12000000.1, dated 13 August 2007, and was originally authored by Qingjun Zhao in April 2007. Its stated purpose is to support account and journal itemization, and its documented procedure list includes populate_journal_of_period, get_description_from_GIS, unitemize_journal_lines, generate_code_combination_view, get_period_range, transfer_gl_sla_to_cnao, and generate_journal_and_line_num. The ETRM 12.2.2 metadata classifies the package as OTHER and documents one public entry point, TRANSFER_GL_SLA_TO_CNAO. The presence of get_description_from_GIS in the procedure list is consistent with the user's search term; this procedure is part of the package's itemization processing but is not the documented public API in the ETRM registry.

Key Procedures and Functions

The documented public procedure is TRANSFER_GL_SLA_TO_CNAO. According to the header comments, this is the main procedure through which other procedures are called, dispatched according to the source and category of the journal. It then invokes journal number and journal line number generation and calls the post program. Its documented parameters include out parameters errbuf and retcode (mandatory for PL/SQL concurrent programs) and in parameters P_chart_of_accounts_id, p_period_name, and p_legal_entity_ID.

The header additionally lists the following procedures, which support the itemization workflow:

  • populate_journal_of_period — populates journal-of-period records used in the itemization process.
  • get_description_from_GIS — retrieves description information from the GIS (General Information System) source for use in itemized journal output.
  • unitemize_journal_lines — reverses or clears itemization on journal lines.
  • generate_code_combination_view — builds a code combination view used for account itemization.
  • get_period_range — derives the accounting period range for processing.
  • generate_journal_and_line_num — generates journal numbers and journal line numbers for the transferred data.

The ETRM registry does not publish parameter lists for these supporting procedures, and none are invented here.

Tables Accessed

The package reads and writes a set of standard EBS and China localization tables through APPS synonyms. Core General Ledger tables include GL_JE_BATCHES, GL_JE_HEADERS, GL_JE_LINES, GL_JE_SOURCES_TL, GL_LEDGERS, and GL_PERIODS, which supply journal source, ledger, and period context. Flexfield and setup tables — FND_ID_FLEX_SEGMENTS, FND_SEGMENT_ATTRIBUTE_VALUES, FND_LOOKUP_VALUES, and FND_USER — provide chart of accounts structure, segment attributes, lookup values, and user context. The China localization tables JA_CN_JOURNALS_OF_PERIOD, JA_CN_JOURNAL_LINES, JA_CN_JOURNAL_LINES_REQ, JA_CN_JOURNAL_LINES_REQ_S, and JA_CN_LEDGER_LE_BSV_GT store the itemized output, required journal line details, and legal-entity/ledger balancing segment values. Together these tables support extracting subledger accounting (SLA) journal data and converting it into the Chinese itemized journal format.

Usage Notes

Because TRANSFER_GL_SLA_TO_CNAO declares errbuf and retcode as concurrent program standard out parameters, the package is designed for invocation from an Oracle EBS concurrent program. It is typically scheduled or submitted to transfer General Ledger SLA data into the China localization journal tables, then generate journal and line numbers and trigger posting. The package does not expose a user-facing form API; it is invoked through the concurrent manager or from custom PL/SQL that calls the public procedure. In Oracle EBS 12.1.1 and 12.2.2, references to subledger accounting data rely on the standard SLA schema, and the China localization tables must be populated and consistent with the ledger and legal entity parameters passed at runtime. The package is referenced by one other package in the ETRM registry, indicating that it forms part of a larger China localization processing chain rather than standing alone.