Search Results fixed asset table




The OKL.OKL_TXL_ASSETS_B table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical component of the Oracle Lease and Finance Management (OKL) module. It serves as the base table for storing transactional asset information, which is essential for lease accounting, asset tracking, and financial reporting. This table is part of the Oracle Lease Management subledger and integrates with other modules like Oracle Assets, General Ledger, and Payables to ensure accurate financial processing and compliance with accounting standards such as ASC 842 and IFRS 16.

Table Structure and Key Columns

The OKL_TXL_ASSETS_B table contains columns that capture detailed asset information, including:
  • ID: Primary key identifier for the asset record.
  • KHR_ID: Foreign key linking to the lease header (OKL_K_HEADERS_B).
  • ASSET_NUMBER: Unique identifier for the leased asset.
  • DESCRIPTION: Textual description of the asset.
  • ASSET_CATEGORY_ID: Classification of the asset (e.g., equipment, vehicle).
  • MANUFACTURER: Name of the asset manufacturer.
  • MODEL_NUMBER: Specific model identifier.
  • SERIAL_NUMBER: Unique serial number for tracking.
  • QUANTITY: Number of units leased.
  • UNIT_OF_MEASURE: Measurement unit (e.g., each, pounds).
  • CAPITALIZED_FLAG: Indicates if the asset is capitalized for accounting purposes.
  • DATE_PLACED_IN_SERVICE: When the asset became operational.
  • DATE_REMOVED_FROM_SERVICE: When the asset was retired or returned.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE: Standard Oracle audit columns.

Functional Role in Lease Management

This table supports core lease management processes:
  1. Lease Origination: Captures asset details during lease contract creation.
  2. Asset Tracking: Maintains a record of leased assets throughout their lifecycle.
  3. Financial Integration: Links to Oracle Assets for depreciation calculations and General Ledger for journal entries.
  4. Compliance Reporting: Provides data for lease accounting standards (e.g., right-of-use asset calculations).

Integration Points

OKL_TXL_ASSETS_B interacts with:
  • OKL_K_HEADERS_B: Parent lease agreement details.
  • FA_ADDITIONS_B: Oracle Assets table for fixed asset registration.
  • GL_JE_LINES: General Ledger entries for lease accounting.
  • AP_INVOICE_LINES: Vendor invoices associated with leased assets.

Technical Considerations

  • Indexes: Commonly indexed on ID, KHR_ID, and ASSET_NUMBER for performance.
  • Partitioning: May be partitioned by DATE_PLACED_IN_SERVICE in large implementations.
  • APIs: Accessed via Oracle's PL/SQL APIs (e.g., OKL_TXL_ASSETS_PUB) for data integrity.

Customization and Extensions

Organizations often extend this table with custom columns (via OKL_TXL_ASSETS_B_EXT) to capture industry-specific attributes. Triggers or workflows may be added to enforce business rules during asset updates.

Conclusion

The OKL.OKL_TXL_ASSETS_B table is a foundational element in Oracle Lease Management, enabling accurate asset tracking, financial processing, and regulatory compliance. Its design reflects Oracle's commitment to supporting complex leasing scenarios while maintaining integration with broader EBS financial ecosystems. Proper understanding of this table is essential for implementing, customizing, or reporting on Oracle Lease Management solutions.