Search Results fixed_asset




Overview
Explore in AI Chat

Overview

APPS.OKL_BPD_RECEIPT_ASSET_UV is a consolidated reporting view within the Oracle E-Business Suite (EBS) Enterprise Contracts / Lease Management (OKL) module, historically aligned with the former Enterprise Territory and Resource Management (ETRM) product family. The suffix "UV" denotes a user view intended primarily for reporting and integration consumption rather than transactional data entry. Its purpose is to reconcile cash receipt applications flowing through lease and contract streams against the fixed assets they finance or reference.

The view answers a specific business question: for a given receipt or consolidated cash application, which fixed asset in Oracle Assets (FA) is associated with it, and what amount was applied. This linkage is critical where leases fund capital acquisitions and the receipt application must be traceable to an asset record. In the context of the EBS 12.1.1 and 12.2.2 releases, this view operates against the same OKL/OKC/FA schema with the 12.2.2 Online Patching (Editioning) editioning views abstracting the underlying base tables.

Because the view joins subledger cash streams to asset additions and contract line styles, it serves both reconciliation reporting and downstream data extraction into asset-aware analytics.

Underlying Base Objects

The view is defined over a mix of views, synonyms, and package references documented in the ETRM 12.2.2 metadata:

The definition is a UNION ALL of three branches: asset-matched streams, orphan streams with no fixed-asset line style, and partial matches, ensuring no receipt amounts are silently dropped.

Key Columns

  • EXT_ID — external identifier from XCR_ID_DETAILS, correlating to the cash receipt detail.
  • ASSET_ID / ASSET_NUMBER / ASSET_NAME — asset identifiers; ASSET_NUMBER carries the FA serial number and ASSET_NAME the FA asset number. Values are NULL in the unmatched branch.
  • ASSET_DESCRIPTION — descriptive text from FA_ADDITIONS_V.
  • AMOUNT_APPLIED — summed application amount formatted as a character string ('99,999,999,999.99') via TO_CHAR.
  • ASSET_STATUS — STS_CODE from the contract line, indicating line status.
  • STREAM_NAME — the stream type name.
  • MEANING — decoded lookup meaning for the stream type purpose.

Common Use Cases and Queries

Typical scenarios include asset-versus-receipt reconciliation, feeding asset-aware revenue schedules, and auditing receipts that reference fixed assets without a matching contract line.

SELECT asset_number, asset_name, ext_id, amount_applied
FROM   apps.okl_bpd_receipt_asset_uv
WHERE  asset_status = 'ACTIVE';

SELECT ext_id, SUM(TO_NUMBER(amount_applied)) total_applied
FROM   apps.okl_bpd_receipt_asset_uv
WHERE  asset_id IS NOT NULL
GROUP  BY ext_id;

Because AMOUNT_APPLIED is a formatted character value, arithmetic requires TO_NUMBER conversion. The unmatched branch (asset_id IS NULL) is useful for identifying receipts awaiting fixed-asset linkage.