Search Results maximum_payment_batch_outlay




Overview
Explore in AI Chat

Overview

APPS.CEBV_BANK_ACCOUNTS is a Business Intelligence System (BIS) view owned by the APPS schema and registered under the FND Design Data reference CE.CEBV_BANK_ACCOUNTS. In Oracle E-Business Suite 12.1.1 and 12.2.2 it exposes a denormalized, read-only projection of internal and external bank account definitions maintained by Oracle Cash Management and the Payments (IBY) modules. Unlike the transactional base tables, this view presents a flattened, reporting-oriented column set suitable for operational reporting, ad-hoc SQL, and integration extracts. It is designated a BI System view, meaning it is designed for query access rather than DML, and it should not be treated as a transaction table. Its status is VALID, confirming the object compiles and exposes the documented column list.

Underlying Base Objects

The view is defined over two referenced base objects: the synonym CE_BANK_ACCOUNTS and the view IBY_EXT_BANK_ACCOUNTS_V. CE_BANK_ACCOUNTS is the legacy Cash Management internal bank account entity, carrying the core account identity, naming, numbering, contact, and payment control attributes. IBY_EXT_BANK_ACCOUNTS_V is the Payments external bank account view introduced with the IBY schema in Release 12, which surfaces the externally-facing account representation used by payments processing. CEBV_BANK_ACCOUNTS therefore acts as a consolidation layer that reconciles the internal Cash Management account definition with its Payments-era external counterpart. The join is driven by BANK_ACCOUNT_ID, which is the internal primary key preserved as a NUMBER(15) in the view. Because one of the underlying objects is itself a view, no direct DML is possible, reinforcing the read-only reporting purpose.

Key Columns

Common Use Cases and Queries

Typical uses include bank account reconciliation reports, payment configuration audits, and extracts feeding external treasury systems. Retrieving an account by its alternate name is a frequent requirement:

SELECT BANK_ACCOUNT_ID, BANK_ACCOUNT_NAME, ALTERNATE_BANK_ACCOUNT_NAME, BANK_ACCOUNT_NUMBER, CURRENCY_CODE FROM APPS.CEBV_BANK_ACCOUNTS WHERE ALTERNATE_BANK_ACCOUNT_NAME = :p_name;

Active-account extraction by currency:

SELECT BANK_ACCOUNT_ID, BANK_ACCOUNT_NAME, ACCOUNT_HOLDER_NAME FROM APPS.CEBV_BANK_ACCOUNTS WHERE CURRENCY_CODE = 'USD' AND INACTIVE_DATE IS NULL;

Payment limit review:

SELECT BANK_ACCOUNT_NAME, MAXIMUM_PAYMENT_AMOUNT, MINIMUM_PAYMENT_AMOUNT, POOLED_ACCOUNT_FLAG FROM APPS.CEBV_BANK_ACCOUNTS ORDER BY BANK_ACCOUNT_NAME;

Because the view is read-only and consolidates IBY external account data, it is appropriate for reporting and validation queries, while account maintenance must continue through the standard Cash Management and Payments forms.