Results for “okl_activate_asset_pvt”

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

Overview

OKL_ACTIVATE_ASSET_PVT is a private PL/SQL package in the APPS schema that supports the asset lifecycle of Oracle Lease and Finance Management (OKL), part of the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 stack. The package addresses the accounting and fixed asset integration aspects of leased assets, specifically the creation, activation, rebooking, and release of assets associated with lease contracts managed in OKL. In OKL terminology an asset is the physical or financial item governed by a lease; its activation is the point at which it becomes eligible for depreciation, cost tracking, and transaction accounting.

The package is classified as a private (PVT) API. It is not intended for direct external invocation; it is consumed by public APIs and by other private packages that drive contract activation, asset subsidy processing, line item processing, stream generation, and trade-in handling. Functionally it bridges OKL lease data and Oracle Assets (FA) data, ensuring that activated leased assets are represented correctly in the corporate book, with depreciation methods, calendars, and cost bases derived from the applicable fixed asset setup.

Key Procedures and Functions

The documented package exposes six procedures and functions:

• ACTIVATE_ASSET — The primary routine. It activates a leased asset, establishing its accounting presence in Oracle Assets and making it eligible for depreciation and downstream financial processing.
• REBOOK_ASSET — Rebooks an individual asset, typically when asset accounting attributes such as book, category, or cost must be corrected or reassigned after activation.
• MASS_REBOOK_ASSET — Performs the rebooking operation for multiple assets in a single invocation, supporting bulk corrections and period-end adjustments.
• RELEASE_ASSET — Releases an asset from the lease, removing its active accounting association and reversing the effects established during activation.
• GET_PRICING_PARAMETERS — Retrieves pricing-related parameters used to determine asset cost and valuation inputs during activation and rebooking.
• RECALCULATE_ASSET_COST — Recomputes the cost basis of an asset, ensuring that subsequent depreciation and accounting entries reflect updated amounts.

Names and purposes are as documented in the ETRM metadata; parameter signatures are not published in the reference material and should be obtained from the package specification in the database.

Tables Accessed

The package reads and writes fixed asset and lease contract data through APPS synonyms:

• FA_ADDITIONS, FA_BOOKS, FA_BOOK_CONTROLS, FA_METHODS — Oracle Assets core tables. FA_ADDITIONS holds the asset definition; FA_BOOKS stores the asset in each depreciation book; FA_BOOK_CONTROLS defines book rules; FA_METHODS provides depreciation methods.
• FA_CALENDAR_PERIODS, FA_DEPRN_PERIODS — Depreciation calendars and open/closed period status, used to validate that activation and rebooking fall in permissible periods.
• FA_CATEGORY_BOOK_DEFAULTS, FA_FLAT_RATES, FA_DISTRIBUTION_HISTORY — Category-level defaults, flat-rate depreciation data, and historical cost distribution records used in cost allocation and recalculation.
• MTL_SYSTEM_ITEMS — Inventory item master, linking the leased asset to its item definition for descriptive and cost attributes.
• OKC_K_HEADERS_B, OKC_K_ITEMS, OKC_K_LINES_B, OKC_K_LINES_TL, OKC_LINE_STYLES_B — Contract core tables from Oracle Contracts (OKC) that hold the lease header, contract line items, and line style definitions that determine asset behavior.

The package also references views including OKL_K_HEADERS_FULL_V, OKL_PRODUCTS_V, OKX_AST_BKS_V, and OKX_AST_CT_BK_DFS_V, and depends on packages such as OKC_API, OKL_API, OKL_ASD_PVT, OKL_TAL_PVT, OKL_TXD_ASSETS_PUB, and OKL_TXL_ASSETS_PUB.

Usage Notes

Because OKL_ACTIVATE_ASSET_PVT is a private package, it is not exposed through a standard form or concurrent program. It is invoked indirectly: the public package OKL_ACTIVATE_ASSET_PUB, the contract activation flow (OKL_ACTIVATE_CONTRACT_PUB), asset subsidy (OKL_ASSET_SUBSIDY_PVT), contract line item (OKL_CONTRACT_LINE_ITEM_PVT), KLE creation (OKL_CREATE_KLE_PVT), lease accounting stream (OKL_LA_STREAM_PVT), and trade-in (OKL_LA_TRADEIN_PVT) all call into this package. This dependency chain means asset activation, rebooking, and release occur as part of broader contract lifecycle events such as lease commencement, asset assignment, and termination.

Customers extending OKL should call the public wrapper APIs rather than this package directly, since the internal signatures may change across patches and point releases. The package is relevant to 12.1.1 and 12.2.2; the 12.2.x online patching model does not alter the package's role, but the status VALID confirms it compiles cleanly in the documented environment.