Can't use a wild card or wild cards in Data File Name Parameter for Bank Statement Loader Progrm
We receive bank statement data files from a major bank with the file naming convention.
PDCLMT940.F0006414.Timestamps.txt
Entered a file name in the data file name parameter for the Bank Statement Loader in this format: PDCLMT940.*.*.txt as recommended by a note in Oracle Support, but the program failed with the following error:
SQL*Loader-500: Unable to open file (/FileDirectory/PDCLMT940*.txt) SQL*Loader-553: file not found SQL*Loader-509: System error: No such file or directory
Has anyone encountered this issue as well?