Search Results ce_gl_accounts_ccid




Overview
Explore in AI Chat

Overview

The CE_GL_ACCOUNTS_CCID table is a core data object within the Oracle E-Business Suite Cash Management (CE) module, serving as the central repository for accounting flexfield (code combination) assignments for bank accounts. Its primary role is to define the specific General Ledger accounts used for posting various cash-related transactions associated with a bank account's internal uses. This table is essential for ensuring accurate and automated accounting entries during bank statement reconciliation, payment processing, and receipt application. It acts as the critical link between the subledger transaction details in Cash Management and the corresponding accounting entries in the General Ledger (GL).

Key Information Stored

The table's structure is defined by a primary key and a series of foreign key columns linking to specific GL code combinations. The BANK_ACCT_USE_ID column is the primary key, uniquely identifying the internal use of a bank account (from CE_BANK_ACCT_USES_ALL). The remaining columns are foreign keys to GL_CODE_COMBINATIONS, each representing a distinct accounting scenario. Key columns include:

Common Use Cases and Queries

This table is central to troubleshooting accounting issues and generating reports on account assignments. A common use case is verifying the GL accounts configured for a specific bank account use to diagnose posting errors. For example, to list all accounting assignments for a given bank account internal use ID, a query would join CE_GL_ACCOUNTS_CCID with GL_CODE_COMBINATIONS for the relevant CCID columns. Another critical scenario is during month-end close, where accountants may query this table to validate that all necessary clearing and suspense accounts are properly mapped before running reconciliation processes. Developers customizing cash flows or building integrations also reference this table to understand the source of posted accounting flexfields.

Related Objects

The CE_GL_ACCOUNTS_CCID table has extensive dependencies within the EBS architecture. Its primary relationship is with the CE_BANK_ACCT_USES_ALL table, via the BANK_ACCT_USE_ID foreign key, which defines the operating context of the bank account. Most importantly, it has multiple foreign key relationships to the GL_CODE_COMBINATIONS table, one for each distinct accounting scenario (e.g., ON_ACCOUNT_CCID, CASH_CLEARING_CCID). This table is directly referenced by the Cash Management application's posting engine. While not listed in the provided metadata, it is also closely related to the CE_BANK_ACCOUNTS table (through CE_BANK_ACCT_USES_ALL) and is foundational for the accounting events generated by the CE_GL_RECONCILE_PKG and related APIs.