1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

unable to open .ctl file

Discussion in 'Oracle SCM & Manufacturing' started by naresh5430, May 7, 2014.

  1. naresh5430

    naresh5430 Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    While submitting the sql*loader report ,it is showing that unable to open.Even though everything is correct.
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    735
    Likes Received:
    145
    Trophy Points:
    830
    Location:
    Russian Federation
    Your OS?
    Provide additional information: CTL file name, whether isn't present special characters in the name
     
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,176
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    where it shows unable to open? In log file?
     
  4. naresh5430

    naresh5430 Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    while submitting a conc.program.
     
  5. jagadekara

    jagadekara Forum Guru

    Messages:
    1,176
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Pulivendula
    is there any parameters?, If yes which value you gave for parameters?
     
  6. naresh5430

    naresh5430 Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    windows 2003 and file name is ITEM_CAT.ctl
     
  7. jagadekara

    jagadekara Forum Guru

    Messages:
    1,176
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Where you placed your ITEM_CAT.ctl in server? I mean which path?
     
  8. naresh5430

    naresh5430 Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    no parameters at all
     
  9. rajenb

    rajenb Forum Expert

    Messages:
    368
    Likes Received:
    114
    Trophy Points:
    655
    Location:
    Mauritius
    Hi Naresh(5430),

    Few things to check from your side:

    1) From which responsibility are you running the conc. req. => find the associated Application (I suppose it's some custom application "XX" or may be "Inventory").

    2) The ITEM_CAT.ctl should normally be placed in the $XX_TOP/bin directory (or $INV_TOP/bin directory if it's "Inventory" for example).

    Regards,
    Rajen.