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!

Host program output to concurrent standard output

Discussion in 'Oracle HRMS & Payroll' started by Margo, Oct 16, 2015.

  1. Margo

    Margo Starter

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    RF, Moscow
    Hi!
    I have the following scenario - I run concurrent with host program which is shell script, from this scrip I call unnamed pl/sql block. In side this block I run pl/sql procedure. I want to make output of this procedure be my conccurrent output.
    I use fnd_file.put(apps.fnd_file.output, <...>)
    with setting dir and file_name like this
    fnd_file.put_names(p_out => l_out, p_dir => l_dir, p_log => l_log);
    dir and file name I take from fnd_concurrent_requests. But it doesn't work, I get error
    ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.
    Directory &FILE_DIR is invalid, contact your system administrator.
    Action: Check that the directory is a valid directory with write permissions on
    the database server node and is listed under utl_file_dir para
    So the question is - how to make it? Is there workaround?
    Thank you in advance
     
  2. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Why not just submit the job as an additional concurrent request from the host program?
     
  3. Margo

    Margo Starter

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    RF, Moscow
    Submitting it as concurrent means customer should search for that new concurrent to open output. And I suspect they will not be happy with it.
     
  4. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    What if you make it a Concurrent Request Set? Assuming those haven't vanished...
     
  5. Margo

    Margo Starter

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    RF, Moscow
    Conc set again means getting output not from concurrent you ran but from another one.
    But finally the problem was solved - in host program just after main pl/sql stored prog I make select from log table wrapping each field in xml tag and redirect it to the output. The trick is to make sqlplus seetings so no other lines are in the output. That gives us a XML feed for xsl-template attached to the concurrent as its type is set as XML.
    Hope you understand what I mean.
    Thank you anyway for the assisnace.