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

    888665

      Team,

       

      Below is my EBS R12 Product info

      Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

      PL/SQL Release 12.1.0.2.0 - Production

      "CORE 12.1.0.2.0 Production"

      TNS for Linux: Version 12.1.0.2.0 - Production

      NLSRTL Version 12.1.0.2.0 - 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 ?