ECM: BANK_STMT_TBL BNK_ID_NBR not being loaded during TR_BSP_LOAD process

(Doc ID 1357305.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

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


When the BAI2 Code Mappings 'Return Import if No Match' box is not checked, the Bank Import file process does not load the BANK_STMT_TBL.BNK_ID_NBR that is included in the file being loaded.

1. Through BAI2 Code Mappings, make sure the 'Return Import if No Match' box is not checked and populate 'Default Value' fields
2. Load BAI2 file
3. IMPORT_FILES is a Success but TR_BP_LOAD has a Warning
4. Warning Message:  Account xxxxxxxxx does not exist for Bank. Statement has been uploaded.
5. BANK_STMT_TBL.BNK_ID_NBR is blank but number is in the file that is loaded

BANK_STMT_TBL.BNK_ID_NBR should be populated with the bank number provided in the file.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms