Search Results okc_function_expr_params




Overview
Explore in AI Chat

Overview

The OKC_FUNCTION_EXPR_PARAMS table is a core technical table within the Oracle E-Business Suite Contracts Core (OKC) module. It serves as a repository for the specific parameter values required to execute a function defined within a contract condition line. In the context of Oracle Contracts, condition lines can utilize functions to dynamically evaluate complex business rules or calculations. This table stores the concrete data inputs—the parameters—that are supplied to these functions at runtime, enabling the conditional logic defined in a contract to be processed accurately. Its existence is critical for the functional integrity of the contract's automated clauses and actions.

Key Information Stored

The table's primary function is to link parameter values to their respective parent objects. Its structure is defined by key foreign key relationships. The central column is ID, which serves as the primary key. The table's purpose is primarily relational, connecting to three major parent entities via foreign keys: CNL_ID links directly to a condition line in OKC_CONDITION_LINES_B, AAE_ID links to an action attribute in OKC_ACTION_ATTRIBUTES_B, and PDP_ID links to a process definition parameter in OKC_PROCESS_DEF_PARMS_B. While the specific parameter value columns are not detailed in the provided metadata, the table would typically contain columns to store the parameter sequence, data type, and the actual value (e.g., VARCHAR2, NUMBER, DATE) to be passed to the function referenced in the condition line.

Common Use Cases and Queries

This table is primarily accessed by the application's internal engine during the evaluation of contract conditions and the execution of associated workflows or actions. Common operational scenarios include the validation of a contract clause during authoring or the automated triggering of an action when a condition is met. Direct queries are typically for support or diagnostic purposes. A sample query to retrieve all function parameters for a specific condition line would be:

  • SELECT fep.* FROM okc_function_expr_params fep WHERE fep.cnl_id = <condition_line_id>;

Another common reporting use case involves tracing the configuration of automated contract processes by joining to the parent condition lines and related function definitions to audit the parameters being used in business rules.

Related Objects

OKC_FUNCTION_EXPR_PARAMS is a child table with dependencies on several core Contracts tables, as defined by its foreign keys. The primary related objects are:

  • OKC_CONDITION_LINES_B: The central condition definition table. Each record in OKC_FUNCTION_EXPR_PARAMS with a populated CNL_ID is providing parameters for a function within a specific condition line.
  • OKC_ACTION_ATTRIBUTES_B: Links parameters to specific attributes of an automated action that may be triggered by a condition.
  • OKC_PROCESS_DEF_PARMS_B: Links parameters to a process definition parameter, tying into broader contract process workflows.
  • The table OKC_FUNCTION_EXPR_PARAMS_PK on the ID column enforces data integrity for these relationships.