Search Results two_day_float

Overview

The XTR_BANK_BALANCES_V view is an Oracle E-Business Suite Treasury (XTR) reporting object owned by the APPS schema. In ETRM 12.1.1 and 12.2.2, Treasury maintains bank account balance information used for cash positioning, interest accrual, netting, and reconciliation reporting. This view presents a stable, read-only projection of bank balance records, exposing both the base balance and a set of calculated Treasury fields—most notably the float columns referenced by searches such as one_day_float.

Its role in EBS reporting and integration is to provide a clean query surface for bank balance data without requiring consumers to reference the underlying transactional table directly. Cash management reports, interest calculation routines, and custom extracts (for example, feeds into a treasury data warehouse) can select from the view using standard APPS responsibilities. Because the view exposes float and interest fields alongside the core balance amounts, it is particularly useful when analysts need to model available versus ledger balances across accounts and dates.

Underlying Base Objects

The ETRM metadata documents a single referenced base object for this view: XTR_BANK_BALANCES, accessed through a synonym. This is a straightforward projection view; the view text selects a defined column list directly from XTR_BANK_BALANCES with no joins, unions, or aggregation. Consequently, one row in the view corresponds to one row in the base table for a given company code, account number, and balance date.

The view text confirms the column list: COMPANY_CODE, FIRST_BATCH_ID, LAST_BATCH_ID, EXCHANGE_RATE, ACCOUNT_NUMBER, BALANCE_DATE, NO_OF_DAYS, STATEMENT_BALANCE, BALANCE_ADJUSTMENT, BALANCE_CFLOW, ACCUM_INT_BFWD, INTEREST, INTEREST_RATE, INTEREST_SETTLED, INTEREST_SETTLED_HCE, ACCUM_INT_CFWD, UPDATED_BY, UPDATED_ON, SETOFF, AUDIT_INDICATOR, LIMIT_CODE, CREATED_BY, CREATED_ON, ACCRUAL_INTEREST, AVERAGE_EXCHANGE_RATE, ROUNDING_TYPE, DAY_COUNT_TYPE, ORIGINAL_AMOUNT, ONE_DAY_FLOAT, and TWO_DAY_FLOAT. Because the object is a view rather than a table, no indexes exist on it directly; performance depends on indexes defined on XTR_BANK_BALANCES.

Key Columns

• COMPANY_CODE / ACCOUNT_NUMBER: Identify the legal entity and the internal bank account to which the balance row belongs.
• BALANCE_DATE / NO_OF_DAYS: The balance date and the number of days represented, used in interest accrual and period-aware reporting.
• STATEMENT_BALANCE / BALANCE_ADJUSTMENT / BALANCE_CFLOW: The statement balance plus adjustments and cash-flow related balance used to derive the position actually reported for the account.
• ONE_DAY_FLOAT / TWO_DAY_FLOAT: Float amounts representing funds in transit that are expected to become available over one or two business days. These columns are the direct target of the one_day_float search and support available-balance analysis.
• ACCUM_INT_BFWD / INTEREST / ACCUM_INT_CFWD / ACCRUAL_INTEREST: Interest brought forward, accrued during the period, carried forward, and accrual interest used in Treasury interest computation.
• INTEREST_RATE / AVERAGE_EXCHANGE_RATE / EXCHANGE_RATE: Rates applied in interest and currency conversion calculations.
• INTEREST_SETTLED / INTEREST_SETTLED_HCE: Settled interest amounts in transaction and reporting currency.
• SETOFF / LIMIT_CODE / AUDIT_INDICATOR: Flags governing netting/setoff treatment, account limit assignment, and audit tracking.
• ORIGINAL_AMOUNT / ROUNDING_TYPE / DAY_COUNT_TYPE: Source amount and the rounding and day-count conventions used in interest calculation.
• CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON: Standard audit columns identifying the user and timestamp of creation and last change.
• FIRST_BATCH_ID / LAST_BATCH_ID: References to the batch or reconciliation run that first or last affected the balance record.

Common Use Cases and Queries

Typical use cases include cash position reporting, float and available-balance analysis, interest accrual review, and extract feeds to downstream treasury or ERP reporting systems. Analysts frequently query the view to compare statement balances with float-adjusted positions by account and date.

To examine one-day float by account and date:

SELECT company_code, account_number, balance_date,
       statement_balance, one_day_float, two_day_float
FROM   xtr_bank_balances_v
WHERE  balance_date BETWEEN :p_from_date AND :p_to_date
ORDER  BY company_code, account_number, balance_date;

To review float-adjusted availability:

SELECT account_number, balance_date,
       statement_balance - NVL(one_day_float,0) AS avail_one_day,
       statement_balance - NVL(two_day_float,0) AS avail_two_day
FROM   xtr_bank_balances_v
WHERE  company_code = :p_company;

To examine interest components:

SELECT account_number, balance_date, interest_rate,
       accum_int_bfwd, interest, accrual_interest, accum_int_cfwd
FROM   xtr_bank_balances_v
WHERE  account_number = :p_account;

As with any APPS-owned view, access should be granted through the appropriate Treasury responsibility or a custom grant; direct DML is not possible against the view. Reporting queries should be filtered by company code and account to leverage indexes on the underlying XTR_BANK_BALANCES table and avoid full scans.