Search Results min_check_amount




Overview
Explore in AI Chat

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

Overview

AP_BANK_ACCOUNTS_ALL is the master definition table for internal bank accounts within the Oracle E-Business Suite Payables (AP) module. Each row represents a single disbursement or remittance bank account owned by the deploying organization, capturing the account number, the branch and currency in which it operates, its check-printing constraints, the general ledger accounts used for accounting derived from its activity, and the receivables transaction controls applied to it. The table resides in the AP schema and was validated as a core, high-traffic object in both release 12.1.1 and 12.2.2. Because it is the authoritative point of reference for every payment, receipt, reconciliation, and cash-forecasting transaction performed against a corporate bank account, it is referenced by objects spanning Payables, Receivables, Cash Management, and Treasury.

Under the heuristic Data Vault classification applied to its foreign key structure, AP_BANK_ACCOUNTS_ALL is modeled as a hub. The rationale for the modeling suggestion is that its surrogate key, BANK_ACCOUNT_ID, is a stable business identifier referenced by a very large number of downstream satellites and transactional links, while the descriptive columns on the row are relatively static over the account's lifetime. The hub designation reflects the shape of the referential graph rather than a formal Data Vault implementation inside the EBS schema.

Key Information Stored

AP_BANK_ACCOUNTS_ALL contains 105 documented columns. The most significant are summarized below; the surrogate key is distinguished from business-key candidates where unique indexes are documented.

Common Use Cases and Queries

Typical reporting and extraction patterns revolve around locating the active bank account for a given operating unit, currency, and ledger, then joining that row to the GL and branch definitions required for financial reporting.

  • Resolving the bank account behind a payment: join AP_CHECKS_ALL.BANK_ACCOUNT_ID to AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_ID, then join BANK_BRANCH_ID to AP_BANK_BRANCHES to obtain branch and bank names.
  • Cash-management statement reconciliation: CE_STATEMENT_HEADERS_ALL.BANK_ACCOUNT_ID references this table, so statement-to-bank-account reconciliation queries anchor here.
  • GL account extraction: join the CCID columns to GL_CODE_COMBINATIONS to produce a decoded cash-clearing or bank-charges account for each bank account.
  • Filtering active accounts: WHERE INACTIVE_DATE IS NULL AND ORG_ID = :p_org_id is the standard pattern for presenting selectable accounts in a value set or LOV.
  • Multi-currency analysis: aggregate by CURRENCY_CODE and MULTI_CURRENCY_FLAG to identify accounts eligible for cross-currency payments or receipts.

Related Objects

AP_BANK_ACCOUNTS_ALL sits at the center of the payment and reconciliation model. The most significant referencing objects, with their join columns, are listed below.

  • CE_STATEMENT_HEADERS_ALL — references BANK_ACCOUNT_ID; this is the Cash Management statement header the searching user asked about. Each statement is reconciled against a single internal bank account.
  • AP_CHECKS_ALL — references BANK_ACCOUNT_ID and EXTERNAL_BANK_ACCOUNT_ID; every printed or electronic payment is tied to the disbursement account.
  • AP_CHECK_STOCKS_ALL — references BANK_ACCOUNT_ID; defines the check-stock assignments available for an account.
  • AP_BANK_ACCOUNT_USES_ALL — references EXTERNAL_BANK_ACCOUNT_ID; maps accounts to the payment documents and usages for which they are valid.
  • AR_CASH_RECEIPTS_ALL and RA_CUSTOMER_TRX_ALL — reference REMITTANCE_BANK_ACCOUNT_ID, tying receivables remittance activity back to the internal account.
  • AP_SYSTEM_PARAMETERS_ALL — references BANK_ACCOUNT_ID; this is the default disbursement account at the system level.
  • CE_TRANSACTION_CODES, CE_JE_MAPPINGS, and CE_FORECAST_* — reference BANK_ACCOUNT_ID to define transaction coding, journal mapping, and cash-forecast behavior for the account.
  • AP_BANK_BRANCHES, FND_CURRENCIES, and GL_CODE_COMBINATIONS — the principal foreign-key parents supplying branch, currency, and accounting-flexfield detail.