Re: temporary files

Posted by ErmanArslansOracleBlog on Apr 23, 2021; 7:38am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/temporary-files-tp8513p9661.html

Hi Latifa,

Thanks :)

*What is the filesystem that are using ? ( for the directories used in utl_file_dir)

*Do you have any other EBS instance running in the same servers?

*Do you have any incorrect directory present in utl_file_dir?

*Do you see the file reported in the error is present there? After getting the error, when you check the file is it present or not?

*What is the DB Version -> There is an event to be set in 19C (CDB level)

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) -- To enable the UTL_FILE functionality on which the supplemental UTL_FILE_DIR parameter depends, ensure that you have set the following event at the CDB level in your database initialization parameters: event='10946 trace name context forever, level 8454144'

*What is the actual thing that is failing and reporting this error? For instance: "Maintenance Work Order Detail Report"

*Are you aligned with the conf given in 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)?