Results for “tax_upfront_sty_id”

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

Overview

OKL_SYSTEM_PARAMS_ALL is the central configuration table within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It stores the parameters that govern how the leasing and finance application behaves across an operating unit, covering lease origination, tax handling, invoice generation, asset depreciation, remittance processing, and quoting workflows. Because the table is suffixed _ALL, it is designed to hold one or more rows per operating unit, keyed by ORG_ID, allowing different business units to operate under distinct parameter sets. The object is owned by the OKL schema and is marked VALID in ETRM 12.2.2 documentation, with 63 documented columns.

From a Data Vault modeling perspective, the heuristic classification of OKL_SYSTEM_PARAMS_ALL is satellite-leaning. It carries descriptive attributes and foreign-key references to other entities, and its two unique indexes (OKL_SYSTEM_PARAMS_ALL_U1 on ORG_ID and OKL_SYSTEM_PARAMS_ALL_U2 on ID) suggest a business-key candidate on ORG_ID supported by a surrogate primary key. Analysts modeling this object in a Data Vault context should therefore treat it as a satellite attached to an operating-unit hub rather than as a hub or link.

Key Information Stored

The most significant attributes relate to operational and financial defaults. The primary key is ID, enforced by OKL_SYS_PARAMS_PK. Two unique indexes exist: OKL_SYSTEM_PARAMS_ALL_U1 on ORG_ID acts as the primary business-key candidate, and OKL_SYSTEM_PARAMS_ALL_U2 on ID is effectively the surrogate key uniqueness constraint.

• ORG_ID — Operating unit identifier; the business-key candidate governing scope of the parameter row.
• TAX_UPFRONT_YN, TAX_INVOICE_YN, TAX_SCHEDULE_YN — Tax timing and invoicing behavior flags.
• TAX_UPFRONT_STY_ID — Foreign key to OKL_STRM_TYPE_B, defining the stream type used for upfront tax.
• CANCEL_QUOTES_YN — Controls whether quotes can be cancelled.
• VALIDATION_SET_ID — Reference to the validation set used for lease processing.
• REMK_ORGANIZATION_ID, REMK_SUBINVENTORY, REMK_PRICE_LIST_ID — Defaults for the remarketing (used-asset) flow.
• ITEM_INV_ORG_ID — Item validation organization for inventory-associated transactions.
• LEASE_INV_ORG_YN — Flag governing lease invoicing organization usage.
• DEPRECIATE_YN, CORPORATE_BOOK, TAX_BOOK_1, TAX_BOOK_2 — Asset depreciation and corporate/tax book assignments.
• FA_LOCATION_ID — Default Fixed Assets location.
• FORMULA_ID, ASSET_KEY_ID — References to pricing/valuation formulas and asset key definitions.
• TASK_TEMPLATE_GROUP_ID — Foreign key to JTF_TASK_TEMP_GROUPS_B for default task templates.
• LSEAPP_SEQ_PREFIX_TXT, LSEOPP_SEQ_PREFIX_TXT, LSEQTE_SEQ_PREFIX_TXT, QCKQTE_SEQ_PREFIX_TXT — Prefix strings for lease application, opportunity, quote, and quick quote document sequences.

Standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER) and the DFF attribute columns (ATTRIBUTE_CATEGORY, ATTRIBUTE1–15) are also present.

Common Use Cases and Queries

The most frequent use is retrieving a single operating unit's configuration to drive downstream logic or reporting. A typical query is:

• SELECT * FROM OKL.OKL_SYSTEM_PARAMS_ALL WHERE org_id = :p_org_id;
• Reporting on tax behavior: SELECT org_id, tax_upfront_yn, tax_invoice_yn, tax_schedule_yn FROM okl_system_params_all;
• Joining to the stream type master to resolve the upfront tax stream: SELECT p.org_id, s.stream_type_code FROM okl_system_params_all p, okl_strm_type_b s WHERE p.tax_upfront_sty_id = s.id;
• Resolving task templates: SELECT p.org_id, t.group_name FROM okl_system_params_all p, jtf_task_temp_groups_b t WHERE p.task_template_group_id = t.group_id;
• Auditing changes: SELECT org_id, last_updated_by, last_update_date FROM okl_system_params_all ORDER BY last_update_date DESC;

Related Objects

The following objects are the most significant dependencies based on the documented FK relationships and the broader OKL model.

• OKL_STRM_TYPE_B — joined via OKL_SYSTEM_PARAMS_ALL.TAX_UPFRONT_STY_ID = OKL_STRM_TYPE_B.ID.
• JTF_TASK_TEMP_GROUPS_B — joined via OKL_SYSTEM_PARAMS_ALL.TASK_TEMPLATE_GROUP_ID = JTF_TASK_TEMP_GROUPS_B.GROUP_ID.
• OKL_STRM_TYPE_TL — translation table resolving stream type descriptions.
• OKL_SYSTEM_PARAMS_VL / OKL_SYSTEM_PARAMS_V — views exposing the parameter row for the current session organization.
• OKL_QUOTE_HEADERS_ALL and OKL_LEASE_HEADERS_ALL — transactional tables whose processing logic reads system parameters at creation and validation time.
• OKL_VALIDATION_SETS_B — referenced through VALIDATION_SET_ID.
• OKL_FM_FORMULAS_B — referenced through FORMULA_ID.
• FA_LOCATIONS — referenced through FA_LOCATION_ID for asset location defaults.

Together these relationships confirm OKL_SYSTEM_PARAMS_ALL as the configuration backbone for leasing and finance transactions, providing the defaults, tax rules, and sequence-prefix definitions consumed by virtually every OKL business process.