| layout | default |
|---|---|
| title | CE Bank Statement Import Execution | Oracle EBS SQL Report |
| description | Application: Cash Management Source: Bank Statement Import Execution Report Short Name: CEIMPERR DB package: CECEXINERRXMLPPKG |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, BI Publisher, Enginatics, R12 only, Bank, Statement, Import, Execution, ce_statement_headers_int, ce_lookups, ce_bank_accts_gt_v |
| permalink | /CE%20Bank%20Statement%20Import%20Execution/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Application: Cash Management Source: Bank Statement Import Execution Report Short Name: CEIMPERR DB package: CE_CEXINERR_XMLP_PKG
Bank Name, Bank Branch Name, Bank Account Name, Bank Account Number, Statement Number From, Statement Number To, Statement Date From, Statement Date To, Show Warnings/Errors Only
ce_statement_headers_int, ce_lookups, ce_bank_accts_gt_v, ce_bank_branches_v, ce_statement_headers, ce_statement_lines, ar_cash_receipts_all, ar_cash_receipt_history_all, ce_statement_reconcils_all, ce_reconciliation_errors, ce_header_interface_errors
BI Publisher, Enginatics, R12 only
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
| Resource | Link |
|---|---|
| Excel Example Output | CE Bank Statement Import Execution 22-Feb-2022 234911.xlsx |
| Blitz Report™ XML Import | CE_Bank_Statement_Import_Execution.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/ce-bank-statement-import-execution/ |
The CE Bank Statement Import Execution report is a technical and operational log of the bank statement import process. When bank statements (BAI2, MT940, etc.) are loaded into Oracle, this report tracks the success or failure of that interface process. It highlights specific errors (e.g., "Invalid Account Number", "Duplicate Statement"), allowing the technical team or cash users to troubleshoot and correct the data before attempting to re-import.
Automated bank statement import is critical for daily cash visibility. However, file format changes, invalid characters, or configuration mismatches can cause imports to fail.
- Silent Failures: Without a clear report, a missing statement might go unnoticed until month-end.
- Troubleshooting: Error messages in the standard log file can be cryptic or hard to parse.
- Data Integrity: Ensuring that the file was loaded completely (header and all lines) is essential before starting reconciliation.
This report queries the interface and error tables to provide a readable summary of the import execution.
Key Features:
- Error Filtering: Option to "Show Warnings/Errors Only" to focus immediately on problems.
- Interface Visibility: Shows data sitting in the interface tables (
CE_STATEMENT_HEADERS_INT) that failed to load into the main tables. - Detailed Messages: Displays the specific error message (e.g., "Bank Account not defined") associated with each failed line or header.
The report checks CE_HEADER_INTERFACE_ERRORS and CE_RECONCILIATION_ERRORS linked to the statement interface tables.
Key Tables:
CE_STATEMENT_HEADERS_INT: The staging table for incoming statements.CE_HEADER_INTERFACE_ERRORS: Stores validation errors for the statement header.CE_RECONCILIATION_ERRORS: Stores errors related to the auto-reconciliation process (if triggered during import).CE_BANK_ACCOUNTS: To validate the account number in the file.
- System Reliability: Ensures that bank data feeds are monitoring and maintained.
- Rapid Resolution: Helps IT and Treasury quickly identify why a file failed (e.g., "New bank branch code in file") and fix the setup.
- Process Assurance: Confirms that the daily cash data has been successfully loaded and is ready for reconciliation.
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics