Results for “ce_fc_amts_bank_v”

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

Overview

CE_FC_AMTS_BANK_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, residing in the Cash Management (CE) product module. It is documented as a view created to group forecast results by bank account. In this capacity it functions as a presentation and aggregation layer over the underlying Cash Management forecasting tables, allowing forecast amounts generated by the Cash Forecasting engine to be summarized at the level of an individual bank account rather than at the level of individual forecast records or transaction sources.

The view is marked VALID in the ETRM metadata and is present in both Oracle EBS 12.1.1 and 12.2.2 environments. Because it is an APPS-owned view and not a base table, it carries no direct storage of its own; its output is derived at query time from forecast net flow data, opening balance data, and bank account master data. It is therefore intended for inquiry, reporting, and downstream integration rather than for transactional processing. Users searching for the term "bank_account" typically arrive at this view when attempting to reconcile forecast results against specific bank accounts or when building custom reports that summarize projected cash positions by account.

Underlying Base Objects

The documented base objects referenced by CE_FC_AMTS_BANK_V are as follows:

• CE_BANK_ACCOUNTS (synonym) — Provides the bank account name, bank account number, and currency code used to label each grouped forecast result.
• CE_FC_BANK_NETFLOW_V (view) — Supplies the forecast net flow amounts. The view text references columns of the form FCAMT0 through FCAMT80, representing forecasted cash flow amounts across the forecast period.
• CE_FORECASTS (synonym) — The forecast definition and factor data, referenced through the F.FACTOR element used to normalize balances and net flows.
• CE_FORECAST_OPENING_BAL (synonym) — Supplies OPENING_BALANCE, PRIOR_DAY_CFLOW, and BALANCE_DATE values used in the opening position calculations.
• CE_LOOKUPS (view) — Provides lookup meanings (L.MEANING), notably the "OTHERS" grouping label used when no specific bank account name is available.
• FND_ACCESS_CONTROL_UTIL, FND_GLOBAL, FND_PROFILE, MO_GLOBAL, and XTR_USER_ACCESS (packages) — Provide access control, organizational security, profile option resolution, and user access enforcement so that only forecast and bank account data visible to the current user or organization is returned.

The view performs an outer-style grouping in which bank accounts without a resolved name are collapsed into an "OTHERS" bucket, with a flag column set to 1 to identify that bucket and 0 for named accounts.

Key Columns

• Bank Account Label — NVL(BA.BANK_ACCOUNT_NAME, L.MEANING); the bank account name, or the lookup meaning when the name is not available.
• BANK_ACCOUNT_NUM — The bank account number associated with the forecast result.
• CURRENCY_CODE — The currency of the bank account, used to interpret the forecast amounts.
• Display Label — A concatenation of bank account name, account number, and currency code, or the "OTHERS" meaning when no account name exists.
• OTHERS Flag — A DECODE-derived indicator (1 for the "OTHERS" group, 0 otherwise) that allows reporting tools to sort or exclude the catch-all group.
• BANK_ACCOUNT_ID — The net flow bank account identifier, used to join back to CE_BANK_ACCOUNTS.
• Opening Balance — The opening balance divided by the forecast factor, or the raw opening balance when the factor is zero.
• BALANCE_DATE — The date associated with the opening balance and prior day cash flow.
• Prior Day Cash Flow — The prior day cash flow amount, similarly adjusted by the forecast factor.
• Forecast Net Flow Amount — The sum of FCAMT0 through FCAMT80, adjusted by the forecast factor when the factor is not zero.

Common Use Cases and Queries

The primary use case is producing a forecast position report grouped by bank account. A typical query excludes the "OTHERS" bucket and orders by account label:

• SELECT bank_account_num, currency_code, display_label, opening_balance, balance_date, forecast_net_flow FROM ce_fc_amts_bank_v WHERE others_flag = 0 ORDER BY display_label; — Lists named bank accounts with their forecast position.
• Reconciliation of forecasted net flows against bank account master data by joining BANK_ACCOUNT_ID back to CE_BANK_ACCOUNTS.
• Currency exposure reporting, grouping forecast amounts by CURRENCY_CODE to assess projected cash by currency.
• Inclusion of the "OTHERS" row (WHERE others_flag = 1) to detect forecast results that could not be attributed to a specific bank account, a useful data quality check.

Because the view enforces access control through the referenced FND and MO packages, queries automatically respect organization and user security, making it suitable for embedded use in custom concurrent programs and BI Publisher reports without additional security predicates.