Search Results ce_ba_signatories




Overview
Explore in AI Chat

Overview

CE_BA_SIGNATORIES is a Cash Management (CE) table in Oracle E-Business Suite that stores bank account signatory information for bank accounts defined in the system. In release 12.1.1 and 12.2.2, the table resides in the CE schema and is documented as VALID under ETRM. Each row represents a single authorized signatory record attached to a specific bank account, capturing the identity of the signer, the monetary limits under which the signer may operate, the effective date range of the authorization, and the approval and status attributes governing the record. The table holds 34 documented columns in the 12.2.2 physical schema.

From a Data Vault modeling perspective, the mined foreign key structure suggests classifying this object as satellite-leaning. Its grain is the individual signatory assignment, and it hangs off the bank account parent through a foreign key, making it a descriptive, potentially historized child rather than an independent business hub or an associative link between two hubs.

Key Information Stored

The surrogate primary key is SIGNATORY_ID, enforced by the CE_BA_SIGNATORIES_PK constraint and also carried by the unique index CE_BA_SIGNATORIES_U1, which makes SIGNATORY_ID the documented business-key candidate as well as the technical identifier. The most significant columns include:

Common Use Cases and Queries

Typical reporting scenarios include listing active signatories for a given bank account, verifying approval limits against payment amounts, and auditing signatory history by date range. A representative query joins signatories to their parent bank account:

  • SELECT s.signatory_id, s.person_id, s.single_limit_amount, s.joint_limit_amount, s.start_date, s.end_date, s.status FROM ce.ce_ba_signatories s WHERE s.bank_account_id = :p_account_id AND NVL(s.deleted_flag,'N') = 'N' AND TRUNC(SYSDATE) BETWEEN s.start_date AND NVL(s.end_date, TRUNC(SYSDATE)+1);
  • A limit-enforcement query filters records where SINGLE_LIMIT_AMOUNT >= :payment_amount for single-signer approvals.
  • An audit query orders by LAST_UPDATE_DATE DESC to surface recently reauthorized signatories.

These queries support treasury controls, internal audit sampling, and payment authorization configuration reviews.

Related Objects

The principal parent relationship is the foreign key from CE_BA_SIGNATORIES.BANK_ACCOUNT_ID to AP_BANK_ACCOUNTS_ALL, which anchors each signatory to its bank account. Other significant related objects include:

  • AP_BANK_ACCOUNTS_ALL — joined on BANK_ACCOUNT_ID; provides bank, branch, and account metadata.
  • AP_BANK_BRANCHES — reached through the bank account parent for branch-level reporting.
  • CE_BA_SIGNATORIES_PK / CE_BA_SIGNATORIES_U1 — the primary key constraint and unique index governing SIGNATORY_ID.
  • PER_ALL_PEOPLE_F — commonly joined on PERSON_ID to resolve signatory names.
  • CE Cash Management bank account setup and approval UI components that read and maintain signatory records.

Together these relationships make CE_BA_SIGNATORIES the operational store for bank account signing authority within the Cash Management module.