Search Results c_journal




Overview
Explore in AI Chat

Overview

The APPS.JA_CN_ACC_JE_ITEMIZATION_PKG package body is a China localization component of Oracle E-Business Suite, delivered under the JACNAJIB.pls source file (version 120.9, last updated 11 December 2007). Its stated purpose is to support account and journal itemization — the process of expanding, structuring, and reconciling general ledger journal detail so that Chinese statutory reporting requirements are satisfied. The package operates against the certified ledger and legal entity configuration and produces itemized journal records held in the JA_CN (China) localization tables.

The package body declares module-scoped globals (l_Module_Prefix, l_Chart_Of_Accounts_Id, l_Legal_Entity_Id, l_ledger_id, and l_Project_Option) that carry ledger and chart-of-accounts context across the public procedures. A notable design point, introduced in the April 2007 update for Release 12, is the use of the Supporting Reference functionality to extract project and third-party information into the itemization output.

Key Procedures and Functions

The package exposes a documented procedure list covering the end-to-end itemization lifecycle:

  • populate_journal_of_period — populates journal-of-period data, the entry point for assembling journals attributable to a given accounting period.
  • unitemize_journal_lines — reverses or removes prior itemization on journal lines.
  • generate_code_combination_view — constructs the code combination view used to resolve accounting flexfield segments for itemization (updated April 2006).
  • get_period_range — derives the accounting period range driving the selection of journals.
  • transfer_gl_sla_to_cnao — the single procedure classified in ETRM documentation as the documented API entry point; it moves GL/SLA (Subledger Accounting) balances and journal information into the China localization store.
  • generate_journal_and_line_num — assigns journal and line numbering to itemized records.
  • purge_unmatch_lines — removes unmatched lines during reconciliation (added May 2006).
  • get_journal_approver — resolves the approver associated with a journal (added May 2006).
  • get_lookup_code — retrieves lookup values used for classification and validation of itemization data.

A diagnostic helper, test_concurrent_conflict, writes to the FND log to test concurrent-program serialization on the shared package state.

Tables Accessed

The package reads and writes through APPS synonyms. Core GL sources include GL_JE_BATCHES, GL_JE_HEADERS, GL_JE_LINES, GL_JE_SOURCES_TL, GL_LEDGERS, and GL_PERIODS, providing the journal, ledger, and period context for selection and transfer. China localization targets are 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, which hold the itemized output and legal-entity/balancing-segment assignments. Configuration and reference data are drawn from FND_ID_FLEX_SEGMENTS, FND_SEGMENT_ATTRIBUTE_VALUES, FND_LOOKUP_VALUES, and FND_USER (for approver identification).

Usage Notes

This package is invoked from China localization concurrent programs and supporting forms rather than from general business flows. The transfer_gl_sla_to_cnao procedure serves as the documented API surface, while the remaining procedures are internally orchestrated to populate, number, approve, and purge itemized journals. The presence of test_concurrent_conflict and the module-level globals indicates that concurrent programs sharing this package require serialization; a conflict test utility is provided for diagnosis. Because the package references Release 12 Supporting Reference functionality, it must run in an R12 environment (12.1.1 or 12.2.2) with the China localization patch set applied. As the package is referenced by one other package, changes to its behavior can propagate to dependent localization code and should be regression-tested accordingly.