We have a custom API in IFS Cloud. We also have a website that uses an Apache server and is connected to IFS.
After we make changes to the custom API, the API commits successfully and does not give any error. However, the website shows an error. The error message is very general.
After we update the API in the evening, the website gives an error the next morning. During the day, the problem fixes itself.
Error Message :
ChatGPT said it might be a cache problem. It suggested the following code:
BEGIN
Fnd_Cache_API.Clear_All;
END;
It also suggested restarting Apache, because Apache or the middleware may cache the database connection pool. Old prepared statements may remain.
When we restart, unfortunately the error still continues.
Is there a script that can fix the error immediately?
Has anyone experienced a situation like this before?
How can we solve this problem?