Search Results irep_name




Overview
Explore in AI Chat

Overview

APPS.FND_IREP_ALL_INTERFACES is a reporting and integration view within the Oracle E-Business Suite Applications Object Library. Its name derives from iRep (integration repository) and interfaces, reflecting its purpose: to present a consolidated, queryable catalog of interface and integration points registered across the EBS instance. The view unifies two distinct sources of interface metadata into a single result set, allowing developers, administrators, and integrators to search for interface definitions by name, product, scope, lifecycle, and deployment state through one consistent projection.

The view is particularly relevant to the irep_name search term, because IREP_NAME is the primary logical identifier exposed by this view. Both branches of the underlying UNION ALL query select IREP_NAME as a common column, making it the natural key for cross-referencing interface classes and interface objects. In EBS 12.1.1 and 12.2.2, the integration repository underpins the Interface Repository and the broader integration architecture used by tools such as the Integrated SOA Gateway.

Underlying Base Objects

The view is defined over two documented base objects, both owned by APPS:

  • FND_IREP_CLASSES_VL — a view supplying interface class metadata, including class-level attributes such as CLASS_ID, CLASS_NAME, CLASS_TYPE, deployment and generation flags, and standard/specification details.
  • FND_OBJECTS_VL — a view supplying registered object metadata, filtered by WHERE IREP_NAME IS NOT NULL so that only objects carrying an interface repository name are returned.

Because the view is a UNION ALL rather than a join, rows from FND_IREP_CLASSES_VL and FND_OBJECTS_VL are stacked into one result set. A literal column, SRC_TABLE, is included in each branch to identify the originating base object. Columns that do not apply to a given branch are projected as NULL, so consumers must interpret column values in light of the SRC_TABLE indicator.

Key Columns

Common Use Cases and Queries

The view supports interface discovery, impact analysis, and troubleshooting of load or deployment errors. A typical query searches for a specific interface by name:

  • SELECT irep_name, display_name, src_table FROM fnd_irep_all_interfaces WHERE irep_name = :irep_name;
  • SELECT irep_name, product_code, deployed_flag, load_err, load_err_msgs FROM fnd_irep_all_interfaces WHERE load_err IS NOT NULL;
  • SELECT irep_name, src_table, standard_type, standard_version FROM fnd_irep_all_interfaces WHERE product_code = :product — to enumerate interfaces for a given product.

Because SRC_TABLE distinguishes the origin, administrators can reconcile class-level and object-level registrations and verify that both sides expose a consistent IREP_NAME.