Search Results igc_cc_group_u1

Overview

The IGC_CC_GROUPS table is a core data object within the Oracle E-Business Suite (EBS) Financials module, specifically part of the Internet General Ledger (iGL) and Cash Management components under the IGC schema. Its primary role is to store master data for defining approval groups within the system. These groups are logical collections of users who share a common level of approval authority, which is a critical control mechanism for financial workflows such as journal entry approvals. The table maintains an optional relationship with the General Ledger Set of Books (represented by GL_SET_OF_BOOKS), allowing for the definition of unique or shared approval groups across different accounting ledgers within a multi-org implementation.

Key Information Stored

The table's structure is designed to hold both business and technical data. The key business columns include CC_GROUP_ID (the primary key identifier), CC_GROUP_NAME (the unique name of the approval group), and CC_GROUP_DESC (a descriptive field). The critical foreign key column is SET_OF_BOOKS_ID, which links the group to a specific General Ledger ledger set, enabling ledger-specific approval hierarchies. The table also contains a full suite of Standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for audit trail purposes, along with Descriptive Flexfield (DFF) columns (CONTEXT, ATTRIBUTE1-6) for custom extension. The unique index IGC_CC_GROUPS_U2 on SET_OF_BOOKS_ID and CC_GROUP_NAME enforces that group names are unique within a given Set of Books.

Common Use Cases and Queries

This table is central to configuring and reporting on financial approval hierarchies. A common administrative task is querying all approval groups defined for a specific ledger to review or modify security settings. For example, to list all groups for a Set of Books with ID 101, one might use: SELECT cc_group_id, cc_group_name, cc_group_desc FROM igc.igc_cc_groups WHERE set_of_books_id = 101 ORDER BY cc_group_name;. In reporting scenarios, the table is often joined with FND_USER to identify the members assigned to these groups (typically via a related mapping table) for access reviews. Troubleshooting approval workflow issues frequently involves verifying that the correct CC_GROUP_ID is assigned to a user and that it is correctly associated with the intended SET_OF_BOOKS_ID.

Related Objects

The IGC_CC_GROUPS table has defined relationships with several other EBS objects. Its primary foreign key relationship is with GL_SET_OF_BOOKS (via SET_OF_BOOKS_ID), a fundamental table defining an accounting ledger. The table is referenced by its primary key, CC_GROUP_ID, which is enforced by the unique index IGC_CC_GROUP_U1. This key is almost certainly referenced as a foreign key in other IGC tables that assign users or define approval limits to these groups, such as IGC_CC_GROUP_MEMBERS or IGC_CC_APPROVAL_LIMITS, though these specific dependencies are not listed in the provided excerpt. The Standard Who columns (CREATED_BY, LAST_UPDATED_BY) are foreign keys to FND_USER.USER_ID, and LAST_UPDATE_LOGIN references FND_LOGINS.LOGIN_ID.