FRM-40401 Error

From: Robert D. Perry <rdperry_at_gowebway.com>
Date: 8 Aug 2003 06:30:08 -0700
Message-ID: <e4fbf364.0308080530.7d5160bf@posting.google.com>

We are experiencing FRM-40401 errors in our production environment. When we save data through the application, it is save to the appropriate table in the database and we get a confirmation that the data was saved. If the end user tries to navigate to another record or form, the FRM-40401 error pops up asking do we want to save the data. When the user pressed the button to save again, the application responds that there is no data to save. As I stated earlier, the data has been saved to the database on the initial save.

Our developer(former Oracle Forms Instructor & has reviewed the suggestions on Metalink) is stumped and it appears that the Oracle Forms support is too. We are using Oracle 9ias Release 1 with Forms 6i. This problem is only experienced in the production environment. Development & Test do not have this problem. We see this problem both on the app server and connecting directly to the database from a desktop PC.

After a server crashed in May, our production database was moved to another server. At this point, the pop ups began. We believe the problem resides on the database side. Has anyone experienced this problem found a solution by making a change on the database side?

If so, please respond to rperry_at_fleetcor.com

Thanks Received on Fri Aug 08 2003 - 08:30:08 CDT