Results for “eft_script_name”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
XTR_A_BANK_ACCOUNTS_V is an APPS-owned database view within the Oracle E-Business Suite Treasury (XTR) module. It presents a consolidated, query-ready projection of company bank account master data, combining bank, party, portfolio, settlement, and interest configuration attributes in a single relational structure. The view is commonly referenced by Treasury reporting, bank account inquiry forms, cash management dashboards, and downstream integrations requiring account-level attributes without joining the underlying bank and account tables directly.
Because the view carries a status of VALID in both Oracle EBS 12.1.1 and 12.2.2, it remains a stable interface point for custom reports, concurrent programs, and outbound interfaces. The user search term interest_calculation_basis maps directly to a column exposed by this view, making it a primary source for interest accrual, netting, and cash positioning calculations in Treasury.
Underlying Base Objects
The documented view text selects all columns from a single base object:
- XTR_A_BANK_ACCOUNTS — the underlying Treasury bank account table (referenced in APPS via a synonym). No joins to external tables appear in the documented view definition.
In practice, XTR_A_BANK_ACCOUNTS stores account-level attributes such as account number, currency, GL code combination, party references, and interest configuration. Because the view performs a straight SELECT ... FROM XTR_A_BANK_ACCOUNTS without filtering or aggregation, it behaves as a wide projection layer over the base table, preserving row cardinality and column semantics. Any DML against the base table is immediately visible through the view.
Key Columns
- ACCOUNT_NUMBER — The bank account number as recognized by the counterparty bank.
- PARTY_CODE / PARTY_TYPE / INTERNAL_PTY — Identify the owning party (internal or external) associated with the account.
- CURRENCY / DOMICILED_CURRENCY — The transactional and domiciled currencies for the account.
- CODE_COMBINATION_ID / GL_COMPANY_CODE / PARTY_PRIN_CCID / PARTY_INT_CCID — GL and party accounting flexfield references used for cash accounting and interest postings.
- INTEREST_CALCULATION_BASIS — Defines the day-count convention or basis used when computing interest on the account balance (for example, actual/360, actual/365, or 30/360 variants). This column drives Treasury interest accrual logic.
- INTEREST_RATE — The rate applied to the account for interest computation.
- YEAR_CALC_TYPE / INTEREST_RATE — Together with INTEREST_CALCULATION_BASIS, these govern interest calculation behavior on cash balances.
- OPENING_BALANCE / OPENING_BAL_HCE / STATEMENT_DATE — Opening position and statement reference data used in reconciliation and cash positioning.
- PROJECTED_BALANCE / PROJECTED_BALANCE_DATE / PROJECTED_BALANCE_UPDATED_ON — Forward-looking balance estimates maintained by Treasury cash forecasting.
- CASHFLOWS_TO_CURRENT_DATE / CURRENT_CASHFLOW_DATE — Aggregated cashflow indicators up to the current date.
- PRIMARY_SETTLEMENT_METHOD / DIRECT_DEBIT_AUTHORITY / EFT_SCRIPT_NAME / EFT_SCRIPT_OUTPUT_PATH — Settlement and electronic funds transfer configuration.
- SETOFF / SETOFF_COMPANY / SETOFF_ACCOUNT_YN — Netting and setoff eligibility indicators.
- PORTFOLIO_CODE / LIMIT_CODE / AUTHORISED — Portfolio assignment, exposure limit reference, and authorization status.
- CREATED_BY / CREATED_ON / UPDATED_BY / UPDATED_ON / AUDIT_INDICATOR / AUDIT_DATE_STORED — Standard audit trail columns.
Common Use Cases and Queries
Treasury analysts and developers use this view for bank account inquiry, interest configuration reporting, and cash positioning extracts. Typical queries filter on currency or portfolio and retrieve interest attributes for accrual validation.
- Retrieving all accounts and their interest calculation basis:
SELECT account_number, currency, interest_calculation_basis, interest_rate FROM apps.xtr_a_bank_accounts_v WHERE authorised = 'Y';
- Identifying accounts by portfolio or company for cash positioning:
SELECT account_number, bank_name, portfolio_code, projected_balance FROM apps.xtr_a_bank_accounts_v WHERE gl_company_code = :company AND currency = :currency;
- Auditing interest configuration changes:
SELECT account_number, interest_calculation_basis, year_calc_type, updated_by, updated_on, audit_date_stored FROM apps.xtr_a_bank_accounts_v WHERE audit_indicator = 'Y';
Because the view is a thin projection, standard EBS extensibility approaches (custom BI Publisher reports, OAF-based inquiries, or integration extracts) can consume it directly, subject to the standard APPS schema privileges and Treasury security policies.
-
View: XTR_A_BANK_ACCOUNTS_V 12.1.1
APPS.XTR_A_BANK_ACCOUNTS_V·↳ XTR_A_BANK_ACCOUNTS·Explore XTR module →
-
Created from Entity XTR BANK ACCOUNT by ORACLE on 06-MAY-93
-
Bank account information
-
View: XTR_A_BANK_ACCOUNTS_V 12.2.2
APPS.XTR_A_BANK_ACCOUNTS_V·↳ XTR_A_BANK_ACCOUNTS·Explore XTR module →
-
View: XTR_BANK_ACCOUNTS_V 12.1.1
APPS.XTR_BANK_ACCOUNTS_V·↳ XTR_BANK_ACCOUNTS·Explore XTR module →
-
View: XTR_BANK_ACCOUNTS_V 12.2.2
APPS.XTR_BANK_ACCOUNTS_V·↳ XTR_BANK_ACCOUNTS·Explore XTR module →
-
View: XTR_IG_BANK_ACCOUNTS_V 12.1.1
No longer used. Intercompany account information
APPS.XTR_IG_BANK_ACCOUNTS_V·↳ XTR_BANK_ACCOUNTS·↳ XTR_PARTY_INFO·Explore XTR module →
-
Created from Entity XTR BANK ACCOUNT by ORACLE on 06-MAY-93
-
View: CE_BANK_ACCT_USES_OU_V 12.1.1
This view stores bank account uses information for operating units.
APPS.CE_BANK_ACCT_USES_OU_V·↳ CE_BANK_ACCOUNTS·↳ CE_BANK_ACCT_USES_OU·Explore CE module →
-
This table stores information about your bank account uses.
-
View: CE_BANK_ACCT_USES 12.2.2
APPS.CE_BANK_ACCT_USES·↳ CE_BANK_ACCT_USES_ALL·↳ CE_BANK_ACCT_USES_OU·↳ CE_SECURITY_PROFILES_V·Explore CE module →
-
View: XTR_IG_BANK_ACCOUNTS_V 12.2.2
No longer used. Intercompany account information
APPS.XTR_IG_BANK_ACCOUNTS_V·↳ XTR_BANK_ACCOUNTS·↳ XTR_PARTY_INFO·Explore XTR module →
-
View: CE_BANK_ACCT_USES_GT_V 12.1.1
APPS.CE_BANK_ACCT_USES_GT_V·↳ CE_BANK_ACCT_USES_ALL·↳ CE_SECURITY_PROFILES_GT·Explore CE module →
-
View: CE_BANK_ACCT_USES_OU_V 12.2.2
This view stores bank account uses information for operating units.
APPS.CE_BANK_ACCT_USES_OU_V·↳ CE_BANK_ACCOUNTS·↳ CE_BANK_ACCT_USES_OU·Explore CE module →
-
View: CE_BANK_ACCT_USES_GT_V 12.2.2
APPS.CE_BANK_ACCT_USES_GT_V·↳ CE_BANK_ACCT_USES_ALL·↳ CE_SECURITY_PROFILES_GT·Explore CE module →
-
View: CE_BANK_ACCT_USES 12.1.1
APPS.CE_BANK_ACCT_USES·↳ CE_BANK_ACCT_USES_ALL·↳ CE_BANK_ACCT_USES_OU·↳ CE_SECURITY_PROFILES_V·Explore CE module →
-
This table stores information about your bank account uses.
-
Bank account information
-
VIEW: XTR.XTR_BANK_ACCOUNTS# 12.2.2
-
VIEW: XTR.XTR_BANK_ACCOUNTS# 12.2.2
-
VIEW: APPS.CE_BANK_ACCT_USES 12.1.1
-
VIEW: APPS.CE_BANK_ACCT_USES 12.2.2
-
TABLE: XTR.XTR_BANK_ACCOUNTS 12.1.1
-
TABLE: XTR.XTR_BANK_ACCOUNTS 12.2.2