Results for “expire_after_days”

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

Overview

OKL_SUBSIDIES_ALL_B is the base (language-independent) table of the Oracle Lease and Finance Management (OKL) subsidy setup model in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the definition of each subsidy that the enterprise may extend against lease and finance contracts — that is, the terms under which a vendor or funding party absorbs a portion of the financing cost or refund obligation associated with a lease. Because subsidy definitions are configured at implementation time and then consumed repeatedly during contracting, the object behaves as a reference or setup entity rather than a transactional record.

The table is owned by the OKL schema and is documented as VALID in the ETRM 12.2.2 repository, with 49 columns and primary key constraint OKL_SUBSIDIES_ALL_B_PK on ID. The heuristic Data Vault classification mined from the foreign-key structure is satellite-leaning. In modeling terms, this is best read as a descriptive satellite-like reference entity: it hangs off shared OKL configuration structures (formulae and stream types) by way of its outbound foreign keys, while carrying its own descriptive attributes. As is standard for OKL setup objects, the language-dependent text is externalized to OKL_SUBSIDIES_TL, leaving OKL_SUBSIDIES_ALL_B as the master row holding numeric, coded, and flag attributes.

Key Information Stored

The surrogate primary key is ID, which uniquely identifies each subsidy setup and is the join column used by every dependent table. Two unique indexes are documented: OKL_SUBSIDIES_ALL_B_U1 on ID, and OKL_SUBSIDIES_ALL_B_U2 on (NAME, ORG_ID). The composite unique index on NAME and ORG_ID is the effective business key, scoping subsidy names to a single operating unit. ORG_ID also appears as a multi-organization (MOAC) discriminator.

The most consequential documented columns fall into four groups:

• Eligibility and validity: EFFECTIVE_FROM_DATE and EFFECTIVE_TO_DATE bound the active window of each setup, while EXPIRE_AFTER_DAYS controls lapse behavior for contracts that qualify against it.
• Computation: SUBSIDY_CALC_BASIS selects the calculation method; AMOUNT, PERCENT, RATE_POINTS, and FORMULA_ID (pointing to OKL_FORMULAE_B) supply the actual rates or expressions. MAXIMUM_TERM, MAXIMUM_FINANCED_AMOUNT, and MAXIMUM_SUBSIDY_AMOUNT cap a contract's eligibility.
• Accounting and refund: ACCOUNTING_METHOD_CODE, RECOURSE_YN, TERMINATION_REFUND_BASIS, REFUND_FORMULA_ID, TRANSFER_BASIS_CODE, and SUBSIDY_POOL_ID drive how the subsidy is posted, whether it is recourse-based, and how it is refunded on early termination. CURRENCY_CODE fixes the denomination.
• Behavioral flags and context: EXCLUSIVE_YN (cannot combine with other subsidies), APPLICABLE_TO_RELEASE_YN, RECEIPT_METHOD_CODE, CUSTOMER_VISIBLE_YN, VENDOR_ID, and STREAM_TYPE_ID (pointing to OKL_STRM_TYPE_B), together with the standard ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 flexfield columns, plus the audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER.

Common Use Cases and Queries

Consultants typically query this table to audit subsidy configurations, trace which subsidies a contract line received, or verify that a vendor-funded program is still effective. A representative lookup of active subsidies for an operating unit reads:

• SELECT s.id, t.subsidy_name, s.currency_code, s.subsidy_calc_basis, s.amount, s.percent FROM okl_subsidies_all_b s JOIN okl_subsidies_tl t ON t.id = s.id AND t.language = USERENV('LANG') WHERE s.org_id = :p_org AND SYSDATE BETWEEN NVL(s.effective_from_date, SYSDATE) AND NVL(s.effective_to_date, SYSDATE);
• Reverse traceability from a contract: join OKL_K_LINES.SUBSIDY_ID back to OKL_SUBSIDIES_ALL_B.ID to list subsidies applied to a lease line.
• Criteria-driven reporting: join OKL_SUBSIDY_CRITERIA on SUBSIDY_ID to determine which customer, product, or vendor conditions must be met for a setup to apply.
• Formula dependency analysis: join FORMULA_ID and REFUND_FORMULA_ID to OKL_FORMULAE_B to identify subsidies affected when a shared formula is modified.

Related Objects

Five significant dependencies dominate:

• OKL_SUBSIDIES_TL — the translated (language-dependent) sibling; join on OKL_SUBSIDIES_TL.ID = OKL_SUBSIDIES_ALL_B.ID to obtain the subsidy name and description.
• OKL_SUBSIDY_CRITERIA — eligibility rules; join on OKL_SUBSIDY_CRITERIA.SUBSIDY_ID = OKL_SUBSIDIES_ALL_B.ID.
• OKL_K_LINES — contract lines that received a subsidy; join on OKL_K_LINES.SUBSIDY_ID = OKL_SUBSIDIES_ALL_B.ID for utilization and audit reporting.
• OKL_FORMULAE_B — referenced twice, via FORMULA_ID and REFUND_FORMULA_ID, for subsidy and refund computation logic.
• OKL_STRM_TYPE_B — referenced via STREAM_TYPE_ID, controlling the stream the subsidy is associated with.

No public API is documented for direct manipulation of this table; subsidy setups are maintained through the OKL Lease Management setup forms, which perform the necessary inserts into both the base and TL tables and validate against the unique NAME/ORG_ID key.