Search Results okc_line_style_roles_pk

Overview

The OKC_LINE_STYLE_ROLES table is a foundational data object within the Oracle E-Business Suite (EBS) Contracts Core module (OKC). It functions as a control table that defines the permissible party roles for contract lines based on their line style. In essence, it establishes a many-to-many relationship between line styles (defined in OKC_LINE_STYLES_B) and predefined party roles (defined in OKC_SUBCLASS_ROLES). This table enforces business rules by governing which roles, such as "Buyer," "Supplier," or "Bill-To Contact," can be assigned to the parties involved in a specific type of contract line, ensuring data integrity and consistent process execution across the contracting lifecycle.

Key Information Stored

The table's structure is concise, serving primarily as a junction table. Its critical columns are defined by its primary and foreign keys. The LSE_ID column stores the unique identifier for a contract line style, linking directly to OKC_LINE_STYLES_B. The SRE_ID column stores the unique identifier for a valid party role, linking directly to OKC_SUBCLASS_ROLES. The combination of these two columns forms the table's primary key (OKC_LINE_STYLE_ROLES_PK), ensuring that any given role can be associated with a specific line style only once. This design centrally manages the authorization of party roles at the line style level.

Common Use Cases and Queries

The primary use case is the validation and presentation of available party roles during the contract line entry process in the Oracle EBS user interface. When a user creates a contract line and selects a line style, the application queries this table to determine the list of valid roles for assigning parties to that line. For reporting and administrative purposes, common queries involve joining to related tables to produce meaningful lists. A typical SQL pattern to retrieve all authorized roles for a given line style name would be:

• SELECT lsb.NAME AS line_style, sr.ROLE_CODE, sr.NAME
  FROM okc_line_style_roles lsr,
  okc_line_styles_b lsb,
  okc_subclass_roles sr
  WHERE lsr.lse_id = lsb.id
  AND lsr.sre_id = sr.id
  AND lsb.NAME = '<Line Style Name>';

Conversely, administrators might query to find all line styles where a specific role like 'BUYER' is permitted, which is essential for configuring or auditing contract templates.

Related Objects

OKC_LINE_STYLE_ROLES is centrally connected to two key master tables via foreign key constraints, forming the core of its functionality.

• OKC_LINE_STYLES_B: This table defines all available contract line styles (e.g., "Goods," "Services," "Warranty"). The relationship is established through the foreign key where OKC_LINE_STYLE_ROLES.LSE_ID references OKC_LINE_STYLES_B.
• OKC_SUBCLASS_ROLES: This table is the repository for all system-defined and custom party roles applicable within the Contracts module. The relationship is established through the foreign key where OKC_LINE_STYLE_ROLES.SRE_ID references OKC_SUBCLASS_ROLES.

This table is also referenced by various application programming interfaces (APIs) and user interface forms within the Contracts Core module that handle party assignment on contract lines.