6 Replies Latest reply on Jun 18, 2019 8:16 PM by user4102617

    Oracle EBS - Write Concurrent Program output data in custom location on application tier




      Below is my EBS R12 Product info

      Oracle Database 12c Enterprise Edition Release - 64bit Production

      PL/SQL Release - Production

      "CORE Production"

      TNS for Linux: Version - Production

      NLSRTL Version - Production



      When ever we run concurrent program (of executable type is PLSQL...) and wanted to write data into file system below are the two options,


           1. Use FND utilities to write data output to a file on application tier via FND_LOG & FND_OUT , and these files are stored under $APPLCSF/out and $APPLCSF/log

           2. Utilize UTL_FILE which will create file on database server.


      My requirement is are there any seeded utilities provided by Oracle (or custom approaches) apart from the above to generate files on application tier in specific custom locations / paths ?