Search Results jai_cmn_gl_pkg




Overview
Explore in AI Chat

Overview

JAI_CMN_GL_PKG is a common utility package body in the APPS schema that supports the integration of Oracle E-Business Suite subledger transactions with Oracle General Ledger. Its name, prefixed with the JAI convention used for Oracle Financials for India (localization) components, indicates that it serves centralized General Ledger interface handling for the India localizations, though its design is generic enough to be invoked from other JAI subledger modules. The package encapsulates the logic required to translate transactional accounting data into rows suitable for the GL_INTERFACE table, and to resolve account combinations and currency attributes needed during that translation. In EBS 12.1.1 and 12.2.2 the package is documented with a status of VALID and an API classification of OTHER; it is not itself a public API flagged for external development, but is referenced by thirteen other database objects, confirming its role as a shared internal service.

Key Procedures and Functions

The ETRM metadata documents three procedures and functions within this package body:

  • GET_ACCOUNT_NUMBER — Resolves and returns the accounting flexfield account number (typically the concatenated account combination) used when constructing General Ledger interface entries. It relies on the key flexfield structure and segment definitions held in the applications flexfield tables.
  • CREATE_GL_ENTRY — Builds and stages one or more General Ledger interface records representing the accounting impact of a transaction, including balancing and descriptive attributes needed for GL posting.
  • CREATE_GL_ENTRY_FOR_OPM — A variant of the GL entry creation logic tailored for Oracle Process Manufacturing (OPM) source transactions, producing interface rows with the appropriate accounting and reference information for OPM-originated events.

No parameter signatures are asserted here; the documented evidence names the routines and their purpose only.

Tables Accessed

The package reads and writes the following documented objects, referenced through APPS synonyms:

  • GL_INTERFACE — The staging table into which the package writes accounting lines for subsequent import and posting into General Ledger. This is the primary write target.
  • FND_ID_FLEX_SEGMENTS — Provides key flexfield segment metadata used in constructing and validating account combinations.
  • FND_CURRENCIES — Supplies currency definitions and precision information for monetary conversions on interface rows.
  • DUAL — Used for single-row calculations and scalar expression evaluation.

Dependency metadata additionally lists GL_SETS_OF_BOOKS, ORG_ORGANIZATION_DEFINITIONS, JAI_CONSTANTS, JAI_PLSQL_CACHE_PKG, FND_FILE, and the DBMS_SQL/DBMS_STANDARD/STANDARD packages, indicating that set of books, organization, and cached JAI constant values are also consumed during entry creation.

Usage Notes

JAI_CMN_GL_PKG is an internal, dependency-driven package rather than a directly executed concurrent program. It is normally invoked in the following contexts:

  • Called by other JAI localization packages (thirteen referencing objects) during subledger transfer-to-GL processing for Indian regulatory and statutory reporting requirements.
  • Invoked from custom or seeded concurrent programs that extract and prepare GL interface data for OPM and non-OPM source transactions.
  • Used inside custom PL/SQL code where account number resolution or GL interface row construction is required without invoking the full standard GL transfer flow.

Because the package manipulates GL_INTERFACE directly, callers are responsible for ensuring that a valid GL import run and set of books context is in place before execution, and that commit and error-handling conventions are observed. It should not be modified without review, since its interfaces are shared across multiple JAI modules.