Search Results ce_transaction_codes




Overview
Explore in AI Chat

Overview

The CE_TRANSACTION_CODES table is a core reference table within the Oracle E-Business Suite Cash Management (CE) module. It serves as the central repository for defining and storing bank transaction codes. These codes are critical for the automated reconciliation of bank statements, as they map incoming bank transaction descriptions from electronic statements (e.g., BAI2, SWIFT MT940) to specific internal accounting events within Oracle EBS. The table enables the system to correctly categorize cash flows, such as distinguishing between customer receipts, supplier payments, bank charges, and interest income, thereby facilitating accurate cash positioning and automated journal entry creation.

Key Information Stored

The table's primary purpose is to link a transaction code to its corresponding accounting treatment and source. Key columns, as indicated by its foreign key relationships, include TRANSACTION_CODE_ID (the primary key), BANK_ACCOUNT_ID, RECEIPT_METHOD_ID, and RECEIVABLES_TRX_ID. The BANK_ACCOUNT_ID links the code to a specific bank account defined in AP_BANK_ACCOUNTS_ALL. The RECEIPT_METHOD_ID associates the code with a Receivables receipt method, defining how customer receipts are applied. The RECEIVABLES_TRX_ID links to AR_RECEIVABLES_TRX_ALL, tying the bank transaction to a specific receivables activity or invoice type. Other attributes typically define the code's type (e.g., 'RECEIPT', 'PAYMENT', 'MISC'), name, description, and the natural account to be used in the resulting accounting entry.

Common Use Cases and Queries

The primary use case is the setup and maintenance of automatic reconciliation rules. When a bank statement line is imported, its transaction code is matched against records in CE_TRANSACTION_CODES to determine the appropriate accounting action. A common reporting need is to list all configured transaction codes for a specific bank account to audit reconciliation setup. A sample query for this is:

  • SELECT tc.transaction_code, tc.name, tc.type, aba.bank_account_name FROM ce_transaction_codes tc, ap_bank_accounts_all aba WHERE tc.bank_account_id = aba.bank_account_id AND aba.bank_account_num = '<ACCOUNT_NUMBER>';

Another critical query involves diagnosing reconciliation failures by checking for statement lines (CE_STATEMENT_LINES) that could not be matched to a valid transaction code due to a missing or misconfigured entry in this table.

Related Objects

As per the provided metadata, CE_TRANSACTION_CODES has integral relationships with several key tables. It is referenced as a foreign key by transaction processing tables: CE_STATEMENT_LINES (holds imported bank statement details), CE_ARCH_LINES (for archived transactions), and CE_JE_MAPPINGS (for journal entry rule definitions). Its definitions are sourced from other modules via foreign keys to AP_BANK_ACCOUNTS_ALL (Payables bank accounts), AR_RECEIPT_METHODS (Receivables receipt methods), and AR_RECEIVABLES_TRX_ALL (Receivables transaction types). This structure ensures that bank transaction processing is tightly integrated with the underlying payables and receivables operations.