ATP Data Collections failure in Planning ODS Load worker
We are on R12.2.5 and have a decentralized ASCP instance. Our EBS instance runs ATP Data Collections daily and intermittently one of the Load Workers fails, and it is always the same error---nothing else is found in any log files either on db or apps side....
**Starts**10-FEB-2020 23:04:42
**Ends**11-FEB-2020 01:20:34
Timeout error.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
The name in GET_MY_COMPANY :My Company
************************************************************
Bad sqls for this session
How can we troubleshoot this issue? Where is the ODS Load looking for those details and how can we identify to correct?
Thank you,
Paula