My Oracle Support Banner

ECM: BANK_STMT_TBL BNK_ID_NBR not being loaded during TR_BSP_LOAD process (Doc ID 1357305.1)

Last updated on DECEMBER 01, 2020

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




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

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