PLS:00201: identifier 'FND_FILE.LOG' must be declared


Solution steps.

 SQL> show user;

USER is "APPS"

SQL>GRANT execute ON APPS.FND_FILE TO cust_schema;

SQL> show user;

USER is "cust_schema"

SQL>

SQL> CREATE OR REPLACE SYNONYM FND_FILE FOR APPS.FND_FILE;

Synonym created.


I hope issue has been resolved.

 

Size of schema in Oracle database 23AI

  How to find the size of schema in the 23AI ORACLE Database. SQL>  select sum(bytes)/1024/1024 "SIZE_IN_MB" from dba_segments;...