Search Results csi_counter_properties_b_n01

Overview

CSI.CSI_COUNTER_PROPERTIES_B is a transactional table in the Customer Intelligence (CSI) schema of Oracle E-Business Suite, documented as VALID in both release 12.1.1 and 12.2.2. It stores the user-defined properties associated with a counter instance. A counter instance may or may not have counter properties, meaning the relationship between counters and their properties is optional and one-to-many. Each row describes a single property definition—its data type, validation characteristics, default and boundary values, unit of measure, and activation window—thereby allowing extensible, customer-specific metadata to be attached to installed counters without schema modification.

The table resides in the APPS_TS_TX_DATA tablespace with PCT FREE 10 and contains 36 documented columns. Its physical design follows standard EBS conventions, carrying the standard WHO audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER) and a full 15-column ATTRIBUTE DFF block plus ATTRIBUTE_CATEGORY. A MIGRATED_FLAG column supports data migration tracking. A SECURITY_GROUP_ID foreign key references FND_SECURITY_GROUPS, integrating the table with Multi-Org security. The heuristic Data Vault classification derived from the foreign key structure is standalone; from a modeling perspective it may be treated as a satellite-like attribute table that describes counter instances rather than as a hub or link.

Key Information Stored

The surrogate primary key is COUNTER_PROPERTY_ID, which is also the single column of the unique index CSI_COUNTER_PROPERTIES_B_U01 and the table's primary key constraint CSI_COUNTER_PROPERTIES_B_PK. The business linkage to the parent counter is COUNTER_ID, indexed by the non-unique index CSI_COUNTER_PROPERTIES_B_N01. The most significant columns are:

• COUNTER_PROPERTY_ID — Unique surrogate identifier for each counter property record.
• COUNTER_ID — Identifier of the counter instance to which the property belongs.
• PROPERTY_DATA_TYPE — Data type of the property (e.g., text, number, date), governing how the value is interpreted.
• PROPERTY_LOV_TYPE — List of values type; when entered, it is validated against the CSI_CTR_PROPERTY_LOV_TYPE lookup values.
• CREATED_FROM_CTR_PROP_TMPL_ID — Identifier of the counter property template from which this property was generated.
• IS_NULLABLE — Flag indicating whether the property may be left empty.
• DEFAULT_VALUE, MINIMUM_VALUE, MAXIMUM_VALUE — Default, lower-bound, and upper-bound values applied to the property; all are VARCHAR2(240).
• UOM_CODE — Unit of measure code associated with the property value.
• START_DATE_ACTIVE, END_DATE_ACTIVE — Activation date range controlling when the property is effective.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS for security group isolation.
• MIGRATED_FLAG — Indicates records that originated from a migration process.

The surrogate key (COUNTER_PROPERTY_ID) is distinct from any business-key candidate; the only documented unique index is on the surrogate itself, so no alternate natural key is defined in the metadata.

Common Use Cases and Queries

Typical uses include reporting on counter property definitions, auditing template-derived properties, and enforcing data quality rules during counter configuration.

• Retrieve all properties for a given counter:

SELECT counter_property_id, property_data_type, property_lov_type,
       default_value, minimum_value, maximum_value,
       start_date_active, end_date_active
  FROM csi_counter_properties_b
 WHERE counter_id = :p_counter_id;

• Identify properties generated from templates:

SELECT counter_property_id, counter_id, created_from_ctr_prop_tmpl_id
  FROM csi_counter_properties_b
 WHERE created_from_ctr_prop_tmpl_id IS NOT NULL;

• Validate active properties within a date window:

SELECT counter_id, property_data_type, uom_code
  FROM csi_counter_properties_b
 WHERE TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);

• Join to FND_SECURITY_GROUPS to report by security group, and filter migrated records using MIGRATED_FLAG.

Related Objects

The following objects are most significant in relation to CSI_COUNTER_PROPERTIES_B:

• FND_SECURITY_GROUPS — Referenced via CSI_COUNTER_PROPERTIES_B.SECURITY_GROUP_ID for security group validation.
• CSI_COUNTERS (counter instance table) — Linked through COUNTER_ID, serving as the parent that owns the properties.
• CSI_COUNTER_PROPERTY_TEMPLATES — Source of CREATED_FROM_CTR_PROP_TMPL_ID, providing the standard property definitions.
• CSI_CTR_PROPERTY_LOV_TYPE (lookup type) — Validates PROPERTY_LOV_TYPE values.
• FND_LOOKUP_VALUES — Underlying lookup repository for the CSI_CTR_PROPERTY_LOV_TYPE validation.
• CSI_COUNTER_PROPERTIES_TL — If present, holds translated descriptions for the properties defined here.
• CSI_COUNTER_PROPERTY_VALUES — If present, stores the actual captured property values against definitions in this base table.