Results for “xtr_bank_settlement_codes_v”

4 results




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

Overview

XTR_BANK_SETTLEMENT_CODES_V is a Treasury (XTR) module view that exposes bank and branch settlement code information used during the settlement of treasury transactions, including foreign exchange deals, loans, and other financial instruments managed within Oracle E-Business Suite. The view presents a consolidated list of bank identifiers together with their corresponding branch identifiers and settlement currencies, allowing settlement instructions to be resolved against the correct financial institution and branch. In Oracle EBS 12.1.1 and 12.2.2, this object is typically referenced by Treasury settlement workflows, payment formatting logic, and downstream reporting that must determine where funds are to be delivered or collected.

The view functions as a thin presentation layer: rather than storing data itself, it projects a subset of columns from its single documented base object. This design isolates settlement code consumers from the physical storage of the base table and provides a stable column interface for inquiries, concurrent programs, and ad hoc reports. It is principally read-only in nature, and no DML should be issued against it.

Underlying Base Objects

The view is defined exclusively over the base table XTR_BANK_SETTLEMENT_CODES. The documented view text is a simple SELECT of six columns from that table, with no joins, filters, or aggregations applied:

  • XTR_BANK_SETTLEMENT_CODES — the sole referenced base object, storing bank code, bank name, bank number, branch number, branch name, and currency attributes for settlement purposes.

Because the definition contains no WHERE clause, every row present in the base table is returned by the view. No other documented base objects, synonyms, or dependent views are recorded in the ETRM metadata.

Key Columns

The view exposes the following columns, each of which carries settlement-relevant meaning:

  • BANK_CODE — the operational code identifying the bank within Treasury settlement processing; commonly the primary lookup key.
  • BANK_NAME — the descriptive name of the financial institution, used for display and reporting.
  • BANK_NUMBER — the institution number or routing identifier transmitted in settlement and payment instructions.
  • BRANCH_NUMBER — the numeric identifier of the specific branch associated with the settlement instruction.
  • BRANCH_NAME — the descriptive name of the branch; this is the column most directly relevant to the search term "branch_name," and it is the field users typically query to locate a settlement code by branch.
  • CURRENCY — the currency in which the bank/branch settlement code is valid, enabling currency-specific settlement routing.

Common Use Cases and Queries

Typical scenarios include validating that a counterparty branch exists before settlement, populating branch selection lists in Treasury forms or reports, and producing settlement instruction extracts keyed by bank and currency. A frequent query is a search on branch name:

  • Search by branch name: SELECT bank_code, bank_name, bank_number, branch_number, branch_name, currency FROM xtr_bank_settlement_codes_v WHERE UPPER(branch_name) LIKE UPPER('%:branch_name%');
  • Settlement codes for a currency: SELECT bank_code, branch_number, branch_name FROM xtr_bank_settlement_codes_v WHERE currency = :currency;
  • Bank/branch lookup: SELECT bank_name, branch_name, currency FROM xtr_bank_settlement_codes_v WHERE bank_number = :bank_number AND branch_number = :branch_number;

These queries support settlement setup verification, treasury reporting, and integration extracts. Because the view inherits the full row set of the base table, appropriate predicates on BANK_CODE, BRANCH_NUMBER, or CURRENCY should be applied to constrain results.