Search Results debit_credit_flag




Overview
Explore in AI Chat

Overview

APPS.FABV_TRANS_LINES is a read-only database view in Oracle E-Business Suite that exposes Oracle Assets (FA) adjustment transaction lines in a distribution-ready format. The view presents asset cost adjustments and their associated accounting flexfield information, combining adjustment-type, amount, and debit/credit orientation into a single queryable object. In Oracle EBS 12.1.1 and 12.2.2, the object resides in the APPS schema and is intended for reporting, reconciliation, and downstream integration against the Fixed Assets subledger.

The view carries a WITH READ ONLY clause, confirming it cannot be used for DML. It is therefore a query surface only, typically consumed by reports, custom concurrent programs, and extracts that need adjustment line detail without joining to the base table directly.

Underlying Base Objects

The view is defined over a single base object: the synonym FA_ADJUSTMENTS. Per the documented ETRM metadata (12.2.2), the only referenced base object is FA_ADJUSTMENTS (SYNONYM). The synonym resolves to the FA_ADJUSTMENTS table in the Oracle Assets schema, which stores adjustments to asset cost, including bonus, revaluation, and other transaction adjustments.

Because the view selects directly from FA_ADJUSTMENTS with no joins, it inherits the row granularity of that table — one row per adjustment line — and inherits its grants and read-only behavior. The notable transformation is the pivoting of the debit/credit indicator into two distinct amount columns via DECODE expressions.

Key Columns

Note that DEBIT_CREDIT_FLAG — the term the user searched — is the pivot column in the view definition; it is not directly projected, but drives the two decoded amount columns.

Common Use Cases and Queries

A frequent requirement is to report debits and credits separately per asset and book:

  • Reconciling asset adjustments to General Ledger distributions using CODE_COMBINATION_ID and DISTRIBUTION_ID.
  • Extracting adjustment lines by BOOK_TYPE_CODE and period for period-close reporting.
  • Feeding downstream systems (e.g., data warehouses) with cost adjustment detail keyed by TRANSACTION_HEADER_ID and ASSET_ID.

Sample query to retrieve debit and credit amounts for a given book and period:

  • SELECT asset_id, adjustment_type, book_type_code, code_combination_id, period_counter_adjusted, SUM(NVL(adjustment_debit,0)) debit_amt, SUM(NVL(adjustment_credit,0)) credit_amt FROM apps.fabv_trans_lines WHERE book_type_code = :book GROUP BY asset_id, adjustment_type, book_type_code, code_combination_id, period_counter_adjusted;

Because the view is read-only and based solely on FA_ADJUSTMENTS, it is safe for high-volume reporting without affecting the underlying subledger data.