Search Results ce_upg_purge_pay_accts_pk

Overview

The table CE_UPG_PURGE_PAY_ACCTS is a technical object within Oracle E-Business Suite (EBS) Cash Management (CE) module. Its primary role is to serve as a log or audit table for a specific data migration and cleanup utility. As documented, it records all processed Payables (PAY) external account results for the "Bank Upgrade Purging program." This program is typically executed during system upgrades or maintenance windows to purge or archive obsolete banking data that was migrated from older, legacy formats. The table's existence is crucial for ensuring data integrity during these purging operations, providing a traceable record of which external account records have been processed.

Key Information Stored

The table's structure is defined by its primary key, which consists of two columns. The EXTERNAL_ACCOUNT_ID column stores the unique identifier for the external bank account record from the Payables module that was processed by the purge program. The REQUEST_ID column holds the identifier of the concurrent request that executed the Bank Upgrade Purging program, linking the processed records to a specific job run. This two-column key ensures that a log entry is uniquely identified by the combination of the specific account and the specific purge request that acted upon it. The table's sole purpose is to maintain this relationship for audit and control purposes.

Common Use Cases and Queries

The primary use case for this table is post-process verification and troubleshooting of the Bank Upgrade Purging program. System administrators or functional consultants can query it to confirm which accounts were processed in a given run or to investigate errors. A common query would join this table with the source PAY_EXTERNAL_ACCOUNTS table to get descriptive details of the purged accounts for a specific request. For example:

• SELECT pea.* FROM ce_upg_purge_pay_accts cup, pay_external_accounts pea WHERE cup.external_account_id = pea.external_account_id AND cup.request_id = :req_id;

Another typical report would list all purge requests that have processed a particular external account, providing a history of its maintenance. Direct data manipulation (DML) on this table is not standard practice; it is populated and managed exclusively by the purge program itself.

Related Objects

CE_UPG_PURGE_PAY_ACCTS has a direct and singular foreign key relationship, as documented in the provided metadata. It references the PAY_EXTERNAL_ACCOUNTS table via the EXTERNAL_ACCOUNT_ID column. This relationship enforces referential integrity, ensuring every logged record corresponds to a valid external account in the Payables module. The table itself is referenced by its primary key constraint, CE_UPG_PURGE_PAY_ACCTS_PK. It is a dependent object of the concurrent program responsible for the Bank Upgrade Purging process within Cash Management. There are no other documented foreign keys from this table, indicating its specialized, single-purpose design.