Results for “right_paren”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CS_COUNTER_DER_FILTERS is a Service (CS) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the filter conditions used by counter-derived group operations. Its documented purpose is to hold the individual predicate expressions that govern how a counter and its associated counter properties are evaluated when a derived counter or group member is selected. In effect, the table acts as a rule repository: each row describes one Boolean condition (for example, a property, a relational operator, and a comparison value) that is combined with others through logical and parenthetical operators to form a complete filter expression.

From a Data Vault modeling perspective, the table is heuristically classified as a link. This classification is derived from its foreign key structure, which references two parent entities — CS_COUNTERS and CS_COUNTER_PROPERTIES — rather than representing a standalone business entity. The recommendation is to treat CS_COUNTER_DER_FILTERS as an associative table connecting a counter to the counter properties used in its filter definition.

Key Information Stored

The table contains 34 documented columns. The most significant include:

• COUNTER_DER_FILTER_ID — the surrogate primary key defined by CS_COUNTER_DER_FILTERS_PK, and also the business-key candidate via unique index CS_COUNTER_DER_FILTERS_U1.
• COUNTER_ID — foreign key to CS_COUNTERS identifying the counter to which the filter belongs.
• COUNTER_PROPERTY_ID — foreign key to CS_COUNTER_PROPERTIES identifying the property being tested.
• RELATIONAL_OPERATOR — the comparison operator (for example, equals, greater than, less than) applied to the property.
• RIGHT_VALUE — the comparison value against which the property is evaluated.
• LOGICAL_OPERATOR — the connector (AND/OR) joining this condition to others in the expression.
• LEFT_PAREN and RIGHT_PAREN — punctuation flags that control evaluation grouping.
• SEQ_NO — the ordering of the condition within the filter expression.
• START_DATE_ACTIVE and END_DATE_ACTIVE — effective dating for the condition's validity.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting multi-org/security-group access control.
• OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, and CREATED_BY — standard concurrency and audit columns.
• ATTRIBUTE1–ATTRIBUTE15 and CONTEXT — the standard Oracle EBS descriptive flexfield (DFF) columns.

Common Use Cases and Queries

Typical use cases include reporting on the filter rules configured for a counter, validating that derived group logic is correctly structured, and diagnosing why a counter member is or is not selected by a group operation. A common query pattern retrieves all conditions for a given counter, ordered by their sequence:

• SELECT filter_id, counter_property_id, relational_operator, right_value, logical_operator FROM cs_counter_der_filters WHERE counter_id = :p_counter_id ORDER BY seq_no;
• Joining to CS_COUNTER_PROPERTIES to resolve human-readable property names alongside their operators and values.
• Filtering on START_DATE_ACTIVE and END_DATE_ACTIVE to report only currently effective conditions.
• Constraining by SECURITY_GROUP_ID when reporting across multiple operating units or security groups.

Related Objects

• CS_COUNTERS — joined on CS_COUNTER_DER_FILTERS.COUNTER_ID = CS_COUNTERS.COUNTER_ID.
• CS_COUNTER_PROPERTIES — joined on CS_COUNTER_DER_FILTERS.COUNTER_PROPERTY_ID = CS_COUNTER_PROPERTIES.COUNTER_PROPERTY_ID.
• FND_SECURITY_GROUPS — joined on CS_COUNTER_DER_FILTERS.SECURITY_GROUP_ID for row-level access control.
• CS_COUNTER_DER_FILTERS_PK and CS_COUNTER_DER_FILTERS_U1 — primary-key constraint and unique index enforcing filter identity.

The table's central dependencies are the counter and counter-property entities; joins to those two parents resolve the majority of business reporting needs.