FND-CP-ESP: Child: exec:: No such file or directory

This error occurred when we executed shell script using Concurrent Program.

Solution

Execute the below command in Unix Environment.

dos2unix filename.prog

SQL Loader: Field in data file exceeds maximum length

Field in data file exceeds maximum length

The default length of datatype CHAR is 255 in SQLLDR.

Instead of the following
-----------------
COL1 CHAR,
COL2 CHAR,
-----------------

Please change into
-----------------
COL1 CHAR(1000) NULLIF COL1=BLANKS,
COL2 CHAR(4000) NULLIF COL2=BLANKS,
-----------------