Cannot RECEIVE a Stock Transfer that has multiple line items via RFGEN (Doc ID 1490251.1)

Last updated on OCTOBER 16, 2016

Applies to:

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

Symptoms

When attempting to RECEIVE a Stock Transfer that has multiple line items via RFGEN, the receipt has a FAILED status and the hand-held shows the following error:


ERROR
-----------------------
" Exact fetch returns more than requested number of rows".


If the Stock Transfer has only a single line item, the receipt is processed correctly.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. In RFGEN, pull up a Stock Transfer with multiple items where the item status is ISSUED
2. Select the RECEIVE transaction
3. Enter the Stock Code
4.. Enter the Quantity
5. Transaction FAILED message is received


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