My Oracle Support Banner

ECM: Import Bank Statements process, IMPORT_FILES, Warning "The calculated group total is 100000000000 and 100000800000 was stated on the file (0,0)" (Doc ID 2698699.1)

Last updated on AUGUST 07, 2020

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Import Bank Statements process, IMPORT_FILES, ends in Warning

WARNING MESSAGE:
The account total does not match what was stated in the file. The error occurred with Bank ID "XXXXX XXXX" and Account Number "XXXXXXXX".
The calculated group total is 100000000000 and 100000800000 was stated on the file (0,0)

STEPS:
1. Import BAI2 file: Banking > bank Statements > Import Bank Statements
    File Path populated
    File Name defined
    Statement Type = Previous Day
    Layout = BAI2
    Layout Properties: BNK_ID_LOCATION Value = 02
    CODE_MAP_GROUP = box checked for Allowed Values, Value = BAI2

2. IMPORT_FILES App Engine ends in Warning: The account total does not match what was stated in the file. The error occurred with Bank ID "XXXXX XXXX" and Account Number "XXXXXXXX".
    The calculated group total is 100000000000and 100000800000 was stated on the file (0,0)

3. Message Log shows that there is difference of ‘800000’ between PeopleSoft calculated sum and value in 49 record.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


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