Search Results oks_qualifiers_n1

Overview

The OKS.OKS_QUALIFIERS table is a core transactional object within the Oracle Service Contracts (OKS) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores pricing qualifier information used during service authoring, capturing the conditions that determine whether a given discount, surcharge, or price adjustment should apply. Rather than computing prices itself, OKS_QUALIFIERS passes qualifier definitions to Oracle Pricing (QP), which evaluates them against the pricing engine's rules to arrive at the correct charge.

Rows in this table are created and maintained through the Pricing Qualifier user interface, invoked from the lines region of the Oracle Service Contracts Authoring UI. Qualifiers may be grouped together with AND/OR relationships and constrained by attribute, operator, value, and effective dates, allowing complex pricing conditions to be authored without custom code.

Under a heuristic Data Vault model, OKS_QUALIFIERS is best classified as a satellite. It is described in the metadata as standalone (no parent hub foreign key beyond its rule, list, and security references), and its rows represent descriptive, time-bounded attributes of qualifier rules rather than durable business entities in their own right. This classification is a modeling suggestion only; the table is a conventional EBS transactional table with standard WHO columns and concurrent-program audit columns.

Key Information Stored

The surrogate primary key is QUALIFIER_ID, a system-generated internal unique identifier. The unique index OKS_QUALIFIERS_U1 is defined on this single column and is the only documented unique index, making it the sole business-key candidate. All other access paths, such as OKS_QUALIFIERS_N1 on LIST_LINE_ID, are non-unique.

• QUALIFIER_RULE_ID — foreign key to the qualifier rule that owns this qualifier row.
• LIST_LINE_ID — foreign key to the pricing list line to which the qualifier applies.
• LIST_HEADER_ID and LIST_TYPE_CODE — identify the pricing list header and list type context.
• QUALIFIER_CONTEXT, QUALIFIER_ATTRIBUTE, QUALIFIER_ATTR_VALUE — the descriptive flexfield context, attribute name, and comparison value.
• QUALIFIER_ATTR_VALUE_TO and QUAL_ATTR_VALUE_FROM_NUMBER / QUAL_ATTR_VALUE_TO_NUMBER — support range qualifiers, particularly for BETWEEN comparisons.
• COMPARISON_OPERATOR_CODE — the relational operator (based on the COMPARISON_OPERATOR lookup) the pricing engine uses to evaluate the attribute.
• QUALIFIER_GROUPING_NO — groups qualifiers to form AND/OR combinations.
• QUALIFIER_PRECEDENCE — controls evaluation order among competing qualifiers.
• START_DATE_ACTIVE / END_DATE_ACTIVE — effective dating for the qualifier.
• ACTIVE_FLAG — current enablement status; EXCLUDER_FLAG is retained but no longer used.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS for multi-org security.
• Concurrent-program audit columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) plus the standard CREATED_BY / LAST_UPDATED_BY WHO columns.

Common Use Cases and Queries

Typical uses include auditing qualifier definitions attached to a service contract line, tracing which pricing list lines carry effective qualifiers, and reconciling qualifier data passed to Oracle Pricing. A common query joins qualifiers to list lines filtered by effective dates:

• Retrieve all active qualifiers for a list line: SELECT QUALIFIER_ID, QUALIFIER_ATTRIBUTE, QUALIFIER_ATTR_VALUE, COMPARISON_OPERATOR_CODE FROM OKS.OKS_QUALIFIERS WHERE LIST_LINE_ID = :p_line_id AND ACTIVE_FLAG = 'Y' AND SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE);
• Group qualifiers by their logical grouping: ... ORDER BY QUALIFIER_RULE_ID, QUALIFIER_GROUPING_NO, QUALIFIER_PRECEDENCE;
• Identify range qualifiers: ... WHERE COMPARISON_OPERATOR_CODE = 'BETWEEN';

Reporting is frequently performed against the range and effective-date columns to identify expired or overlapping qualifiers, and against the concurrent-program columns to trace batch-loaded qualifier sets.

Related Objects

• QP_QUALIFIER_RULES — referenced via OKS_QUALIFIERS.QUALIFIER_RULE_ID; the parent rule definition.
• QP_LIST_LINES — referenced via LIST_LINE_ID; the pricing list line the qualifier qualifies.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for security group scoping.
• OKS_QUALIFIERS_U1 — the unique index on QUALIFIER_ID, serving as the primary access path.
• OKS_QUALIFIERS_N1 — non-unique index on LIST_LINE_ID, supporting list-line lookups.
• Oracle Pricing (QP) engine — consumes qualifier rows to evaluate discounts and surcharges during service authoring.

Together these objects form the qualifier-to-pricing path that underlies service contract price adjustment.