Search Results ahl_relationships_b

Overview

The CS_COUNTER_GROUPS table is a core data repository within the Oracle E-Business Suite Service (CS) module, specifically designed for managing counter groups. It serves a dual purpose, storing both counter group templates and their associated instances. A counter group is a logical collection of individual counters used to track usage, performance, or other measurable metrics for serviceable assets or items. This table is fundamental for implementing sophisticated service and maintenance strategies based on actual equipment usage, enabling features like preventive maintenance scheduling, warranty validation, and service contract fulfillment. Its role is central to the asset and service lifecycle management processes in both EBS 12.1.1 and 12.2.2.

Key Information Stored

While the provided metadata does not list specific columns beyond key identifiers, the primary and foreign key relationships reveal the critical data attributes. The table's structure is defined by a primary key, COUNTER_GROUP_ID, which uniquely identifies each record. A unique key constraint on SOURCE_OBJECT_CODE and SOURCE_OBJECT_ID links the counter group to its parent entity in the system, such as a specific item instance. The foreign key SOURCE_OBJECT_ID references the CSI_ITEM_INSTANCES table, establishing the connection to the physical or logical asset being monitored. Additional self-referencing foreign keys, CREATED_FROM_CTR_GRP_TMPL_ID and SOURCE_COUNTER_GROUP_ID, manage hierarchical and templating relationships between counter group records, allowing for the creation of instances from templates and the cloning of groups.

Common Use Cases and Queries

A primary use case is retrieving all counter groups associated with a specific asset for a service work order or maintenance check. For example, a technician may query the counters on a machine to determine if usage thresholds for maintenance have been met. Another common scenario involves administrative setup, where templates are queried and used to generate new counter groups for newly deployed assets. Sample SQL patterns often involve joining to CSI_ITEM_INSTANCES to get asset details and to CS_COUNTERS to list the individual counters within the group.

• Find Counter Groups for an Item Instance: SELECT cg.* FROM cs_counter_groups cg, csi_item_instances cii WHERE cg.source_object_id = cii.instance_id AND cii.serial_number = 'XYZ123';
• List Counters within a Group: SELECT c.* FROM cs_counters c WHERE c.counter_group_id = <GROUP_ID>;

Related Objects

The CS_COUNTER_GROUPS table is a nexus within the counter management schema, with extensive relationships to other key service tables.

• Referenced by this table (Outgoing Foreign Keys):
  • CS_COUNTER_GROUPS (self): Via CREATED_FROM_CTR_GRP_TMPL_ID and SOURCE_COUNTER_GROUP_ID for template and source relationships.
  • CSI_ITEM_INSTANCES: Via SOURCE_OBJECT_ID to link the group to an asset.
• References this table (Incoming Foreign Keys):
  • AHL_RELATIONSHIPS_B: Links counter groups to complex asset structures in the Advanced Service Management module.
  • CS_COUNTERS: The core table for individual counter definitions, child to a counter group.
  • CS_COUNTER_GROUPS (self): As the parent in the template/source relationship.
  • CS_COUNTER_GRP_LOG: Stores historical log or transaction data for the counter group.
  • CS_CTR_ASSOCIATIONS: Manages associations between counter groups and other service entities like service requests or contracts.