!!!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.