Results for “requester_id”

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

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:

• BANK_ACCOUNT_ID — foreign key to AP_BANK_ACCOUNTS_ALL; identifies the bank account to which the signatory is attached.
• SIGNATORY_ID — surrogate primary key and unique-indexed identifier for the signatory record.
• PERSON_ID — references the person (typically a party or HR person) acting as signatory.
• SINGLE_LIMIT_AMOUNT — maximum amount the signatory may approve individually.
• JOINT_LIMIT_AMOUNT — higher threshold permitted when the signatory acts jointly with others.
• SIGNER_GROUP — grouping classification for signatories sharing authority.
• OTHER_LIMITS — free-form descriptor for additional authority constraints.
• START_DATE and END_DATE — validity window of the signatory authorization.
• STATUS — current state of the signatory record.
• APPROVAL_TYPE_FLAG — indicates the approval mode (for example, single or joint signing authority).
• DELETED_FLAG — soft-delete indicator.
• REQUESTER_ID — the user who requested or created the signatory assignment.
• Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, plus the fifteen ATTRIBUTE flex columns and ATTRIBUTE_CATEGORY.

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.