Import Bank Statements - Some Control Fields are Missing for BAI2 Data File Format (Doc ID 810860.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Problem Statement:

For BAI2 bank statement files containing multiple statements, the control totals were being loaded properly for the first statement in the file but for the subsequent statements, the control values were not always properly loaded.

Field which does not populate are control_total_dr, control_total_cr, control_dr_line_count, and control_cr_line_count fields in CE_STATEMENT_HEADERS_INTERFACE table.

Steps To Reproduce:

1)Load a bank statement file with header information in multiple lines.

2)The record id xx should have the transaction code presents in the current line and its
values continued in the next line.

3)The bank statement file should populate control_total_dr, control_total_cr, control_dr_line_count, and
control_cr_line_count in CE_STATEMENT_HEADERS_INTERFACE table.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.