STAT Oracle EBS Agent even though it is in Debug mode there is not much information.
other than STAT Agent connection is verified -
YSDATE, AGENT_MODE = 'debug' WHERE SD_CD = '54')
2017-05-31 16:24:20 TRACE - SQL: UPDATE MERC_WAKE SET UPDATE_DT = SYSDATE, AGENT_MODE = 'debug' WHERE SD_CD = '54'
2017-05-31 16:24:20 TRACE - Processed 1 rows
2017-05-31 16:24:20 DEBUG - commit(-1)
2017-05-31 16:24:20 TRACE - Committing transaction
2017-05-31 16:24:20 DEBUG - Stat Agent connection verified
We installed AP, PO and GL modules.
Stat EBS Agent status is always "Responding".
When we try to add setup object to a CSR we see a pop-up box "Fetch is in progress. To Cancel, press cancel button". This pop-up doesn't go away and it just stays there.
Once we bounce the STAT agent it starts to work fine. After sometime users complain again and we had to bounce the agent to resolve the issue.
We have another team ie; using STAT with EOS different STAT instance. They raised similar issue.
At that time we mentioned we do not have issues. After installing EOS on our instance we are seeing similar issues.
After installing the EOS objects did you make them "Active". Check under: Maintenance | General | Object Types and verify the newly installed objects are checked as "Active"
Had a similar problem and I am thinking maybe your Stat EBS Agent JVM needs more memory. Check under STAT_HOME/bin file: statctl.sh. I increased the 2nd line below to correct my issue from -Xms256m -Xmx512m to the values list below. Restart the agent after making the change.
DBA made the changes. When we try to migrate AP Financial options, Migrate Object status is showing as "Received by Agent" and the agent is not busy as this is the only migration that is running. Migration console shows "In Process".
Also when I try to create a new CSR and add AOL Profile Option I see the pop-up "Fetch is in progress. To Cancel, press cancel button" indicates to me that Agent is hanging again.