Search Results generated_flag

Overview

FND_IREP_ALL_INTERFACES is a reporting view owned by the APPS schema in Oracle E-Business Suite Application Object Library (FND). It consolidates metadata about all registered interface repository (IREP) interfaces and IREP objects across the E-Business Suite. The view presents a unified inventory of interface definitions — both class-level interfaces from FND_IREP_CLASSES and object-level interfaces from FND_OBJECTS — so that administrators, developers, and integration analysts can inspect every interface known to the system from a single query point. Because it unifies two distinct metadata sources, the view is a convenient reference for determining which interfaces are deployed, generated, compatible, or open, and for tracing the source files and standards that govern each interface.

Underlying Base Objects

The view is defined as a UNION ALL of two dictionaries, each sourced from a validation view:

• FND_IREP_CLASSES_VL — contributes class-level interface records. Its columns are aliased into the view's canonical column set (CLASS_ID, CLASS_NAME, CLASS_TYPE, PRODUCT_CODE, DEPLOYED_FLAG, GENERATED_FLAG, COMPATIBILITY_FLAG, and related attributes). The literal 'FND_IREP_CLASSES' is projected into SRC_TABLE to identify the origin.
• FND_OBJECTS_VL — contributes object-level interface records, restricted by WHERE IREP_NAME IS NOT NULL. Attributes are mapped into the same canonical columns (OBJECT_ID as CLASS_ID, OBJ_NAME as CLASS_NAME, IREP_OBJECT_TYPE as CLASS_TYPE, and so on), with 'FND_OBJECTS' projected into SRC_TABLE.

Both base objects are views in the APPS schema. The SRC_TABLE column is the discriminator that allows consumers to distinguish which underlying source produced a given row.

Key Columns

• CLASS_ID / CLASS_NAME — Identifier and name of the interface class or object.
• IREP_NAME — The registered interface repository name; the primary linkage key across IREP metadata.
• CLASS_TYPE — The classification of the interface (for object-sourced rows this carries IREP_OBJECT_TYPE). This column is frequently queried to filter interfaces by category.
• PRODUCT_CODE — Owning product (for object rows, IREP_PRODUCT).
• DEPLOYED_FLAG / GENERATED_FLAG / COMPATIBILITY_FLAG — Deployment, generation, and compatibility status indicators (CLASS_TYPE rows); object rows populate IREP_COMPATIBILITY into COMPATIBILITY_FLAG.
• SCOPE_TYPE / LIFECYCLE_MODE — Interface scope and lifecycle designation (IREP_SCOPE, IREP_LIFECYCLE for object rows).
• SOURCE_FILE_PRODUCT / PATH / NAME / VERSION — Physical source artifact metadata for each interface.
• STANDARD_TYPE / VERSION / SPEC — Governing standard information (IREP_STANDARD for object rows).
• OPEN_INTERFACE_FLAG — Indicates whether the interface is exposed as an open interface (class rows only).
• SRC_TABLE — Origin discriminator: FND_IREP_CLASSES or FND_OBJECTS.
• LOAD_ERR / LOAD_ERR_MSGS — Load error status and messages for the interface record.

Common Use Cases and Queries

Typical uses include auditing all registered interfaces, filtering by CLASS_TYPE, isolating interfaces sourced from a particular product, and checking deployment or compatibility status before integration work.

List all interfaces with origin and product:

SELECT CLASS_NAME, IREP_NAME, CLASS_TYPE, PRODUCT_CODE, SRC_TABLE
FROM   APPS.FND_IREP_ALL_INTERFACES
ORDER  BY SRC_TABLE, CLASS_NAME;

Locate a specific class_type (the user's search context):

SELECT CLASS_NAME, IREP_NAME, PRODUCT_CODE, DEPLOYED_FLAG
FROM   APPS.FND_IREP_ALL_INTERFACES
WHERE  CLASS_TYPE = :class_type;

Restrict to object-sourced interfaces for a given product:

SELECT IREP_NAME, CLASS_NAME, COMPATIBILITY_FLAG
FROM   APPS.FND_IREP_ALL_INTERFACES
WHERE  SRC_TABLE = 'FND_OBJECTS'
AND    PRODUCT_CODE = :product_code;

Identify interfaces with load errors or non-deployed status:

SELECT CLASS_NAME, IREP_NAME, LOAD_ERR, LOAD_ERR_MSGS
FROM   APPS.FND_IREP_ALL_INTERFACES
WHERE  LOAD_ERR IS NOT NULL OR DEPLOYED_FLAG = 'N';