ORA-01002 Fetch Out Of Sequence Error on Purchase Order Summary Form (Doc ID 1400508.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Purchasing - Version 12.1 and later
Information in this document applies to any platform.
POXPOVPO - Purchase Order Summary Form


Symptoms

While accessing Purchase Order (PO) records after canceling out of Control Document window from Purchase Order Summary form, error occurs.

Error:
ORA-01002: Fetch out of sequence

Steps to reproduce:
1. Go to Purchase Order Summary form ( Navigation: Purchase Orders > Purchase Order Summary )
2. On the Find window, enter search criteria to search for a range of POs, for example, date ranges, statuses, etc
3. Click the Find button
4. In the results window, without moving from the first retrieved record, click Tools menu, then Control
5. Click the Cancel button at bottom of the Control Document window (not the Cancel action)
6. When the Control Document window closes, press the Page Down key on the keyboard
7. Error is seen in a popup window as detailed

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms