Search Results as_issue_group_idfr




Overview
Explore in AI Chat

Overview

The AS_ISSUE_GROUP_IDFR table is a Sales Foundation (AS) object owned by the OSM schema in Oracle E-Business Suite 12.1.1 and 12.2.2. As documented in the ETRM repository, its purpose is to "Hold Issue Group Identifiers" — that is, it stores the identifier values and related metadata that define an issue group within the Sales Foundation data model. Issue groups are used to categorize and route sales-related exception conditions, and the identifier rows in this table provide the actual key values, search codes, and classification scheme that qualify each group.

Structurally the table contains 28 documented columns and is anchored by the primary key constraint AS_ISSUE_GROUP_IDFR_PK on ISSUE_GROUP_IDFR_ID, with a unique index AS_ISSUE_GROUP_IDFR_U1 also on ISSUE_GROUP_IDFR_ID. Heuristic Data Vault classification mined from the foreign-key structure identifies this table as standalone. In Data Vault modeling terms, this suggests the table behaves as an independent satellite-like structure rather than a true hub or link; the classification is heuristic and should be treated as a modeling suggestion rather than an authoritative designation.

Key Information Stored

The most significant columns in AS_ISSUE_GROUP_IDFR are those that carry identity, business meaning, and audit context:

  • ISSUE_GROUP_IDFR_ID — the surrogate primary key, defined by AS_ISSUE_GROUP_IDFR_PK and mirrored by the unique index AS_ISSUE_GROUP_IDFR_U1. This is the technical identifier for each row.
  • ISSUE_GROUP_ID — foreign key to AS_ISSUE_GROUPS_B, linking each identifier row to its parent issue group definition.
  • SCHEME — the identifier scheme or namespace under which the VALUE is interpreted.
  • VALUE — the actual identifier value assigned within the given scheme.
  • SEARCH_CODE — a searchable, abbreviated code used for querying and lookup in Sales Foundation screens.
  • SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, controlling which operating unit or security context may access the row.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS audit and concurrency columns (WHO columns).
  • OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF/BC4J framework.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the descriptive flexfield (DFF) segment columns used for customer-configured extensions.

The surrogate key (ISSUE_GROUP_IDFR_ID) is distinct from the business identity, which is expressed through the combination of ISSUE_GROUP_ID, SCHEME, and VALUE. The unique index documented in the metadata confirms ISSUE_GROUP_IDFR_ID as the sole documented business-key candidate.

Common Use Cases and Queries

AS_ISSUE_GROUP_IDFR is queried primarily when resolving the identifiers associated with a given issue group, or when locating an issue group from a known identifier value. Typical queries include:

  • Retrieving all identifier rows for a specific issue group: SELECT scheme, value, search_code FROM as_issue_group_idfr WHERE issue_group_id = :p_group_id;
  • Reverse lookup by identifier value: SELECT issue_group_id, scheme, value FROM as_issue_group_idfr WHERE value = :p_value AND scheme = :p_scheme;
  • Security-filtered reporting joins to FND_SECURITY_GROUPS to restrict results to the current user's operating context.
  • Audit and data-quality reports using the WHO columns to identify recently created or modified identifier definitions.
  • DFF extraction reports reading ATTRIBUTE1–ATTRIBUTE15 and ATTRIBUTE_CATEGORY to surface customer-configured metadata.

Related Objects

  • AS_ISSUE_GROUPS_B — joined via AS_ISSUE_GROUP_IDFR.ISSUE_GROUP_ID = AS_ISSUE_GROUPS_B.ISSUE_GROUP_ID; the parent definition table for issue groups.
  • FND_SECURITY_GROUPS — joined via AS_ISSUE_GROUP_IDFR.SECURITY_GROUP_ID = FND_SECURITY_GROUPS.SECURITY_GROUP_ID; provides security context and access control.
  • AS_ISSUE_GROUPS_TL — the translated (language) counterpart of AS_ISSUE_GROUPS_B, used alongside it to present group descriptions.
  • AS_ISSUE_GROUP_IDFR_PK and AS_ISSUE_GROUP_IDFR_U1 — the primary key constraint and unique index that enforce identity on ISSUE_GROUP_IDFR_ID.
  • FND_SECURITY_GROUPS_VL — the view commonly used to resolve security group names when reporting on identifier rows.

Application code and OAF-based Sales Foundation pages that maintain issue group identifiers read and write this table through the OSM schema. Because the Data Vault classification is standalone, no additional dependent satellite or link tables were mined from the documented metadata.