Results for “one_day_float”

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

Overview

The XTR_BANK_BAL_INTERFACE table is a Treasury module (XTR) staging table within the Oracle E-Business Suite 12.1.1 and 12.2.2 data model. It stores bank account balance information that is loaded into Oracle Treasury from external sources — typically bank statement files, flat-file feeds, or bank connectivity interfaces — before being validated and consumed by Treasury balance processes. The table resides in the XTR schema and is classified as VALID in the ETRM data dictionary.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is link. This reflects the table's role as an associative construct connecting a bank account (XTR_BANK_ACCOUNTS) to a bank account use definition (CE_BANK_ACCT_USES_ALL) at a specific point in time. The composite primary key of ACCOUNT_NO, COMPANY_CODE, and BALANCE_DATE establishes the grain of the staging record and reinforces the temporal, relationship-driven nature of the data.

Key Information Stored

The table contains ten documented columns. The most significant are summarized below:

• ACCOUNT_NO — The bank account identifier. Part of the composite primary key and a foreign key to XTR_BANK_ACCOUNTS.
• COMPANY_CODE — The Treasury company or legal entity owning the balance. Part of the composite primary key.
• BALANCE_DATE — The effective date of the reported balance. Part of the composite primary key and the third component of the business key.
• BANK_ACCT_USE_ID — Foreign key to CE_BANK_ACCT_USES_ALL, linking the interface record to a specific bank account use configuration in Cash Management.
• AMOUNT — The primary balance amount as received from the external source.
• AMOUNT_ADJ — An adjusted balance amount, typically reflecting corrections or reconciled values.
• AMOUNT_CFLOW — The cash flow amount associated with the balance record.
• ONE_DAY_FLOAT and TWO_DAY_FLOAT — Float amounts representing funds in transit over one-day and two-day settlement windows.
• TRANSFER_SUCCEEDED — A status indicator reflecting whether the interface record was successfully transferred into the Treasury balance tables.

The surrogate primary key is XTR_BANK_BAL_INTERFACE_PK, a composite of ACCOUNT_NO, COMPANY_CODE, and BALANCE_DATE. The unique index XTR_BANK_BAL_INTERFACE_U1 (COMPANY_CODE, ACCOUNT_NO, BALANCE_DATE) is a business-key candidate with an equivalent column set presented in a different order, ensuring no duplicate balance rows exist per account, company, and date.

Common Use Cases and Queries

Typical scenarios include monitoring inbound bank balance feeds, reconciling balances against bank statements, and diagnosing records that failed the transfer to Treasury. A frequent query checks transfer status:

• SELECT company_code, account_no, balance_date, amount FROM xtr_bank_bal_interface WHERE transfer_succeeded = 'N' ORDER BY balance_date;
• Joining to the account master: SELECT b.account_no, a.account_name, b.balance_date, b.amount FROM xtr_bank_bal_interface b, xtr_bank_accounts a WHERE b.account_no = a.account_no AND b.company_code = a.company_code AND b.balance_date BETWEEN :p_from AND :p_to;
• Float analysis: aggregate ONE_DAY_FLOAT and TWO_DAY_FLOAT by BALANCE_DATE to assess net float exposure across accounts.

Reporting use cases include daily liquidity dashboards, cash positioning reports, and interface error logs where TRANSFER_SUCCEEDED flags incomplete loads.

Related Objects

• XTR_BANK_ACCOUNTS — Parent of ACCOUNT_NO and COMPANY_CODE; provides account master attributes.
• CE_BANK_ACCT_USES_ALL — Referenced through BANK_ACCT_USE_ID, defining how the bank account is used within Cash Management.
• XTR_BANK_BALANCES — Downstream Treasury balance table populated from successfully transferred interface rows.
• XTR_BANK_BAL_INTERFACE_PK — The primary key constraint enforcing uniqueness on ACCOUNT_NO, COMPANY_CODE, BALANCE_DATE.
• XTR_BANK_BAL_INTERFACE_U1 — The unique index supporting business-key integrity and efficient lookups.
• CE_BANK_ACCOUNTS — The underlying bank account definition in Cash Management, reachable through CE_BANK_ACCT_USES_ALL.