Search Results ja_cn_gl_inter_valid_pkg




Overview
Explore in AI Chat

Overview

The APPS.JA_CN_GL_INTER_VALID_PKG package is a China Localizations (JA_CN) database component delivered with Oracle E-Business Suite 12.1.1 and 12.2.2. Its stated purpose, as documented in the package header, is to support GL Journals and Intercompany Transactions Validation within the CNAO (China National Audit Office) Project. The package validates General Ledger journal entries and intercompany transactions, identifying and reporting those records that fail the localizations' validation rules so that they can be reviewed or corrected prior to statutory reporting.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user and resolves unqualified object references against that user's schema, relying on APPS synonyms for underlying data access. Source control history in the header shows creation in February 2006, with subsequent updates in 2007 and an enhancement in April 2008 designated "CNAO Enhancement," which added handling of the company segment. The most recent source revision referenced is 120.2.12010000.2.

Key Procedures and Functions

  • GL_VALIDATION — A public procedure that checks General Ledger journals and outputs the invalid ones. It is the primary validation entry point for journal-level data, accepting inbound selection criteria and returning status through its OUT parameters errbuf and retcode, consistent with the standard concurrent program interface convention. Among the documented inbound parameters is P_START_PERIOD, which specifies the starting accounting period for the validation range; together with P_END_PERIOD it bounds the period window examined. The procedure also accepts a chart of accounts identifier, legal entity identifier, ledger identifier, journal source, journal category, and a GL status transferred from AGIS.
  • INTERCOMPANY_VALIDATION — A public procedure dedicated to validating intercompany transactions. It operates against the intercompany transaction tables to detect entries that do not satisfy the localizations' intercompany matching and validation requirements.

Both procedures are classified in the ETRM metadata under API classification "OTHER."

Tables Accessed

The package reads from a broad set of APPS-synonymed tables spanning several EBS modules:

Usage Notes

The procedure signatures, with OUT errbuf and retcode parameters, indicate that JA_CN_GL_INTER_VALID_PKG is designed for use as a concurrent program, typically invoked from the Submit Requests form or through host/Java concurrent managers, rather than being called interactively. The P_START_PERIOD and P_END_PERIOD parameters allow requesters to narrow validation to a specific accounting period range. The package is referenced by one other package within the EBS codebase, indicating that it may also be called programmatically by dependent localization code. Custom implementations should invoke the public procedures only, supply period values in the format expected by the localization, and monitor the returned status values to determine whether invalid journals or intercompany transactions were detected.