WAM Error: ORA-01002 Fetch Out of Sequence when Changing Purchase Order (PO) Status from Approved to Issued

(Doc ID 1998764.1)

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Utilities Work and Asset Management - Version and later
Information in this document applies to any platform.


When attempting to change the PO status (for a PO which has a Work Order in the line item Detail view) from Approved to Issued, the application throws the following error message and does not allow the status change:

Error: ORA-01002 fetch out of sequence


1. Select a PO in Approved Status
2. Make sure the PO line item has WO associated to it.
3. Change the Status from Approved to Issued
4. ORA-01002 fetch out of sequence error is displayed


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