We recently refreshed our Development database from Production. I reset all the sequences to the minimum value. One of the service accounts, used to log in to the app, gave this error. Research revealed the sequence had not been reset. Reset it, and the error went away. Another service account, that allows users to do things in the app, began giving the same error. Research revealed another sequence had not been reset. This time, that did not fix it. I can run this query: select schema.sequence.nextval FROM DUAL. When logged in as the DBA user, it works. When logged in as the app service account, I get the error in the subject. I can't seem to figure this out. Any idea? My use of sequences is minimal. The database I inherited uses sequences extensively. Just trying to figure it out.
We are using Oracle 19c on a Red Hat 8 server. Thank you.