Search Results source_table

Overview

The AR_CCID_CORRECTIONS_ALL table is a critical diagnostic and correction repository within Oracle E-Business Suite Receivables (AR). Its primary role is to log invalid or inactive accounting flexfield (code combination) entries that are detected during the General Ledger (GL) Transfer process. This process validates accounting distributions before posting to the GL. Each execution of the GL Transfer process purges and repopulates the table, ensuring it contains a current snapshot of all code combination errors requiring resolution for successful financial posting. The table supports multi-organization architecture through the ORG_ID column.

Key Information Stored

The table's structure is designed to precisely identify erroneous accounting entries and their potential corrections. Key columns include SOURCE_TABLE and DISTRIBUTION_ID, which together form a unique constraint (AR_CCID_CORRECTIONS_U1) to pinpoint the specific source transaction line. DISTRIBUTION_TYPE indicates the account class or source type, while CATEGORY_TYPE identifies the originating transaction activity. The erroneous and corrected code combinations are stored in CODE_COMBINATION_ID and NEW_CODE_COMBINATION_ID, respectively. The SUBMISSION_ID facilitates batch correction processing. For entries where SOURCE_TABLE is 'GLD', the DISTRIBUTION_ID holds the unique identifier from the GL_INTERFACE table.

Common Use Cases and Queries

The primary use case is troubleshooting and resolving GL Transfer failures. Administrators query this table to generate reports of invalid accounts blocking financial posting. A common pattern is to join with GL_CODE_COMBINATIONS to get account segment details. For example, to list all errors for a specific operating unit and submission:

• SELECT acc.source_table, acc.distribution_id, acc.code_combination_id, gcc.segment1, acc.category_type FROM ar_ccid_corrections_all acc, gl_code_combinations gcc WHERE acc.code_combination_id = gcc.code_combination_id AND acc.org_id = 123 AND acc.submission_id = 1001;

Another critical query identifies entries where a correction (NEW_CODE_COMBINATION_ID) has already been proposed but not yet processed. The table is also central to the Correct Accounting Flexfields concurrent program, which uses the stored NEW_CODE_COMBINATION_ID to automatically update source transactions.

Related Objects

This table is intrinsically linked to the GL Transfer process and the Correct Accounting Flexfields program. Its data directly references source transaction tables, such as RA_CUST_TRX_LINE_GL_DIST_ALL. The DISTRIBUTION_ID for 'GLD' source entries points to the GL_INTERFACE table. It is also related to GL_CODE_COMBINATIONS for validating account IDs. The indexes, particularly those on SUBMISSION_ID, SOURCE_TABLE, and DISTRIBUTION_TYPE, are optimized for the purge and rebuild operations of the GL Transfer and for correction batch processing.