Skip to main content
Question

The following error occurs during the service upgrade from version 25.1.4 to 25.1.10: ORA-01720: Grant option does not exist for 'SYS.DBA_DIRECTORIES'.

  • June 30, 2026
  • 0 replies
  • 3 views

Forum|alt.badge.img

!!!Error deploying file fndbas/Database.apv
!!!Error creating VIEW ORACLE_DIRECTORIES
CREATE OR REPLACE VIEW ORACLE_DIRECTORIES AS
SELECT d.directory_name,
       d.directory_path,
       Database_SYS.Is_Valid_Oracle_Directory(d.directory_name) directory_exists
FROM   dba_directories d
WHERE  EXISTS (SELECT 1 
               FROM dba_tab_privs p
               WHERE d.directory_name = p.table_name
               AND d.owner = p.owner
               AND type = 'DIRECTORY'
               AND p.grantee IN ('PUBLIC', Fnd_Session_API.Get_App_Owner))
WITH   READ ONLY

ORA-01720: grant option does not exist for 'SYS.DBA_DIRECTORIES'
 

Apart from this error, several other instances of the following error were also observed:

ORA-01720: Grant option does not exist.