Results for “ce_statement_reconcils_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CE_STATEMENT_RECONCILS_ALL is the Cash Management (CE) intersection table that stores statement reconciliation details within Oracle E-Business Suite 12.1.1 and 12.2.2. Each row links a bank statement line to the accounting or reference transaction against which it was reconciled. The table sits at the center of the bank reconciliation workflow, capturing how a statement line is cleared against a journal entry, a payment, a receipt, or another Cash Management reference. Because reconciliation is a many-to-many relationship between statement lines and reference transactions, this table functions as a resolution/bridge entity.

From a Data Vault modeling perspective (heuristic, mined from the foreign key structure), this table is best classified as a link. It resolves associations between two or more hubs — statement lines and reference transactions/journals — and carries descriptive and status attributes as link-level satellite columns. It is not itself a business hub, since it holds no natural business key independent of the relationships it encodes.

Key Information Stored

The documented physical schema contains 20 columns. The most significant are summarized below.

• STATEMENT_LINE_ID — Foreign key to CE_STATEMENT_LINES; identifies the bank statement line being reconciled.
• JE_HEADER_ID — Foreign key to GL_JE_HEADERS; identifies the journal entry header used in the clearing.
• LEGAL_ENTITY_ID — Foreign key to FV_LEGAL_ENTITIES; ties the reconciliation to the legal entity that owns the transaction.
• REFERENCE_TYPE — Classifies the reference object (for example, payment or receipt) being reconciled.
• REFERENCE_ID — Identifier of the specific reference transaction for the given REFERENCE_TYPE.
• CURRENT_RECORD_FLAG — Indicates whether the row is the active reconciliation record.
• REFERENCE_STATUS — Status of the referenced transaction at reconciliation time.
• STATUS_FLAG and ACTION_FLAG — Workflow and processing state indicators.
• AUTO_RECONCILED_FLAG — Distinguishes automatically reconciled rows from manually reconciled ones.
• AMOUNT — Reconciled monetary amount for the association.
• ORG_ID — Operating unit identifier enabling multi-org data access.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Standard concurrent program audit columns.

The primary key is CE_STMT_RECONCILIATIONS_PK, defined across STATEMENT_LINE_ID, REFERENCE_TYPE, REFERENCE_ID, JE_HEADER_ID, and CURRENT_RECORD_FLAG. This composite key is a surrogate/key construct rather than a single-column business key; the combination of STATEMENT_LINE_ID, REFERENCE_TYPE, and REFERENCE_ID serves as the practical business-key candidate when resolving an active reconciliation.

Common Use Cases and Queries

Typical uses include reconciliation reporting, statement-to-GL tie-outs, un-reconciled item analysis, and audit of automatic versus manual matches. A representative query joins statement lines to reconciliation rows and journal headers:

• Listing active reconciliations: filter on CURRENT_RECORD_FLAG = 'Y' for the current state.
• Reconciling to the ledger: join JE_HEADER_ID to GL_JE_HEADERS for journal details.
• Drilling from a statement line into its clearing references via STATEMENT_LINE_ID.
• Automation analysis: aggregate by AUTO_RECONCILED_FLAG and ACTION_FLAG.
• Operating unit reporting: constrain by ORG_ID and LEGAL_ENTITY_ID.

Related Objects

• CE_STATEMENT_LINES — referenced via STATEMENT_LINE_ID; the source statement line.
• GL_JE_HEADERS — referenced via JE_HEADER_ID; the clearing journal entry.
• FV_LEGAL_ENTITIES — referenced via LEGAL_ENTITY_ID.
• CE_STATEMENT_HEADERS — parent context for statement lines.
• CE_BANK_ACCOUNTS — bank account ownership of reconciled transactions.
• CE_RECONCILIATION_API / CE_RECONCILE APIs — programmatic entry points that write reconciliation rows.