We are using Oracle EBS R12 and for a custom module, wanted to log the Oracle seeded API outputs to custom log files for later scrutiny & error corrections.
Following the standard procedure, create the folder like below
create or replace directory OMS_LOGS as '/u01/applmgr/oms_logs'
and started testing the directory using SQL Developer where I am logged in as APPS user
I kept getting the below errors
ERROR at line 1:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
ORA-06512: at line 8
and the detailed errors said this could be due to OS level access permissions. Luckily I landed on a stackoverflow discussion & one of the answers clearly said this error “could” be due to the file/folder permissions for user “oracle”.
As “root” I changed the permissions for the path “/u01/applmgr/oms_logs” like below
chmod g+w /u01/applmgr/oms_logs
and that fixed the invalid file operation errors. Hope this helps someone out there!