Saturday, December 17, 2022

INVALID_PATH: File location or filename was invalid(UTL_FILE) in Oracle APPS

1. Create Directory using below command

CREATE OR REPLACE directory XXDIR AS '/home/erp';

--Here change directory path(/home/erp) according to your path.

Give the required permissions to above path.

2. Connect to WinSCP/Putty and Create directory.

3. Now use the directory name in utl_file 

UTL_FILE.FOPEN('XXDIR ','file_name','R');


No comments:

Post a Comment

Query to get the list of contexts for each formula type in Oracle Fusion HCM

select t.base_formula_type_name ,      ttl.formula_type_name ,      ttl.description ,      c.base_context_name from   ff_formula_types_b t ,...