Search Results cst_cimp_group_id




Overview
Explore in AI Chat

Overview

The CST_CIMP_GROUP_ID view is a dictionary object owned by the APPS schema and classified under the BOM – Bills of Material product family. It functions as a consolidation and lookup layer over the Cost Management open interface tables used during item cost and resource cost import processing. Rather than presenting the full contents of any single interface table, the view produces a de-duplicated, filter-ready list of interface group identifiers that are awaiting processing. In this sense it acts as a control view: it tells the application which batch groups exist in the costing interfaces and which of those groups are eligible to be picked up by the cost interface worker.

Its role in Oracle EBS 12.1.1 and 12.2.2 reporting and integration is that of a driver for concurrent processing and for user-facing selection lists. Downstream processes frequently need to enumerate valid, unprocessed group IDs before invoking the cost import programs, and the view supplies that enumeration without requiring the caller to query several interface tables independently.

Underlying Base Objects

The view is defined as a UNION of four interface tables, each exposed in the APPS schema through a synonym:

Each branch of the UNION selects the group identifier and description from the respective table, applying a common filter: GROUP_ID must be non-null, PROCESS_FLAG must equal 1, and ERROR_FLAG must be null. These predicates restrict the result set to groups that are flagged for processing and free of prior errors. The numeric literal appended in each branch (1, 2, or 3) serves as a source discriminator, distinguishing item cost details (1), resource costs (2), and the two overhead tables (3).

Key Columns

  • GROUP_ID – the interface group identifier, returned as a character value via TO_CHAR. It corresponds to the GROUP_ID column of each underlying interface table and is the primary join key to those tables.
  • DESCRIPTION – the group description (GROUP_DESCRIPTION) carried from the interface row, used for display and identification in forms and reports.
  • SRC_TABLE – the numeric source discriminator (1, 2, or 3) indicating which interface table the group originated from. Because the UNION produces one row per qualifying group per source table, the same GROUP_ID may legitimately appear more than once with different SRC_TABLE values.

Common Use Cases and Queries

A typical use is to populate a selection list of unprocessed costing groups before running the cost interface import. A simple listing query is:

  • SELECT GROUP_ID, DESCRIPTION, SRC_TABLE FROM APPS.CST_CIMP_GROUP_ID ORDER BY GROUP_ID;

To isolate the groups originating from a specific interface, filter on the source discriminator:

  • SELECT GROUP_ID, DESCRIPTION FROM APPS.CST_CIMP_GROUP_ID WHERE SRC_TABLE = 2;

To reconcile the view against a single interface table, join back on the character-converted key:

  • SELECT v.GROUP_ID, v.DESCRIPTION FROM APPS.CST_CIMP_GROUP_ID v, APPS.CST_ITEM_CST_DTLS_INTERFACE i WHERE v.GROUP_ID = TO_CHAR(i.GROUP_ID) AND v.SRC_TABLE = 1;

Because the view deliberately excludes rows where ERROR_FLAG is populated, it should not be used to diagnose failures; error analysis requires direct queries against the underlying interface tables.