Search Results p_coa_id

Overview

IGI_DOS_DYNAMIC is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its name reflects its membership in the IGI (Oracle Financials Intelligence / Dossier) module family and its role as a "dynamic" object generator: rather than returning static data, the package constructs Oracle views at runtime based on a caller-supplied chart of accounts identifier. This design pattern is used when an EBS process must resolve account hierarchies or segment values against a specific chart of accounts that is not known until execution time.

The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking schema rather than the definer's privileges. This is significant because view creation requires the appropriate DDL privileges in the session of the caller, and it signals that the package is intended for controlled internal invocation rather than broad public consumption.

Key Procedures and Functions

The package exposes two documented functions. Both accept a single chart of accounts identifier parameter (identified by the search term p_coa_id) and return a VARCHAR2 value. The metadata does not document the returned value's semantics; based on the naming convention, the return string is most plausibly the name of the view that was created or resolved.

• CREATE_SOURCE_ACCOUNTS_VIEW — Builds or resolves the source-side accounts view for the chart of accounts supplied in p_coa_id. The "source" designation indicates the originating side of a transfer, allocation, or reconciliation process.
• CREATE_DEST_ACCOUNTS_VIEW — Performs the parallel operation for the destination side of the same process, using the same chart of accounts identifier. The symmetry between the two functions confirms that the package supports a paired source/destination account resolution model.

The ETRM classification for this package is OTHER, and no further signatures or overloads are documented. The header comment in the source ($Header: igidosbs.pls 115.7 2002/09/05) indicates the package has been stable and largely unchanged since the 11i era.

Tables Accessed

The ETRM metadata records no tables referenced via APPS synonyms for this package. This absence is consistent with the observations above: the documented functions operate through dynamic SQL, and dynamic SQL statements embedded in string literals are not captured by static dependency analysis. Consequently, the underlying account and chart of accounts tables touched by the generated views are invisible to the metadata extractor and cannot be enumerated with confidence from the supplied documentation.

Usage Notes

IGI_DOS_DYNAMIC is referenced by zero other packages according to the ETRM dependency data. This implies the package is invoked from a boundary layer — most likely an Oracle Reports or Forms-based financial process, or a concurrent program — rather than from other PL/SQL APIs. Because it performs DDL (view creation) at runtime, it is unsuitable for direct invocation from custom code that does not hold the requisite privileges, and repeated invocation with the same chart of accounts raises the possibility of object name collisions unless the internal implementation guards against re-creation.

Developers diagnosing issues tied to p_coa_id should verify that the supplied identifier exists in the chart of accounts definition and that the calling session has CREATE VIEW privilege. In EBS 12.2.2 the package remains available under the APPS schema for both the 12.1.1 and 12.2.2 code lines without documented structural change.