Search Results pre_run_ci_transfer

Overview

GL_CI_PRE_CROSS_PKG is a private Oracle EBS General Ledger package residing in the APPS schema under AUTHID CURRENT_USER. It belongs to the consolidation and intercompany (CI) processing infrastructure of the General Ledger module. The package name indicates its role: it performs preprocessing work ahead of cross-chart-of-accounts consolidation transfers, hence "PRE_CROSS." It exists to stage and prepare consolidation data before the main transfer engine moves balances between source and target ledgers that may not share an identical chart of accounts structure.

The header comment ("a place to keep COA attributes") confirms that the package is used to cache and resolve chart-of-accounts attributes needed to map source ledger accounting flexfield combinations to their target ledger equivalents. Version 120.5, last modified December 2005, indicates the package is a long-standing, stable piece of the GL consolidation codebase whose interface has not materially changed across the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The package exposes two documented program units:

• GET_SOURCE_GROUP_ID — A function that returns a numeric source group identifier. It accepts a consolidation identifier and a consolidation run identifier as its inputs. In the consolidation model, a "group" represents the set of source ledger and balancing segment ranges being consolidated. This function resolves which source group is associated with a given consolidation definition and run, allowing downstream logic to select the correct set of source balances and mappings. This is the routine most commonly referenced when searching for "get_source_group_id."
• PRE_RUN_CI_TRANSFER — A procedure that performs the pre-transfer processing for a consolidation intercompany run. It is invoked as a concurrent program entry point, which is evident from its standard EBS concurrent signature (errbuf and retcode OUT parameters). Its remaining parameters describe the full runtime context of the consolidation: responsibility and user names, the consolidation request ID, consolidation ID, run ID, target period token, target set of books, database link, source group ID, source set of books, period name, budget name, journal import and journal posting flags, actual flag, request ID, CSJ flag, and a debug flag. The procedure orchestrates setup and validation work — resolving COA attributes and source grouping — before the cross-ledger transfer itself is launched.

Tables Accessed

The supplied ETRM metadata does not enumerate any tables referenced through APPS synonyms. No direct table list is therefore documented for this package. Based on its consolidation role, the package logically depends on the standard GL consolidation and intercompany tables, including the consolidation definitions, consolidation run, and source-group structures, as well as GL chart-of-accounts and period tables. Because no table names are confirmed in the metadata, any specific table reference should be verified directly against the package body in the target instance.

Usage Notes

GL_CI_PRE_CROSS_PKG is an internal helper rather than a published public API; ETRM classifies it as OTHER, and it is referenced by no other documented packages. GET_SOURCE_GROUP_ID is not intended for direct customer invocation, though consolidation diagnostics and custom extensions sometimes call it to determine source grouping. PRE_RUN_CI_TRANSFER is invoked by the General Ledger consolidation concurrent program flow, with the FND concurrent manager supplying the errbuf and retcode parameters and the responsibility passing in the consolidation context. It should not be modified or called directly in production; the supported path for consolidation processing remains the standard GL consolidation windows and concurrent programs.