Search Results okl_sys_params_pk

Overview

The OKL_SYSTEM_PARAMS_ALL table is a core configuration repository within Oracle E-Business Suite's Leasing and Finance Management (OKL) module. It functions as a centralized system parameter table designed to store and manage the operational and financial settings that govern the behavior of the leasing application. Its role is critical for establishing default values, controlling processing logic, and enabling system-wide customization without code modification. As an "ALL" table, it is partitioned by the operating unit (ORG_ID), allowing for the definition of unique parameter sets for different business units or legal entities within a single installation, supporting multi-organization structures.

Key Information Stored

The table stores key-value pairs of system parameters. While the full column list is not detailed in the provided metadata, the structure typically includes an identifier, parameter name, value, and context columns. The documented foreign key relationship explicitly reveals one significant parameter: TAX_UPFRONT_STY_ID. This column holds a foreign key (ID) to the OKL_STRM_TYPE_B table, which defines stream types. This specific parameter configures the system's default stream type for upfront tax calculations within lease contracts. Other common parameters stored in such a table could include interest calculation methods, rounding rules, default GL accounts, date conventions, and feature enablement flags. The primary key, OKL_SYS_PARAMS_PK on the ID column, ensures each parameter record is uniquely identifiable.

Common Use Cases and Queries

This table is primarily accessed for configuration validation, troubleshooting, and reporting on system settings. Application logic and concurrent programs will query this table to determine runtime behavior. Common scenarios include verifying the tax stream type setup or auditing parameter values across organizations. A typical query pattern involves filtering by parameter name and organization.

• Retrieving a Specific Parameter: SELECT parameter_name, parameter_value FROM okl_system_params_all WHERE parameter_name = 'PARAM_NAME' AND org_id = :org_id;
• Auditing Parameters by Operating Unit: SELECT org_id, parameter_name, parameter_value FROM okl_system_params_all ORDER BY org_id, parameter_name;
• Joining for Descriptive Information: The documented foreign key enables queries to fetch the descriptive name of the tax upfront stream type: SELECT p.parameter_value, s.name FROM okl_system_params_all p, okl_strm_type_b s WHERE p.tax_upfront_sty_id = s.id AND p.parameter_name = 'TAX_UPFRONT_STY_ID';

Related Objects

The primary documented relationship for OKL_SYSTEM_PARAMS_ALL is with the OKL_STRM_TYPE_B table via the TAX_UPFRONT_STY_ID foreign key column. This links the parameter to the specific lease stream type definition used for tax calculations. As a fundamental setup table, it is referenced by numerous application programming interfaces (APIs), concurrent programs, and forms within the OKL module that require system defaults. While not listed, dependent views such as OKL_SYSTEM_PARAMS (a single-organization view filtered by MOAC security) likely exist to provide a secure access layer. Changes to parameters in this table can have a cascading effect on lease pricing, invoicing, and accounting processes.