ECM: BANK_STMT_TBL BNK_ID_NBR not being loaded during TR_BSP_LOAD process
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