Solution:
a. Rename the data file so that it does not have spaces in it.
b. FTP the file to a directory on your server without spaces in the directory name.
c. Run the Bank Statement Loader process again, designating the file name without spaces and the
directory on your server without spaces.
d. Confirm you no longer get the LRM-00112 error.
Since this concurrent request runs on the server, it operates with respect to the directories defined on the server. Thus, it is not possible to load a file from another location unless it is setup/mapped as a directory on your server.
Ref:Bank Statement Loader Program Errors as LRM-00112 and SQL*Loader-100 [ID 433580.1]
Search This Blog
Subscribe to:
Post Comments (Atom)
Transportable tablespace refresh
1.check tablespace for the user which need to refresh ------------------------------------------------------------------- SQL> select ...
-
Issue - When recovering database until SCN, recovery failed with error RMAN-03002 and RMAN-06556 using channel ORA_DISK_8 RMAN-00571: ...
-
Issue - We are not able to migrate the concurrent programs from one to another environment using FNDLOAD UPLOAD. i.e. from DEV to PROD...
-
FNDLOAD - Uploading from the data file XXB_CONC.ldt The file XXB_CONC.ldt could not be opened for reading Issue - [applmgr@xxora-app UPLOAD...
This comment has been removed by the author.
ReplyDeleteI have facing same issue at time of working on Auto lock process ,with the help above document. I have resolved issue
ReplyDeleteThis help me. My file name was having spaces in the data file.
ReplyDelete