User has attached a new document but get a HIG-0543 error when trying to view it.
The application cannot open file in the Location directory.
Oracle OS user must have read and write privileges on the OS directory.
The database path (in screenshot it is d:\attachments\) must be accessible by UTL_FILE_DIR parameter on the database itself. You can select this value by running following script
select * from v$parameter where name='utl_file_dir';
Please note if the script above brought back the * character then all folders are available (but this is not recommended to keep all folders accessible) and there is no need to follow steps provided below.
If necessary add missing privileges or update UTL_FILE_DIR parameter.
How to change UTL_FILE_DIR parameter: If your Database initialization parameters are stored in SPFILE (user can check this by running following script
SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" FROM sys.v_$parameter WHERE name = 'spfile';)
please follow steps below: a. set UTL_FILE_DIR using syntax below:
ALTER SYSTEM SET utl_file_dir='d:\attachments\' SCOPE=SPFILE;
b. restart the Oracle DB instance from DB server.