This was one of the strange situations we faced when we went live with PeopleTools 8.45.17 and Financials 8.8 SP1 Maintenance Pack 3.

After a couple of days that we went live users in Accounts Receivables area started complaining that they can’t enter the deposits any more and the system started throwing them out.

I identified that PGG_SERVICE_TAO. REQUEST_NBR field reached to 9999 and the table is getting locked out and it was not releasing the lock for other people.

The solution to overcome this issue is …..

Either you manually update this field (PGG_SERVICE_TAO. REQUEST_NBR) back to 0  (or) Set the DBFLAGS to 8 in the configuration file and bounce the app server.

For more details on DBFLAGS setting go through the PeopleBooks.
It will set the ‘Disable a persistent second database connection’ action