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 1.9.1.2 and later
Information in this document applies to any platform.

Symptoms

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
-----------------------
Error: ORA-01002 fetch out of sequence


STEPS
-----------------------

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



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