Results for “activate_asset”

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

Overview

OKL_ACTIVATE_ASSET_PUB is a public PL/SQL package in the Oracle E-Business Suite (EBS) Oracle Lease and Finance Management (OKL) module — part of the ETRM (Enterprise Transaction and Resource Management) family of APIs. In EBS 12.1.1 and 12.2.2, this package serves as the primary programmatic interface for activating, rebooking, and releasing leased assets against a contract that has passed approval and is ready to be booked. Its central business function is to select and process the "CFA" (Create Fixed Asset) transaction from a ready-to-be-booked contract, generating the corresponding asset records in Oracle Assets (FA).

The package header (OKLPACAB.pls) carries a header comment block documenting the ACTIVATE_ASSET procedure, its history (created 03-Nov-2001 by avsingh), and its role in the lease booking workflow. It is classified as an API ("PUB") package, meaning it is designed for supported external invocation by other EBS components and custom code.

Key Procedures and Functions

• ACTIVATE_ASSET — The core procedure. It processes asset activation for a contract identified by the p_chr_id (contract ID) parameter, with a p_call_mode parameter supporting three modes: 'BOOK' for booking, 'REBOOK' for rebooking, and 'RELEASE' for release. Output parameters include x_return_status, x_msg_count, and x_msg_data for standard API status and message handling, plus x_cimv_tbl, an OKC line source table type identifying FA links in the ID1/ID2 columns.
• REBOOK_ASSET — Supports the rebooking scenario, re-establishing asset links when a booked contract is rebooked.
• RELEASE_ASSET — Supports the release scenario, handling asset release processing when a contract releases previously recognized assets. Users searching for "release_asset" are directed to this procedure, which corresponds to the 'RELEASE' call mode of ACTIVATE_ASSET.

The procedures follow Oracle EBS API conventions, invoking OKL_API.START_ACTIVITY for savepoint creation, compatibility checking, and message-list initialization, and raising standard exceptions (G_EXCEPTION_ERROR, G_EXCEPTION_UNEXPECTED_ERROR) based on return status.

Tables Accessed

The documented metadata identifies references via APPS synonyms but does not enumerate specific table names. Based on the package's function, it reads and writes the OKL contract header and line tables (such as OKC/OKL contract structures), the OKC line source table used to populate the x_cimv_tbl output, and FA asset interface tables that receive the generated asset records. The reference to "fa links in ID1, ID2 columns" indicates the package interacts with FA link structures to associate created assets with their originating contract lines.

Usage Notes

OKL_ACTIVATE_ASSET_PUB is typically invoked during the lease booking lifecycle rather than directly by end users. Common invocation points include:

• Booking and rebooking flows — when a contract that has passed approval is booked or rebooked, triggering asset creation in Oracle Assets via the 'BOOK' or 'REBOOK' call modes.
• Release processing — via RELEASE_ASSET or the 'RELEASE' call mode, to release assets from a contract.
• Custom code and integrations — the package is referenced by two other documented packages, indicating it is called programmatically rather than only from a form.

Because it is a PUB-classified API, callers should follow standard EBS API patterns: initialize the message list, check x_return_status, and process x_msg_count/x_msg_data for diagnostics. The package header version (115.5, dated 2004/04/13) reflects a long-standing, stable interface carried forward across 12.1.1 and 12.2.2.