My Oracle Support Banner

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

Last updated on MARCH 20, 2019

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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.