Re: Gather schema stats is failing for custom schema in EBS 12.1.3

Posted by ErmanArslansOracleBlog on Apr 25, 2017; 7:29am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Gather-schema-stats-is-failing-for-custom-schema-in-EBS-12-1-3-tp2587p2588.html

Hi,

Please check this note:

ORA-20011 ORA-29913 and ORA-29400 with Associated KUP-XXXXX Errors from DBMS_STATS.GATHER_STATS_JOB (Doc ID 1274653.1)

Note that, gather schema statistics executes FND_STATS. FND_STATS is the package delivered with EBS used for gathering statistics.. However, FND_STATS interacts with DBMS_STATS, but it has EBS-specific knowledge about the type of the statistics and methods for gathering statistics specifically for EBS database objects.