Search Results asg_column_groups




Overview
Explore in AI Chat

Overview

The ASG_COLUMN_GROUPS table is a core data object within the ASG (CRM Gateway for Mobile Devices) product family of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. This module facilitates the synchronization of CRM data between the central EBS database and mobile devices. The table's primary role is to define logical groupings of columns from base application tables. These groupings are essential for the data replication and synchronization engine, as they allow the system to manage and transmit discrete, related sets of data fields to mobile clients efficiently, rather than handling all table columns as a single unit. It acts as a metadata repository that governs how data subsets are packaged for mobile operations.

Key Information Stored

The table's structure is centered around the unique identification and definition of these column groups. The most critical column, as indicated by the user's search, is COLUMN_GROUP_ID. This serves as the primary key (via the ASG_COLUMN_GROUPS_PK constraint) and uniquely identifies each defined column group within the system. Another significant column is SNAPSHOT_LOG_ID, which is a foreign key linking to the ASG_SNAPSHOT_LOGS table. This relationship ties a column group to a specific snapshot or log of data changes, forming the basis for incremental synchronization. While the full column list is not detailed in the provided metadata, typical supporting columns would include data for the group's name, description, associated base table, and technical flags controlling its synchronization behavior.

Common Use Cases and Queries

The primary use case involves the setup, administration, and troubleshooting of the mobile synchronization framework. An administrator might query this table to audit which column groups are configured for a particular application table or to investigate synchronization issues. A common diagnostic query would join ASG_COLUMN_GROUPS with related tables to understand the data flow. For example, to list all column groups and their associated snapshot logs, one might use:

  • SELECT cg.column_group_id, cg.snapshot_log_id, sl.log_table_name FROM asg_column_groups cg, asg_snapshot_logs sl WHERE cg.snapshot_log_id = sl.snapshot_log_id;

Another typical pattern is resolving a specific column group's configuration details by its ID, which is central to many backend synchronization processes.

Related Objects

As per the provided metadata, ASG_COLUMN_GROUPS has defined relationships with several other key tables in the ASG schema. It is referenced by a foreign key from the ASG_CONF_RESOLUTION table via its COLUMN_GROUP_ID column, indicating its role in conflict resolution rules for synchronized data. Furthermore, it holds a foreign key relationship to the ASG_SNAPSHOT_LOGS table through its SNAPSHOT_LOG_ID column, linking the logical column group to the physical mechanism that tracks data changes. These relationships position ASG_COLUMN_GROUPS as a central hub in the metadata architecture that connects synchronization rules (ASG_CONF_RESOLUTION) with the data capture mechanism (ASG_SNAPSHOT_LOGS).