Search Results ce_statement_reconcils_all
The CE_STATEMENT_RECONCILS_ALL
table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical component of the Cash Management module, primarily used for bank statement reconciliation. This table stores detailed reconciliation records that link bank statement lines with accounting transactions, ensuring accurate financial reporting and audit compliance. Below is a detailed analysis of its structure, functionality, and significance within Oracle EBS.
Purpose and Functionality
TheCE_STATEMENT_RECONCILS_ALL
table serves as the backbone for the reconciliation process between bank statements and internal accounting entries (e.g., payments, receipts, journal entries). It captures reconciliation metadata, including matched amounts, reconciliation dates, and references to source transactions. Key functionalities include:
- Transaction Matching: Links bank statement lines (
CE_STATEMENT_LINES_ALL
) to accounting transactions (e.g.,AP_INVOICES_ALL
,AR_CASH_RECEIPTS_ALL
). - Reconciliation Status Tracking: Maintains reconciliation statuses (e.g., reconciled, unreconciled, or in dispute).
- Audit Trail: Provides a historical record of reconciliation actions for compliance.
Table Structure
The table includes columns that map to reconciliation attributes, such as:- STATEMENT_RECONCIL_ID: Primary key.
- STATEMENT_LINE_ID: Foreign key to
CE_STATEMENT_LINES_ALL
. - TRANSACTION_ID: References the accounting transaction (e.g., payment ID or receipt ID).
- RECONCILED_AMOUNT: The matched amount between the statement line and transaction.
- RECONCILED_DATE: Date of reconciliation.
- STATUS_FLAG: Indicates reconciliation status (e.g., 'R' for reconciled).
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE: Standard Oracle audit columns.
Integration with Other Modules
The table integrates with:- Payables (AP): Links to
AP_INVOICES_ALL
for payment reconciliations. - Receivables (AR): References
AR_CASH_RECEIPTS_ALL
for receipt reconciliations. - General Ledger (GL): Ties reconciled entries to GL journals via
GL_JE_BATCHES
.
Key Processes
- AutoReconciliation: Oracle Cash Management uses rules to auto-match statement lines to transactions, populating this table.
- Manual Reconciliation: Users manually link entries, updating
CE_STATEMENT_RECONCILS_ALL
. - Reconciliation Reports: Data from this table feeds reports like the Bank Reconciliation Report.
Technical Considerations
- Multi-Org Support: The
_ALL
suffix indicates it stores data for all operating units (accessible viaORG_ID
). - Indexing: Key columns like
STATEMENT_LINE_ID
andTRANSACTION_ID
are indexed for performance. - Data Volume: High-frequency reconciliations can lead to large data volumes, necessitating archival strategies.
Customizations and Extensions
Common extensions include:- Custom reconciliation rules via Oracle Workflow.
- Triggers or APIs to enforce additional validation logic.
- Integration with third-party banking systems.
Conclusion
TheCE_STATEMENT_RECONCILS_ALL
table is pivotal for ensuring financial accuracy in Oracle EBS. Its design supports both automated and manual reconciliation processes, while integrations with AP, AR, and GL modules streamline end-to-end financial operations. Proper understanding of this table is essential for troubleshooting reconciliation issues, optimizing performance, and maintaining audit integrity.
-
Table: CE_STATEMENT_RECONCILS_ALL
12.1.1
owner:CE, object_type:TABLE, fnd_design_data:CE.CE_STATEMENT_RECONCILS_ALL, object_name:CE_STATEMENT_RECONCILS_ALL, status:VALID, product: CE - Cash Management , description: Statement reconciliation details , implementation_dba_data: CE.CE_STATEMENT_RECONCILS_ALL ,
-
Table: CE_STATEMENT_RECONCILS_ALL
12.2.2
owner:CE, object_type:TABLE, fnd_design_data:CE.CE_STATEMENT_RECONCILS_ALL, object_name:CE_STATEMENT_RECONCILS_ALL, status:VALID, product: CE - Cash Management , description: Statement reconciliation details , implementation_dba_data: CE.CE_STATEMENT_RECONCILS_ALL ,
-
View: CEBV_STMTRECON
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CEBV_STMTRECON, object_name:CEBV_STMTRECON, status:VALID, product: CE - Cash Management , description: Business View , implementation_dba_data: APPS.CEBV_STMTRECON ,
-
View: CEBV_STMTRECON
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CEBV_STMTRECON, object_name:CEBV_STMTRECON, status:VALID, product: CE - Cash Management , description: Business View , implementation_dba_data: APPS.CEBV_STMTRECON ,
-
View: CEFV_STMTRECON
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CEFV_STMTRECON, object_name:CEFV_STMTRECON, status:VALID, product: CE - Cash Management , description: Business View , implementation_dba_data: APPS.CEFV_STMTRECON ,
-
View: CEFV_STMTRECON
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CEFV_STMTRECON, object_name:CEFV_STMTRECON, status:VALID, product: CE - Cash Management , description: Business View , implementation_dba_data: APPS.CEFV_STMTRECON ,
-
Table: CE_ARCH_RECONCILIATIONS_ALL
12.2.2
owner:CE, object_type:TABLE, fnd_design_data:CE.CE_ARCH_RECONCILIATIONS_ALL, object_name:CE_ARCH_RECONCILIATIONS_ALL, status:VALID, product: CE - Cash Management , description: Archived CE_STATEMENT_RECONCILS_ALL records , implementation_dba_data: CE.CE_ARCH_RECONCILIATIONS_ALL ,
-
Table: CE_ARCH_RECONCILIATIONS_ALL
12.1.1
owner:CE, object_type:TABLE, fnd_design_data:CE.CE_ARCH_RECONCILIATIONS_ALL, object_name:CE_ARCH_RECONCILIATIONS_ALL, status:VALID, product: CE - Cash Management , description: Archived CE_STATEMENT_RECONCILS_ALL records , implementation_dba_data: CE.CE_ARCH_RECONCILIATIONS_ALL ,
-
Table: CE_STATEMENT_LINES
12.2.2
owner:CE, object_type:TABLE, fnd_design_data:CE.CE_STATEMENT_LINES, object_name:CE_STATEMENT_LINES, status:VALID, product: CE - Cash Management , description: Bank statement lines , implementation_dba_data: CE.CE_STATEMENT_LINES ,
-
Table: CE_STATEMENT_LINES
12.1.1
owner:CE, object_type:TABLE, fnd_design_data:CE.CE_STATEMENT_LINES, object_name:CE_STATEMENT_LINES, status:VALID, product: CE - Cash Management , description: Bank statement lines , implementation_dba_data: CE.CE_STATEMENT_LINES ,
-
View: CE_STATEMENT_RECON_GT_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_STATEMENT_RECON_GT_V, object_name:CE_STATEMENT_RECON_GT_V, status:VALID, product: CE - Cash Management , implementation_dba_data: APPS.CE_STATEMENT_RECON_GT_V ,
-
View: CE_STATEMENT_RECON_GT_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_STATEMENT_RECON_GT_V, object_name:CE_STATEMENT_RECON_GT_V, status:VALID, product: CE - Cash Management , implementation_dba_data: APPS.CE_STATEMENT_RECON_GT_V ,
-
View: CE_101_TRANSACTIONS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_101_TRANSACTIONS_V, object_name:CE_101_TRANSACTIONS_V, status:VALID, product: CE - Cash Management , description: Available GL journals for reconciliation , implementation_dba_data: APPS.CE_101_TRANSACTIONS_V ,
-
View: CE_STATEMENT_RECONCILIATIONS
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_STATEMENT_RECONCILIATIONS, object_name:CE_STATEMENT_RECONCILIATIONS, status:VALID, product: CE - Cash Management , implementation_dba_data: APPS.CE_STATEMENT_RECONCILIATIONS ,
-
View: CE_STATEMENT_RECONCILIATIONS
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_STATEMENT_RECONCILIATIONS, object_name:CE_STATEMENT_RECONCILIATIONS, status:VALID, product: CE - Cash Management , implementation_dba_data: APPS.CE_STATEMENT_RECONCILIATIONS ,
-
View: CE_101_TRANSACTIONS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_101_TRANSACTIONS_V, object_name:CE_101_TRANSACTIONS_V, status:VALID, product: CE - Cash Management , description: Available GL journals for reconciliation , implementation_dba_data: APPS.CE_101_TRANSACTIONS_V ,
-
View: CE_222_TRANSACTIONS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_222_TRANSACTIONS_V, object_name:CE_222_TRANSACTIONS_V, status:VALID, product: CE - Cash Management , description: Available AR receipts for reconciliation or clearing , implementation_dba_data: APPS.CE_222_TRANSACTIONS_V ,
-
View: CE_222_TXN_FOR_BATCH_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_222_TXN_FOR_BATCH_V, object_name:CE_222_TXN_FOR_BATCH_V, status:VALID, product: CE - Cash Management , description: Available Remittance Batches for Reconciliation or Clearing. , implementation_dba_data: APPS.CE_222_TXN_FOR_BATCH_V ,
-
View: CE_801_TRANSACTIONS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_801_TRANSACTIONS_V, object_name:CE_801_TRANSACTIONS_V, status:VALID, product: CE - Cash Management , description: Available Payroll payments for reconciliation , implementation_dba_data: APPS.CE_801_TRANSACTIONS_V ,
-
View: CE_222_TXN_FOR_BATCH_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_222_TXN_FOR_BATCH_V, object_name:CE_222_TXN_FOR_BATCH_V, status:VALID, product: CE - Cash Management , description: Available Remittance Batches for Reconciliation or Clearing. , implementation_dba_data: APPS.CE_222_TXN_FOR_BATCH_V ,
-
View: CE_222_TRANSACTIONS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_222_TRANSACTIONS_V, object_name:CE_222_TRANSACTIONS_V, status:VALID, product: CE - Cash Management , description: Available AR receipts for reconciliation or clearing , implementation_dba_data: APPS.CE_222_TRANSACTIONS_V ,
-
View: CE_999_REVERSAL_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_999_REVERSAL_V, object_name:CE_999_REVERSAL_V, status:VALID, product: CE - Cash Management , description: Open interface transactions for unclearing , implementation_dba_data: APPS.CE_999_REVERSAL_V ,
-
View: CE_801_TRANSACTIONS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_801_TRANSACTIONS_V, object_name:CE_801_TRANSACTIONS_V, status:VALID, product: CE - Cash Management , description: Available Payroll payments for reconciliation , implementation_dba_data: APPS.CE_801_TRANSACTIONS_V ,
-
View: CE_999_REVERSAL_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_999_REVERSAL_V, object_name:CE_999_REVERSAL_V, status:VALID, product: CE - Cash Management , description: Open interface transactions for unclearing , implementation_dba_data: APPS.CE_999_REVERSAL_V ,
-
View: CE_801_RECONCILED_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_801_RECONCILED_V, object_name:CE_801_RECONCILED_V, status:VALID, product: CE - Cash Management , description: Reconciled Payroll payments for unreconciling , implementation_dba_data: APPS.CE_801_RECONCILED_V ,
-
View: CE_801_RECONCILED_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_801_RECONCILED_V, object_name:CE_801_RECONCILED_V, status:VALID, product: CE - Cash Management , description: Reconciled Payroll payments for unreconciling , implementation_dba_data: APPS.CE_801_RECONCILED_V ,
-
View: CE_260_CF_REVERSAL_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_260_CF_REVERSAL_V, object_name:CE_260_CF_REVERSAL_V, status:VALID, product: CE - Cash Management , description: AR receipts for reversing or unclearing , implementation_dba_data: APPS.CE_260_CF_REVERSAL_V ,
-
View: CE_260_RECONCILED_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_260_RECONCILED_V, object_name:CE_260_RECONCILED_V, status:VALID, product: CE - Cash Management , description: Reconciled statement lines for unreconciling , implementation_dba_data: APPS.CE_260_RECONCILED_V ,
-
View: CE_260_RECONCILED_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_260_RECONCILED_V, object_name:CE_260_RECONCILED_V, status:VALID, product: CE - Cash Management , description: Reconciled statement lines for unreconciling , implementation_dba_data: APPS.CE_260_RECONCILED_V ,
-
View: CE_260_CF_REVERSAL_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_260_CF_REVERSAL_V, object_name:CE_260_CF_REVERSAL_V, status:VALID, product: CE - Cash Management , description: AR receipts for reversing or unclearing , implementation_dba_data: APPS.CE_260_CF_REVERSAL_V ,
-
View: CE_801_EFT_RECONCILED_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_801_EFT_RECONCILED_V, object_name:CE_801_EFT_RECONCILED_V, status:VALID, product: CE - Cash Management , description: Reconciled Payroll payments for unreconciling , implementation_dba_data: APPS.CE_801_EFT_RECONCILED_V ,
-
View: CE_801_EFT_TRANSACTIONS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_801_EFT_TRANSACTIONS_V, object_name:CE_801_EFT_TRANSACTIONS_V, status:VALID, product: CE - Cash Management , implementation_dba_data: APPS.CE_801_EFT_TRANSACTIONS_V ,
-
View: CE_801_EFT_TRANSACTIONS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_801_EFT_TRANSACTIONS_V, object_name:CE_801_EFT_TRANSACTIONS_V, status:VALID, product: CE - Cash Management , implementation_dba_data: APPS.CE_801_EFT_TRANSACTIONS_V ,
-
View: CE_185_RECONCILED_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_185_RECONCILED_V, object_name:CE_185_RECONCILED_V, status:VALID, product: CE - Cash Management , description: Reconciled Treasury transactions for unreconciling via Open Interface , implementation_dba_data: APPS.CE_185_RECONCILED_V ,
-
View: CE_222_REVERSAL_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_222_REVERSAL_V, object_name:CE_222_REVERSAL_V, status:VALID, product: CE - Cash Management , description: AR receipts for reversing or unclearing , implementation_dba_data: APPS.CE_222_REVERSAL_V ,
-
View: CE_222_REVERSAL_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_222_REVERSAL_V, object_name:CE_222_REVERSAL_V, status:VALID, product: CE - Cash Management , description: AR receipts for reversing or unclearing , implementation_dba_data: APPS.CE_222_REVERSAL_V ,
-
View: CE_801_EFT_RECONCILED_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_801_EFT_RECONCILED_V, object_name:CE_801_EFT_RECONCILED_V, status:VALID, product: CE - Cash Management , description: Reconciled Payroll payments for unreconciling , implementation_dba_data: APPS.CE_801_EFT_RECONCILED_V ,
-
View: CE_185_RECONCILED_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_185_RECONCILED_V, object_name:CE_185_RECONCILED_V, status:VALID, product: CE - Cash Management , description: Reconciled Treasury transactions for unreconciling via Open Interface , implementation_dba_data: APPS.CE_185_RECONCILED_V ,
-
View: CE_999_TRANSACTIONS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_999_TRANSACTIONS_V, object_name:CE_999_TRANSACTIONS_V, status:VALID, product: CE - Cash Management , description: Available transactions for reconciliation via Open Interface , implementation_dba_data: APPS.CE_999_TRANSACTIONS_V ,
-
View: CE_999_RECONCILED_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_999_RECONCILED_V, object_name:CE_999_RECONCILED_V, status:VALID, product: CE - Cash Management , description: Reconciled transactions for unreconciling via Open Interface , implementation_dba_data: APPS.CE_999_RECONCILED_V ,
-
View: CE_999_TRANSACTIONS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_999_TRANSACTIONS_V, object_name:CE_999_TRANSACTIONS_V, status:VALID, product: CE - Cash Management , description: Available transactions for reconciliation via Open Interface , implementation_dba_data: APPS.CE_999_TRANSACTIONS_V ,
-
View: CE_101_RECONCILED_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_101_RECONCILED_V, object_name:CE_101_RECONCILED_V, status:VALID, product: CE - Cash Management , description: Reconciled GL journals for unreconciling , implementation_dba_data: APPS.CE_101_RECONCILED_V ,
-
View: CE_999_RECONCILED_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_999_RECONCILED_V, object_name:CE_999_RECONCILED_V, status:VALID, product: CE - Cash Management , description: Reconciled transactions for unreconciling via Open Interface , implementation_dba_data: APPS.CE_999_RECONCILED_V ,
-
View: CE_101_RECONCILED_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_101_RECONCILED_V, object_name:CE_101_RECONCILED_V, status:VALID, product: CE - Cash Management , description: Reconciled GL journals for unreconciling , implementation_dba_data: APPS.CE_101_RECONCILED_V ,
-
View: CE_260_CF_RECONCILED_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_260_CF_RECONCILED_V, object_name:CE_260_CF_RECONCILED_V, status:VALID, product: CE - Cash Management , description: Reconciled cashflow receipts and payments for unreconciling , implementation_dba_data: APPS.CE_260_CF_RECONCILED_V ,
-
View: CE_260_CF_RECONCILED_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_260_CF_RECONCILED_V, object_name:CE_260_CF_RECONCILED_V, status:VALID, product: CE - Cash Management , description: Reconciled cashflow receipts and payments for unreconciling , implementation_dba_data: APPS.CE_260_CF_RECONCILED_V ,
-
View: CE_200_TRANSACTIONS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_200_TRANSACTIONS_V, object_name:CE_200_TRANSACTIONS_V, status:VALID, product: CE - Cash Management , description: Available AP payments for reconciliation or clearing , implementation_dba_data: APPS.CE_200_TRANSACTIONS_V ,
-
View: CE_222_RECONCILED_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_222_RECONCILED_V, object_name:CE_222_RECONCILED_V, status:VALID, product: CE - Cash Management , description: Reconciled AR receipts for unreconciling , implementation_dba_data: APPS.CE_222_RECONCILED_V ,
-
View: CE_200_TRANSACTIONS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_200_TRANSACTIONS_V, object_name:CE_200_TRANSACTIONS_V, status:VALID, product: CE - Cash Management , description: Available AP payments for reconciliation or clearing , implementation_dba_data: APPS.CE_200_TRANSACTIONS_V ,
-
View: CE_222_RECONCILED_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CE.CE_222_RECONCILED_V, object_name:CE_222_RECONCILED_V, status:VALID, product: CE - Cash Management , description: Reconciled AR receipts for unreconciling , implementation_dba_data: APPS.CE_222_RECONCILED_V ,