Search Results etrm_fndnav




Overview
Explore in AI Chat

Overview

ETRM_FNDNAV is the navigation and repository-query package of eTRM (the Oracle Applications repository browser and dependency report), a diagnostic utility shipped within the Oracle E-Business Suite applications schema. Its source header attributes authorship to Peter Goldthorp with a creation date of 9 October 2001, and the copyright range extends through 2014, reflecting the package's continued maintenance across the 11i, 12.1.1 and 12.2.2 release families. The package is owned by APPS and is classified as OTHER in the ETRM metadata registry rather than as a formal public API. In Oracle EBS 12.1.1 and 12.2.2 the package serves an internal, developer- and support-facing purpose: it exposes the data dictionary and Application Object Library metadata that describe applications, objects, executables, concurrent programs, lookups, indexes and file attachments. It allows an administrator or support engineer to list the contents of an application, identify the owning schema of a database object, and drill from an eTRM file attachment to the object it references.

Key Procedures and Functions

  • SHOW_FILE — Renders or attaches an eTRM file record identified by a file identifier, with a display mode argument that defaults to the attachment behaviour. It drives the file-viewing side of the repository browser.
  • LS_APPS — Lists the applications known to the repository. It provides the entry-level inventory of registered Oracle Applications products.
  • LS_OBJECT — Lists database objects, optionally restricted by application identifier, object name and object type. Both filter arguments default to the wildcard '%', so an unrestricted call returns the full object inventory.
  • SHOW_OBJECT — Displays the detail of a single object, taking a table identifier, an application identifier and an object type. It is the drill-down counterpart to LS_OBJECT.
  • GET_OWNER — A function that accepts an object name and object type from DBA_OBJECTS and returns the owning schema as a string. This is the routine surfaced by the search term "get_owner"; it allows callers to resolve the schema that owns a given database object without querying DBA_OBJECTS directly, which is useful when the caller has only the object's name and type.

Tables Accessed

The package reads DBA_OBJECTS as its primary data dictionary source for object names, types and ownership. File attachment records are held in FND_ETRM_FILES. Product registration and naming come from FND_APPLICATION, FND_APPLICATION_TL and FND_PRODUCT_GROUPS. Concurrent program and executable metadata is read from FND_CONCURRENT_PROGRAMS, FND_CONCURRENT_PROGRAMS_TL, FND_EXECUTABLES and FND_EXECUTABLES_TL; index metadata from FND_INDEXES and FND_INDEX_COLUMNS; column metadata from FND_COLUMNS; and lookup metadata from FND_LOOKUP_TYPES, FND_LOOKUP_TYPES_TL, FND_LOOKUP_VALUES. All access is read-only through APPS synonyms, consistent with a browser and dependency-reporting tool.

Usage Notes

ETRM_FNDNAV is invoked by the eTRM repository browser rather than by standard EBS business flows. In 12.1.1 and 12.2.2 it is typically called from the eTRM forms or from custom diagnostic scripts and concurrent programs that need to enumerate applications, objects or attachments, or to resolve an object's owning schema via GET_OWNER. The metadata records one referencing package, indicating limited dependency exposure. Because the package queries DBA_OBJECTS directly, the invoking session requires sufficient privileges, and it should be treated as a support and diagnostic utility rather than as a supported integration API.