Search Results ap_bank_branches




Overview
Explore in AI Chat

Overview

The table CE_UPG_AP_BANKS_TMP is a temporary data repository within the Oracle E-Business Suite Cash Management (CE) module. Its primary role is to support system upgrade or data migration processes, specifically for the handling of purged bank branch records originating from the Accounts Payable (AP) module. This table acts as a staging area, ensuring that critical bank branch details are preserved and can be referenced during transitions, thereby maintaining data integrity and auditability when related records in primary transactional tables are removed or archived.

Key Information Stored

Based on the provided ETRM documentation, the table's central data point is the BANK_BRANCH_ID. This column stores the unique identifier for a bank branch that has been purged from the AP module's primary structures. The table's sole purpose is to retain this identifier, creating a definitive list of branches affected by a purge operation. The existence of a primary key constraint (CE_UPG_AP_BANKS_TMP_PK) on this column enforces uniqueness and ensures reliable reference. The table's structure is intentionally minimal, designed for a singular, temporary administrative function rather than for ongoing transactional activity.

Common Use Cases and Queries

The use of this table is almost exclusively tied to upgrade or data maintenance scripts. A common scenario involves validating the success of a purge or migration by comparing the contents of this temporary table against the master AP_BANK_BRANCHES table. Administrators may run queries to identify which specific bank branch records were processed during an upgrade window. A typical reporting query would be a simple SELECT to list all stored IDs or an anti-join to verify purged records are no longer active.

  • SELECT BANK_BRANCH_ID FROM CE.CE_UPG_AP_BANKS_TMP; – Retrieves the list of all purged bank branch identifiers.
  • SELECT abb.BANK_BRANCH_NAME FROM AP_BANK_BRANCHES abb WHERE abb.BANK_BRANCH_ID IN (SELECT tmp.BANK_BRANCH_ID FROM CE_UPG_AP_BANKS_TMP tmp); – Retrieves names of purged branches for verification reports (if branches still exist in the master table).

Related Objects

The table maintains a direct and documented foreign key relationship with a core Accounts Payable table, as specified in the metadata. This relationship is fundamental to its purpose.

  • AP_BANK_BRANCHES: This is the primary master table for bank branch information in the AP module. The foreign key from CE_UPG_AP_BANKS_TMP.BANK_BRANCH_ID references AP_BANK_BRANCHES.BANK_BRANCH_ID. This link ensures that every record in the temporary table corresponds to a previously valid entry in the master table, preserving referential integrity even after the purge.