Gather schema stats is failing for custom schema in EBS 12.1.3

[Raja]

hi Erman

hope you are doing good. In our environment concurrent program "gather Schema Statistics" is failing only for custom schema with error
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
In GATHER_SCHEMA_STATS , schema_name= XXFDS percent= 100 degree = 8 internal_flag= NOBACKUP
Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=XXFDS.FDE_CONCUR_SAE_IMPORT***ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file Concur_SAE_Import.txt in FDS_DIR_TOP_IN not found***
Error #2: ERROR: While GATHER_TABLE_STATS:
object_name=XXFDS.FDE_EXTERNAL_CONTINGENT***ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file FD_Contingent_Worker_Details.csv in FDS_DIR_TOP_IN not found***
Error #3: ERROR: While GATHER_TABLE_STATS:
object_name=XXFDS.FDE_PAY_RECON_PAYROLL***ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file PayrollRec.txt in FDS_DIR_TOP_IN not found***
Error #4: ERROR: While GATHER_TABLE_STATS:
object_name=XXFDS.FDE_TALEO_NEW_HIRES***ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file OnboardingCompletedExport.csv in FDS_DIR_TOP_IN not found***
Error #5: ERROR: While GATHER_TABLE_STATS:
object_name=XXFDS.FDT_STORE***ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file FF_STORE.txt in FDS_DIR_TOP_IN not found***
Error #6: ERROR: While GATHER_TABLE_STATS:
object_name=XXFDS.FDT_STORE_INVENTORY_HISTORY***ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file FF_STORE_INV.txt in FDS_DIR_TOP_IN not found***
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


Whereas for other schemas such as AR,HR,APPS, it is completing normal. Not sure why the program is looking for the files which are not present anymore under FD_DIR_TOP_IN directory. Any clue?

[ErmanArslansOracleBlog]

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.

[Raja]

Thanks Erman. That was helpful in my case.