Results for “batch”

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

Overview

CE_BANK_ACCOUNTS is the master table for bank account information in the Cash Management (CE) module of Oracle E-Business Suite, documented as VALID in release 12.2.2 and applicable to 12.1.1. Each row represents a single internal or external bank account and must be affiliated with exactly one bank branch, which itself belongs to a bank. The table therefore captures the full identity, classification, currency, and control attributes of every account used for payments, receipts, treasury, and reconciliation across the EBS financials suite.

The account record is owned by more than one application. Accounts flagged for Payables, Receivables, Treasury, or Payments use carry application-specific tolerances, matching rules, and accounting flexfield references. From a Data Vault modeling perspective, the mined foreign-key structure classifies CE_BANK_ACCOUNTS as hub-leaning: BANK_ACCOUNT_ID behaves as a durable business key that many dependent transactional tables reference, with descriptive and rule-bearing attributes attached to the same physical structure. A formal Data Vault design would likely split these attributes into one or more satellites keyed to the account hub.

Key Information Stored

The documented physical schema contains 123 columns in the CE schema. The unique index CE_BANK_ACCOUNTS_U1 defines BANK_ACCOUNT_ID as the surrogate primary key. The most significant columns include:

• BANK_ACCOUNT_ID — surrogate primary key (CE_BANK_ACCOUNTS_U1) and the value propagated to all dependent tables.
• BANK_ACCOUNT_NAME / BANK_ACCOUNT_NAME_ALT / SHORT_ACCOUNT_NAME — user-facing account identifiers.
• BANK_ACCOUNT_NUM / MASKED_ACCOUNT_NUM / BANK_ACCOUNT_NUM_ELECTRONIC / IBAN_NUMBER / MASKED_IBAN — the real, masked, electronic, and international account numbers.
• BANK_ID, BANK_BRANCH_ID, ACCOUNT_HOLDER_ID, ACCOUNT_OWNER_PARTY_ID — party-model references (all to HZ_PARTIES) identifying the bank, branch, holder, and owner.
• CURRENCY_CODE — the account's denominating currency.
• ACCOUNT_CLASSIFICATION / BANK_ACCOUNT_TYPE — internal versus external role and account type.
• AP_USE_ALLOWED_FLAG, AR_USE_ALLOWED_FLAG, XTR_USE_ALLOWED_FLAG, PAY_USE_ALLOWED_FLAG — per-application access flags.
• START_DATE / END_DATE — effective dating of the account.
• INTEREST_SCHEDULE_ID — link to CE_INTEREST_SCHEDULES for interest computation.
• ASSET_CODE_COMBINATION_ID, CASH_CLEARING_CCID, BANK_CHARGES_CCID, BANK_ERRORS_CCID — GL accounting flexfield assignments.
• ACCOUNT_OWNER_ORG_ID — owning organization (HR_ALL_ORGANIZATION_UNITS).

Common Use Cases and Queries

Typical reporting covers account master listings, payment and receipt configuration, and reconciliation setup. A representative join to the bank party is:

• SELECT ba.bank_account_id, ba.bank_account_name, ba.bank_account_num, ba.currency_code, hp.party_name FROM ce_bank_accounts ba, hz_parties hp WHERE ba.bank_id = hp.party_id;
• Identify accounts enabled for Payables: filter on AP_USE_ALLOWED_FLAG = 'Y' and PAY_USE_ALLOWED_FLAG = 'Y'.
• Locate accounts in use by joining to CE_BANK_ACCT_USES_ALL on BANK_ACCOUNT_ID to resolve the owning operating unit.
• Reconciliation tuning queries that inspect AUTORECON_AP_MATCHING_ORDER, MANUAL_RECON_AMOUNT_TOLERANCE, and related RECON_* columns.
• Cash positioning reports joining CE_BANK_ACCT_BALANCES on BANK_ACCOUNT_ID for current and projected balances.

Related Objects

CE_BANK_ACCOUNTS is a heavily referenced parent. The most significant dependent and related objects include:

• CE_BANK_ACCT_USES_ALL — usage and operating-unit assignment (BANK_ACCOUNT_ID).
• CE_BANK_ACCT_BALANCES — opening and current balances (BANK_ACCOUNT_ID).
• CE_CE_CP_PD_BALANCES — cash pool, projected, and prior-day balances (CE_BANK_ACCOUNT_ID).
• CE_PROJECTED_BALANCES — projected cash flow (BANK_ACCOUNT_ID).
• IBY_PAYMENTS_ALL / IBY_DOCS_PAYABLE_ALL — payments and payment documents referencing INTERNAL_BANK_ACCOUNT_ID and EXTERNAL_BANK_ACCOUNT_ID.
• IBY_PAY_INSTRUCTIONS_ALL / IBY_PAY_SERVICE_REQUESTS / IBY_INTERMEDIARY_ACCTS — payment instructions and intermediary accounts.
• FV_AR_BATCHES_ALL / FV_INTERIM_CASH_RECEIPTS_ALL — Receivables receipt and batch references (CE_BANK_ACCOUNT_ID).
• CE_CONTACT_ASSIGNMENTS — contact-to-account assignments (BANK_ACCOUNT_ID).
• HZ_PARTIES / HR_ALL_ORGANIZATION_UNITS / CE_INTEREST_SCHEDULES — parent references used by this table.