Search Results ce_upg_pay_accts_tmp

Overview

The table CE_UPG_PAY_ACCTS_TMP is a temporary data repository within the Oracle E-Business Suite (EBS) Cash Management (CE) module, specifically for releases 12.1.1 and 12.2.2. Its primary function is to store details of purged bank accounts originating from the Oracle Payables (PAY) module during system upgrade or data migration processes. This table acts as a staging area, ensuring that references to historical bank account data are preserved and can be reconciled within Cash Management after the purging activity in Payables, thereby maintaining data integrity across the integrated financials suite.

Key Information Stored

While the provided ETRM metadata does not list individual columns, the documented primary and foreign key relationships define its core structure. The central column is EXTERNAL_ACCOUNT_ID, which serves as the table's primary key. This column holds the unique identifiers for the bank accounts that have been purged from the PAY_EXTERNAL_ACCOUNTS table. The table's purpose suggests it likely stores additional descriptive attributes of the purged accounts—such as account number, bank name, currency, and purged date—to facilitate audit trails and reference checks, though these are not explicitly detailed in the excerpt.

Common Use Cases and Queries

This table is predominantly used in administrative and upgrade contexts, not in daily transactional operations. A primary use case is validating the success and completeness of a Payables bank account purge process by comparing records in this temporary table against the live PAY_EXTERNAL_ACCOUNTS. Database administrators or functional consultants might query it to generate a report of all accounts removed during an upgrade. A typical SQL pattern would involve a simple select to list the purged account IDs, or a left outer join to identify any discrepancies.

• SELECT external_account_id FROM ce_upg_pay_accts_tmp ORDER BY external_account_id;
• SELECT tmp.external_account_id FROM ce_upg_pay_accts_tmp tmp WHERE NOT EXISTS (SELECT 1 FROM pay_external_accounts pea WHERE pea.external_account_id = tmp.external_account_id);

Related Objects

The table has a direct and singular foreign key relationship with a core Payables table, as documented in the ETRM metadata.

• PAY_EXTERNAL_ACCOUNTS: This is the primary source table. The column CE_UPG_PAY_ACCTS_TMP.EXTERNAL_ACCOUNT_ID references PAY_EXTERNAL_ACCOUNTS, establishing a link between the purged record in the temporary table and its original source. This relationship is enforced by a foreign key constraint.

Given its temporary and upgrade-specific nature, it is less commonly referenced by other application objects like views or public APIs, which are designed for operational data.