Results for “get_coa_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GL_COA_MIRROR_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite General Ledger. Its classification in the E-Business Technical Reference Manual (ETRM) is OTHER, meaning it is not a published public API but an internal helper package used by the General Ledger application to support chart of accounts access and mirroring logic. The package provides a small, focused set of routines that resolve and return chart of accounts identifiers for a given access set context, allowing dependent GL code to obtain a valid chart of accounts (COA) identifier without directly querying the underlying access set structures. In the context of release 12.1.1 and 12.2.2, this package remains VALID and is documented with only two subprograms, reflecting its narrow internal role. It exists primarily to centralize the determination of which chart of accounts applies to a given access set, thereby insulating higher-level GL processes from the physical layout of the access set tables.

Key Procedures and Functions

• SET_COA_ID — Establishes or assigns the chart of accounts identifier within the package context. This procedure is used to set the COA ID value that the package will subsequently use or expose, so that calling code can work with a consistent chart of accounts reference tied to the current access set scope.
• GET_COA_ID — Returns the chart of accounts identifier that is currently in effect for the caller. It is the complementary accessor to SET_COA_ID and is typically invoked after the identifier has been resolved, allowing forms, concurrent programs, or internal GL routines to retrieve the chart of accounts ID without re-deriving it.

Only these two subprograms are documented in the ETRM metadata. No parameter lists are documented, and none are asserted here. The pair follows a conventional set/get pattern, in which one routine stores the working chart of accounts identifier and the other retrieves it.

Tables Accessed

The package references the APPS synonym GL_ACCESS_SETS. GL_ACCESS_SETS is the General Ledger table that associates users, responsibilities, or application contexts with the sets of charts of accounts, ledgers, and related accounting structures they are permitted to access. GL_COA_MIRROR_PKG reads this table to determine which chart of accounts identifier applies to the current access set context and to make that identifier available through GET_COA_ID. No other base tables are documented as referenced. The dependency on GL_ACCESS_SETS confirms that the package's purpose is resolution of chart of accounts scope rather than maintenance of the chart of accounts definition itself or of accounting data.

Usage Notes

Because GL_COA_MIRROR_PKG is classified as OTHER and is documented with only two subprograms, it is intended for internal use by Oracle General Ledger and by extensions that must behave exactly as GL does when determining the applicable chart of accounts. It is not referenced by any other documented package, indicating that its callers are forms, concurrent programs, or other Oracle-seeded code rather than a broader public API surface. Typical invocation occurs when a GL form or concurrent program needs to establish the correct chart of accounts context for the current access set before performing downstream processing that depends on that chart of accounts identifier.

Custom code should treat this package as an internal implementation detail. Direct calls are technically possible because the package resides in APPS, but Oracle does not publish its signature or guarantee backward compatibility for it. Developers requiring a supported interface for chart of accounts access should prefer documented GL APIs. When the package is invoked, callers should ensure the GL_ACCESS_SETS context is correctly initialized, since the returned COA identifier depends on that context. The package does not modify data; it resolves and exposes chart of accounts identity for the current access set.