My Oracle Support Banner

OEXOEORD: ORA-01422 ERROR SALESPERSON IN SALES ORDER FORM (Doc ID 1626798.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Order Management - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

The Salesperson LOV on the Sales Order Form shows multiple records for the same name , and when any of the
record is selected the following error is shown

ERROR
-------

ORA-01422:exact fetch returns more than requested number
of rows in Package OE_Order_Cache Procedure Load_Salesrep_rec


Steps
------
1) Open Sales order form.
2) Enter Sales order Header.
3) Invoke the Salesperson LOV.
4) select one of the multiple values shown.
5) Save.
6) Error, "ORA-01422:exact fetch returns more than requested number
of rows in Package OE_Order_Cache Procedure Load_Salesrep_rec" is shown.

Note: This issue is not restricted to the Sales Order Form alone , but would impact any other form that accesses the Salesperson data

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.