Selecting Locator Causes ORA-01422: Exact Fetch Returns More Than Requested Number Rows in Miscellaneous Transactions (INVTTMTX) and Receiving Transactions (RCVTXERT) (Doc ID 312293.1)

Last updated on APRIL 12, 2017

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
This document includes all versions of Oracle EBS 11i and R12 and later
RCVTXERT.fmb INVTTMTX.fmx
Signature: DUPES_LOCATOR_MTL_ITEM_LOCATIONS

Symptoms

The following error message displays in the Miscellaneous Receipts form (INVTTMTX.fmb) and in the PO Receipt form (RCVTXERT.fmb) when selecting a specific locator:

ERROR
APP-FND-01564: ORACLE error 1422 in FDFGCD
Cause FDFGCD failed due to ORA-01422: exact fetch returns more than requested number of rows

STEPS
Go to Inventory > Transactions > Miscellaneous Transactions
Enter the transaction date, transaction type, and account
Go to the transaction lines
Enter the item number and subinventory
Enter the locator.
When tab out of the locator field, the error occurs.

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