Search Results interface_table_name




Overview
Explore in AI Chat

Overview

GCS_GL_JI_GROUPS_V is an Oracle EBS view owned by the APPS schema and defined over the General Ledger interface tables. Its purpose is to present a consolidated, de-duplicated list of journal import "groups" that are available for processing, together with the interface table from which each group originates. In Oracle EBS 12.1.1 and 12.2.2, the Journal Import program consumes rows keyed by GROUP_ID; this view allows callers, concurrent programs, and reports to enumerate the distinct group identifiers and the associated journal source, ledger, and request context without scanning the full interface tables directly.

The name carries the "GCS" prefix, indicating the view is associated with the Global Consolidation System (GCS), which relies on journal import interfaces to move consolidation and intercompany data between ledgers. The presence of the INTERFACE_TABLE_NAME column makes the view particularly relevant to users searching for "interface_table_name," since it explicitly exposes which staging table a given group belongs to.

Underlying Base Objects

The ETRM metadata documents the view as a UNION of two SELECT statements drawn from three base tables:

The first branch selects group_id from GL_INTERFACE where GROUP_ID IS NOT NULL and emits a literal NULL for INTERFACE_TABLE_NAME. The second branch selects from GL_INTERFACE_CONTROL joined to GL_JE_SOURCES on JE_SOURCE_NAME, applying the condition NVL(UPPER(INTERFACE_TABLE_NAME),'GL_INTERFACE') <> 'GL_INTERFACE'. This deliberately excludes rows that default to the standard GL_INTERFACE, so the control-table branch only surfaces groups routed through a non-default interface table. The two branches are combined with UNION (not UNION ALL), eliminating duplicates, and ordered by the first column (GROUP_ID).

Key Columns

  • GROUP_ID — the journal import grouping key used to link interface rows into a single import run. This is the ordering and correlation column.
  • INTERFACE_TABLE_NAME — the name (upper-cased) of the interface table associated with the group. It is NULL for groups sourced purely from GL_INTERFACE and populated for groups routed through an alternate interface table.
  • USER_JE_SOURCE_NAME — the user-facing journal source name resolved from GL_JE_SOURCES.
  • SET_OF_BOOKS_ID — the ledger (set of books) identifier to which the group belongs.
  • REQUEST_ID — the concurrent request that created or is associated with the interface group.

Common Use Cases and Queries

Typical usage includes enumerating importable groups prior to invoking Journal Import, identifying the source table for diagnostics, and reporting on interface activity by ledger or source. A representative query:

  • SELECT group_id, interface_table_name, user_je_source_name, set_of_books_id, request_id FROM apps.gcs_gl_ji_groups_v WHERE set_of_books_id = :ledger ORDER BY group_id;
  • SELECT group_id, interface_table_name FROM apps.gcs_gl_ji_groups_v WHERE interface_table_name IS NOT NULL; — isolates groups routed through a non-default interface table.
  • SELECT DISTINCT request_id, group_id FROM apps.gcs_gl_ji_groups_v WHERE user_je_source_name = :source;

Because the metadata documents no base objects beyond the three interface and source tables, all reported values derive directly from GL_INTERFACE, GL_INTERFACE_CONTROL, and GL_JE_SOURCES.