Search This Blog

Tuesday, September 19, 2017

FNDLOAD - Uploading from the data file XXB_CONC.ldt The file XXB_CONC.ldt could not be opened for reading


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]$ FNDLOAD apps/xxxx 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct _CONC.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
Log filename : L9021287.log
Report filename : O9021287.out

[applmgr@xxora-app UPLOAD]$ cat L9021287.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
 module:
+---------------------------------------------------------------------------+
Current system time is 19-SEP-2017 11:44:09
+---------------------------------------------------------------------------+
Uploading from the data file XXB_CONC.ldt
The file XXB_CONC.ldt could not be opened for reading
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 19-SEP-2017 11:44:09
+---------------------------------------------------------------------------+

Action plan -
Verified the file permissions, it has full permission
[applmgr@xxora-app UPLOAD]$ ls -ltr
total 92
-rwxrwxrwx 1 applmgr dba 24914 Sep 19 09:43 XXB_CONC.ldt

Observed the file in DOS format and converted to UNIX

[applmgr@xxora-app UPLOAD]$ dos2unix XXB_CONC.ldt
[applmgr@xxora-app UPLOAD]$ file XXB_CONC.ldt
XXB_CONC.ldt: ASCII text
dos2unix: converting file XXB_CONC.ldt to UNIX format ...
[applmgr@xxora-app UPLOAD]$ FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXB_CONC.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
Log filename : L9021288.log
[applmgr@xxora-app UPLOAD]$ cat L9021288.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
 module:
+---------------------------------------------------------------------------+
Current system time is 19-SEP-2017 11:46:16
+---------------------------------------------------------------------------+
Uploading from the data file XXB_CONC.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dump from LCT/LDT files (/applmgr/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.2), XXB_CONC.ldt) to stage tables
Dump LCT file /applmgr/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.2) into FND_SEED_STAGE_CONFIG
Dump LDT file XXB_CONC.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (EXECUTABLE _  , PROGRAM _  ) into FND_SEED_STAGE_ENTITY
Upload from stage tables
+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 19-SEP-2017 11:46:18
+---------------------------------------------------------------------------+
Report filename : O9021288.out

No comments:

Post a Comment

Transportable tablespace refresh

  1.check tablespace for the user which need to refresh -------------------------------------------------------------------  SQL> select ...