Results for “fabv_src_lns”

14 results




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

Overview

FABV_SRC_LNS is an APPS-owned, read-only view in the Oracle E-Business Suite Fixed Assets (OFA) module. It is classified as a retrofitted object, meaning it was introduced or preserved to maintain backward compatibility with earlier Oracle EBS releases across the 12.1.1 and 12.2.2 code lines. The name breaks down as "FA" (Fixed Assets), "BV" (a view designation), and "SRC_LNS" (source lines), indicating that it exposes the source transaction lines from which fixed asset additions are derived.

The view presents payables-side invoice and distribution line detail that has not yet been fully capitalized or interfaced into the Fixed Assets module. It serves as a reporting and integration surface that lets Fixed Assets functionality read Accounts Payable invoice cost data without querying the underlying transactional table directly. This is especially relevant to the "fixed_assets_cost" search context, since FIXED_ASSETS_COST is one of the view's primary cost columns.

Underlying Base Objects

Compared against the documented metadata, FABV_SRC_LNS is defined over a single base object: the FA_ASSET_INVOICES synonym, which resolves to the FA_ASSET_INVOICES table in the APPS schema. The view text is a straightforward projection with two filter predicates applied:

  • INVOICE_TRANSACTION_ID_OUT IS NULL — restricts output to invoice lines that have not yet been transferred out to a downstream asset transaction.
  • DATE_INEFFECTIVE IS NULL — excludes logically deleted or superseded rows.

The view is defined WITH READ ONLY, so it cannot be used as a DML target. Because it references only a synonym, all column definitions inherit directly from FA_ASSET_INVOICES, and no joins, unions, or aggregations are present.

Key Columns

Common Use Cases and Queries

Typical uses include reconciling capitalized versus uncapitalized invoice costs, supporting the Additions and Adjustments workflows, and diagnosing lines that have not yet been picked up by the Mass Additions process. A common reconciliation query lists pending source lines:

  • Identify invoice lines awaiting capitalization by asset.
  • Compare FIXED_ASSETS_COST to PAYABLES_COST for variance analysis.
  • Trace costs back to AP invoice and PO references for audit.

Sample SQL:

SELECT asset_id,
       invoice_number,
       invoice_line_number,
       fixed_assets_cost,
       payables_cost
FROM   apps.fabv_src_lns
WHERE  invoice_date >= :p_from_date
AND    NVL(fixed_assets_cost,0) <> NVL(payables_cost,0);

Because the view is read-only and unfiltered beyond the two predicates, queries should always add date or asset criteria to bound the result set on high-volume instances.