"ORA-01002: fetch out of sequence" Error With a Transactional Operation
(Doc ID 1548323.1)
Last updated on JUNE 11, 2018
Applies to:Oracle Commerce Platform - Version 9.1 and later
Information in this document applies to any platform.
**Checked for relevance on 05-09-2016**
You may see a long running operation that uses a transaction failing with a "ORA-01002: fetch out of sequence" error.
NOTE: If this is seen during startup, then use the information provided in the following knowledge base article to resolve this issue:
"java.sql.SQLException: Result set already closed" Errors During Repository Startup [ID 1403726.1]
If you are seeing the problem after the system has completely started up see the Cause and Solution below.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!