Gather schema stats is failing for custom schema in EBS 12.1.3

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

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?