Search Results edw_instance




Overview
Explore in AI Chat

Overview

The APPS.EDW_INSTANCE package body is a utility component within the Oracle E-Business Suite Enterprise Data Warehouse (EDW) infrastructure. Its primary business function is to provide a centralized, programmatic mechanism for resolving instance-level identification and configuration details at runtime. In the context of Oracle EBS 12.1.1 and 12.2.2, the EDW schema family (including EDW_INSTANCE and its dependency EDW_LOCAL_INSTANCE) supports the collection, staging, and propagation of data used by Oracle's warehouse and business intelligence integrations, such as Daily Business Intelligence and related analytical products.

The package is classified under the ETRM API classification of OTHER, indicating that it is an internal supporting utility rather than a public, customer-facing API. It is a VALID, compiled package body owned by the APPS schema, and it plays a supporting role in resolving which logical instance is executing, which is essential when a single database hosts multiple EBS instances or when collectors must distinguish between local and remote instance contexts.

Key Procedures and Functions

The ETRM metadata documents a single procedure or function within the package body: GET_CODE.

  • GET_CODE — The sole documented program unit in the package. Consistent with the package's naming and the broader EDW instance-resolution pattern, GET_CODE returns a code value that identifies or maps the current instance context. Because the ETRM record does not expose the formal parameter list, no signature detail is asserted here; the documented fact is limited to its existence and its membership in this package.

No additional procedures or functions are documented for this package body. The implementation relies on the standard SYS.STANDARD package, confirming that GET_CODE is implemented using core PL/SQL constructs rather than external library calls.

Tables Accessed

The ETRM metadata records a single referenced table, accessed through an APPS synonym:

  • EDW_LOCAL_INSTANCE — This table supplies the instance-level information that the package consumes. It typically stores the identity of the local EDW instance, allowing GET_CODE to resolve and return the appropriate instance code for the executing environment. The package reads from this table rather than maintaining its own persistent state.

No insert, update, or delete operations are documented, which is consistent with the read-oriented utility nature of the package.

Usage Notes

EDW_INSTANCE is referenced by 52 other packages within the APPS schema, while it itself does not reference or depend upon any other database object beyond EDW_LOCAL_INSTANCE and SYS.STANDARD. This high inbound reference count demonstrates that the package functions as a widely shared dependency across the EDW and business intelligence layer.

  • Invocation context — The package is typically invoked from within other PL/SQL packages, concurrent program logic, and warehouse collection routines that require knowledge of the current instance. It is not associated with a specific Oracle Forms module or standalone concurrent program in the documented metadata.
  • Custom code guidance — Because the package is classified as OTHER and is an internal implementation component, direct invocation from custom code is generally discouraged. Developers should not depend on undocumented behavior, and no parameter list is published in ETRM.
  • Version applicability — The metadata applies to Oracle EBS 12.1.1 and remains relevant for 12.2.2, where EDW-based analytics continue to depend on instance resolution.

In summary, APPS.EDW_INSTANCE is a compact but heavily depended-upon utility that resolves instance identity for the Oracle EBS data warehouse stack through its single GET_CODE program unit and its read access to EDW_LOCAL_INSTANCE.