{"id":7131,"date":"2021-08-06T13:12:48","date_gmt":"2021-08-06T13:12:48","guid":{"rendered":"https:\/\/rax-stg-wp-aws.com\/blogs\/using-supplemental-utl_file_dir-in-ebs-release-12-with-19c-database\/"},"modified":"2026-11-03T19:27:54","modified_gmt":"2026-11-03T19:27:54","slug":"using-supplemental-utl_file_dir-in-ebs-release-12-with-19c-database","status":"publish","type":"blogs","link":"https:\/\/www.rackspace.com\/en-gb\/blogs\/using-supplemental-utl_file_dir-in-ebs-release-12-with-19c-database\/","title":{"rendered":"Using supplemental utl_file_dir in EBS Release 12 with 19c database"},"content":{"rendered":"

The Oracle E-Business suite uses OS level directories for PL\/Sql File I\/O<\/em> for many different tasks such as generating temporary files, debugging files, log and output files etc. This PL\/Sql File I\/O  <\/em>is generally done using utl_file<\/em> or fnd_file<\/em> packages. However, starting with 18c version of the database, Oracle has de-supported the utl_file_dir<\/em> parameter. 
\nHence, to tackle this limitation in E-Business Suite product, Oracle introduced a supplemental utl_file_dir<\/em> parameter. Oracle introduced new views apps.v$parameter<\/em> and apps.v$parameter2<\/em>, which provides and stores this new supplemental utl_file_dir<\/em> feature. <\/p>\n

In this blog, we will review how to use this new supplemental utl_file_dir <\/em>feature in EBS R12 with a 19c database.<\/p>\n

Before database release 12c and earlier, the initialization parameter utl_file_parameter<\/em> was used to deal with PL\/Sql related File I\/O. To add a new path to have PL\/Sql enabled File I\/O, it was essential to add the OS path in the utl_file_dir parameter list and bounce the database. Only then developers could use that path in the EBS programs to perform File I\/O using utl_file<\/em> or fnd_file<\/em> packages.Once the OS directory path was added to the utl_file_parameter<\/em>, one could use the packages such as utl_file<\/em> and fnd_file<\/em> for PL\/Sql File I\/O. <\/p>\n

\nThe following given image shows some example outputs of how one could perform PL\/Sql File I\/O once utl_file_dir <\/em>was enabled.<\/p>\n

\"utl<\/p>\n

Now, starting with 19c database, to add\/modify\/delete an OS directory path for PL\/Sql File I\/O with EBS R12, you need to use script txkCfgUtlfileDir.pl<\/em> provided under $ORACLE_HOME\/appsutil<\/em> path. This same script is also used to migrate these directory paths during the upgrade also (from 12c or earlier versions) to the 19c database. 
\nThe following steps cover how to add\/modify\/delete a directory path to supplemental utl_file_dir<\/em>. 
\nYou need to enable the below event as a database initialization parameter at the CDB level to enable this feature.<\/p>\n

                                  event=’10946 trace name context forever, level 8454144′<\/em><\/p>\n

1. To add\/modify\/delete a directory path in the supplemental utl_file_dir<\/em> parameter, you need to complete the following steps in a sequence:<\/p>\n

Get the list of directory paths which currently exist in the supplemental utl_file_dir<\/em> parameter. You need to source the PDB environment and then run script txkCfgUtlfileDir.pl<\/em> in getUtlFileDir<\/em> mode. 
\n 
\n          $ . Run the following command $ORACLE_HOME\/<pdb_name>_<hostname>.env
\n          $ perl $ORACLE_HOME\/appsutil\/bin\/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE \\
\n          -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME\/appsutil\/log -mode=getUtlFileDir –                            servicetype=onpremise<\/em><\/p>\n

This script creates a text file named <PDBNAME>_utlfiledir.txt<\/em> in the <ORACLE_HOME>\/dbs<\/em> directory which lists the existing directories defined in the supplemental utl_file_dir<\/em> list. This step reads the contents from apps.v$parameter<\/em> and populates these to the file $ORACLE_HOME\/dbs\/<PDBNAME>_utlfiledir.txt<\/em>.<\/p>\n

2. Edit the text file $ORACLE_HOME\/dbs\/<PDBNAME>_utlfiledir.txt<\/em> to add, modify or delete the OS directory path as per your requirement. Also verify that the new directory path is created\/exists at the OS level and it should not have any soft links, as soft links in directory paths have also been deprecated in 19c version.<\/p>\n

3. Now run the txkCfgUtlfileDir.pl<\/em> script again in setUtlFileDir<\/em> mode now to update the value of the supplemental utl_file_dir<\/em>.<\/p>\n

                                           $ . $ORACLE_HOME\/<pdb_name>_<hostname>.env<\/em><\/p>\n

                                         $ perl $ORACLE_HOME\/appsutil\/bin\/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME\/appsutil\/log -mode=setUtlFileDir -servicetype=onpremise|opc<\/em><\/p>\n

This step updates the apps.v$parameter <\/em>view with the values available in file $ORACLE_HOME\/dbs\/<PDBNAME>_utlfiledir.txt.<\/em><\/p>\n

4. <\/em>Now you can sync these values with the DB tier context file using the following:<\/p>\n

                                      $ . $ORACLE_HOME\/<pdb_name>_<hostname>.env<\/em><\/p>\n

                                     $ perl $ORACLE_HOME\/appsutil\/bin\/txkCfgUtlfileDir.pl                                     –                                                      contextfile=$CONTEXT_FILE \\
\n                                  -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME\/appsutil\/log –                                                              mode=syncUtlFileDir -servicetype=onpremise<\/em><\/p>\n

You can verify the changes to supplemental utl_file_dir<\/em> using a select query output from apps.v$parameter<\/em> or apps.v$parameter2<\/em> like below:<\/p>\n

Select value from apps.v$parameter<\/em> where name=’utl_file_dir’<\/em>;<\/p>\n

The above steps also create a corresponding entry for directory objects in dba_directories<\/em>. Once the above steps are completed, a new directory path added to the supplemental utl_file_dir<\/em> will be available for use by E-Business programs. <\/p>\n

Conclusion<\/strong><\/p>\n

One good advantage of this feature is that in database releases 12c and earlier versions, database bounce was needed whenever one needed to add\/modify\/delete a path in the utl_file_dir<\/em> parameter. However, no downtime is needed while adding\/deleting\/modifying the path in the supplemental utl_file_dir<\/em> list in 19c. <\/p>\n

Also, please note that the two new views (i.e., apps.v$parameter<\/em> and apps.v$parameter2<\/em>) required for this new feature have been introduced in the APPS schema. So the steps mentioned above are particular only for Oracle E-Business Suite Release 12 applications (i.e., 12.1.3 and 12.2).<\/p>\n

 <\/p>\n

References <\/strong><\/p>\n

Using UTL_FILE_DIR or Database Directories for PL\/SQL File I\/O in Oracle E-Business Suite Releases 12.1 and 12.2 (Doc ID 2525754.1)<\/p>\n","protected":false},"excerpt":{"rendered":"

Using supplemental utl_file_dir in EBS Release 12 with 19c database<\/p>\n","protected":false},"author":2,"featured_media":7133,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","meta":{"content-type":"","nid":"26271","content_type":"blog","created_by":"10130","authored_on":"2023-11-21T14:12:48+00:00","field_article_industries":"","tag_category":"Technical","field_blog_author_text":"By Manoj Chawla, Oracle Applications Database Administrator, Rackspace Technology","seo_description":"Dive into using the new supplemental utl_file_dir feature in EBS R12 with a 19c database, a critical update for handling PL\/Sql File I\/O.\r\n","field_featured_image":"","insights_image":"\/wp-content\/uploads\/2026\/blog_technical_images\/26271-insights_image-oracle-technical-blog-1-insights.jpg","field_partners":"","rxt_platforms":"Oracle","product":"","publisheddate":"2021-08-06T13:12:48","rxt_solutions":"Databases","opengraph_tag":"","x_tag":"","teaser_flag":"Technical Blog","seo_titile":"utl_file_dir Oracle R12 with 19c db | Rackspace Technology","field_topics":"","field_slug":"using-supplemental-utl_file_dir-in-EBS-Release-12-with-19c-database","footnotes":""},"categories":[178],"tags":[204],"class_list":["post-7131","blogs","type-blogs","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-technical"],"_links":{"self":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs"}],"about":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/types\/blogs"}],"author":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/comments?post=7131"}],"version-history":[{"count":2,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7131\/revisions"}],"predecessor-version":[{"id":9025,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7131\/revisions\/9025"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media\/7133"}],"wp:attachment":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media?parent=7131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/categories?post=7131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/tags?post=7131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}