Search Results cs_counter_properties




Overview
Explore in AI Chat

Overview

The CS_COUNTER_PROPERTIES table is a core data object within the Oracle E-Business Suite Service (CS) module, specifically for the Installed Base and Service Management functionalities. It serves as the master repository for defining and storing the configurable properties or attributes associated with a counter. A counter is a measurable metric tracked for an item or instance, such as odometer readings, engine hours, or copy counts. This table enables the flexible definition of counter behavior, including value derivation rules, filtering criteria, and template-based creation, which is essential for complex service contracts, maintenance schedules, and usage-based billing.

Key Information Stored

The table's structure centers on uniquely identifying a property for a specific counter and defining its characteristics. The primary keys, CS_COUNTER_PROPERTIES_UK1 (COUNTER_ID, NAME) and CS_COUNTER_PROPERTY_PK (COUNTER_PROPERTY_ID), enforce this uniqueness. Key columns include COUNTER_PROPERTY_ID as the unique system identifier, COUNTER_ID as the foreign key to the parent counter in CS_COUNTERS, and NAME for the property's designation. Critical relational columns are CREATED_FROM_CTR_PROP_TMPL_ID and SOURCE_COUNTER_PROP_ID, which support template-driven creation and property derivation hierarchies, respectively. These columns facilitate the replication and inheritance of property definitions across counters.

Common Use Cases and Queries

A primary use case is analyzing the complete set of properties defined for a specific counter to understand its configurable attributes. This is vital for troubleshooting counter behavior or validating setup. A typical query would join CS_COUNTER_PROPERTIES to CS_COUNTERS. Another critical scenario involves tracing the lineage of a derived property to its source, which is essential for auditing and impact analysis when source properties are modified. This requires a self-join on the SOURCE_COUNTER_PROP_ID column. Reporting use cases often involve aggregating property data across multiple counters for a customer or product line to ensure consistency in service definitions.

Related Objects

The table maintains integral relationships with several other Service module objects, as documented by its foreign keys. The primary relationship is with the CS_COUNTERS table (via COUNTER_ID), which is the parent entity. It has a recursive relationship with itself for derivation (SOURCE_COUNTER_PROP_ID) and template creation (CREATED_FROM_CTR_PROP_TMPL_ID). Key dependent tables include CS_COUNTER_PROP_VALUES, which stores the actual recorded values for each property, and CS_COUNTER_DER_FILTERS, which stores filters used in property derivation logic. Furthermore, the CS_COUNTERS table references a specific property as a derivation source via its DERIVE_PROPERTY_ID column, creating a bidirectional relationship.