Search Results proposed_transfer_id

Overview

The CE_PROPOSED_TRANSFERS table is a core transactional object within Oracle E-Business Suite Cash Management (CE) module, specifically supporting the Cash Leveling functionality. Its primary role is to act as a staging repository for proposed inter-bank or inter-account fund transfers generated by the Cash Leveling engine. This engine analyzes cash positions across defined cash pools and proposes transfers to optimize liquidity and meet funding requirements. The table's existence is transient by design; it serves as a working table that holds proposals until the associated fund transfers are executed and completed, after which its records are purged. This design ensures the table contains only active, pending proposals relevant for processing and review.

Key Information Stored

The table stores the defining attributes of each proposed transfer necessary for execution and tracking. The primary key, PROPOSED_TRANSFER_ID, uniquely identifies each proposal. A critical foreign key relationship is established via the CASHPOOL_ID column, which links the proposal to a specific source or target cash pool defined in the CE_CASHPOOLS table. While the provided metadata does not list all columns, typical data stored in such a table includes the proposed transfer amount, currency, source and target bank accounts, proposed value date, and the status of the proposal (e.g., 'PROPOSED', 'APPROVED', 'REJECTED'). The table also likely contains creation dates, last update dates, and identifiers linking back to the overarching Cash Leveling Proposal run that generated it.

Common Use Cases and Queries

The primary use case is the review and approval workflow for automated cash concentration proposals. Users can query pending transfers to analyze the Cash Leveling engine's recommendations before authorizing the creation of actual payments or receipts. Common reporting SQL patterns involve joining to CE_CASHPOOLS and bank account tables to present a readable summary. For instance:

• Listing all active proposals for a specific cash pool: SELECT * FROM ce_proposed_transfers WHERE cashpool_id = &pool_id AND status = 'PROPOSED';
• Summarizing proposed transfer totals by currency or account for a given proposal run.
• Identifying proposals pending beyond a certain period, which may indicate a stalled approval process.

Once approved, processes within Cash Management will consume these records to create the actual financial transactions, updating their status accordingly.

Related Objects

The CE_PROPOSED_TRANSFERS table has defined dependencies within the Cash Management schema. Its most direct relationship is with the CE_CASHPOOLS table, enforced by a foreign key on CASHPOOL_ID, which provides the context of the cash pool involved in the transfer. It is intrinsically linked to the broader Cash Leveling architecture, which likely involves other objects like CE_CASHLEVEL_PROPOSALS (to group transfers from a single run) and CE_BANK_ACCOUNTS. While not explicitly listed in the metadata, it is also related to standard transaction interfaces or APIs that convert approved proposals into payments (via AP) or receipts (via AR), and its purge mechanism is presumably managed by a concurrent program or database job within the CE module.